DSXchange

We have 4 address fields in sources. Each filed may contain city, state,country,postcode in any order. We have to combine all these fields and match the data against the rules sets for country,city,state and postcode and if match is found, we have to lael the data. ex: source data "Hyderabad In...

Fix Pack 1 is required for this issues.

Installed Fix pack 1 and all jobs are compiling OK.

I was using a datastage client which didn't had FixPack 1, or anyof the fix packs installed.

Hi, Is there anyway that Data Columns apart from ERRORCODE and ERRORDESC from reject link in ODBC Connector Stage can be controlled from propagating to next stages? I am asking this query because there are couple DataStage Jobs which are running in Production environment but stopped working in Syste...

Tried with Importing a single Job without executables and dependent objects.

Same error - " Not Attached to a Job".

Bit worried thinking we have to re-design in DS9.1

Hi, We are trying to Import bunch jobs from DataStage version 8.5 to version 9.1. But the Import failed with error - " Not attached to a job" for job designs. Similarly it throws an error - " Class=DSRECORD " for job executables. Options tried are - 1. Tried changing proxy - http...

SQL Server database records had multiple Control Characters. There are various control Characters involved and SCD Stage (type-1) needs data to be control Characters free. So I have shifted to use CDC (Change Data Capture) along with IANAAppCodePage=2252 in 'odbc.ini' file and issue has sorted out. ...

Hi, I use SQL Server as source and Oracle as Destination database. Am following SCD-Type 1 approach. When SCD Stage is in place, it always sends data as changed data even though there are no Changes literally happened at source. SQL Server database has : COLLATION_NAME as - "SQL_Latin1_General_...

I use MS-SQL Server as Source System and Oracle as Target System. Our customer follows some annoying coding standards and one of them is not to use User-Defined queries at oracle side while INSERT/UPDATE. So I used NEW_GUID() in SQL Server while selection and populating the Oracle database. Many tha...

Hi,

What is the quivalent function in DataStage to generate sys_guid() value for each row as surrogate key.

Oracle has - sys_guid() function, any equivalent function in DataStage ?

select sys_guid() from dual

Compared the Driver versions and ODBC DSN connections, all seems similar.
Anyway we raised a PMR for this IBM. awaiting response.

Didn't able to locate - bulk insert mode" enabled in Windows ODBC driver.
Meanwhile where can we verify it ? Could you suggest or point me there, please?

Hi, Hit with below error, as it's working in all environments except production environment. we are using ODBC connector to connect to SQL Server. In all environments the array size and record count is - 2000 (default). odbc_lccyp,0: This driver does not support retrieving execution status for each ...

All other jobs are working with same user and more over same procedure being triggered from different jobs with different hardcoded value.

I feel it's related to database, SQL server.

Forgive... Didn't address the core issue.

'dsjob' command is trying to write stdout into "nohup.out " file, causing job to wait.

To resolve what we did is, redirected both stdout and stderr into /dev/null.

hi all, Trying to Invoke a SQL-Server Stored procedure from DataStage. Am encountering below Fatal error. a. Unfortunately same stored procedure is invoked in different job with same input parameter and is working fine. b. Also, same job is working fine in other enviroments. c. Stored procedure is w...

nohup didn't work either. Thinking on the situation I just redirected the stdout & stderr :idea: . Just to rest in peace. ${DS_BIN_DIR}/$DSJOB_LOGON_CLAUSE -run -mode NORMAL -param ${DS_PARAMETERSET_LIST} -param jpFileName=${FILE_NAME} -param jpFileExtn=${FILE_EXTN} ${DS_PROJECT} ${DS_JOBNAME}....