DSXchange

Hi All, We have jobs failing to run occasionally with the following error message.. Error calling DSRunJob(Job_name), code=-99 [General repository interface 'other error'] We have 35 jobs that are scheduled to start running at same time.. Is there any limit to invoke DSRunJob causing this issue. Any...

Hi All, Can CDC stage handle duplicates.. We have a scenario where duplicate values coming in for KEY column.. The job produce different results upon running multiple times.. The job does join on KEY column and produce multiple records for the same key column.. But the change codes are not consisten...

Hi All,

I have a scenario where I am mapping a column of type Varchar to Nvarchar.

Upon running the job I get a result which is different when I pass the column as varchar.

Can anyone please shed some light with regards to Varchar vs Nvarchar in DataStage terms..


Regards
Kumar

Hi All,

Is it possible to remove duplicates by Ignoring case sensitive in Data Stage..

Example:

Name:

Steve
STEVE

Can I remove duplicates on the above..

Regards
Kumar

Hi All,

We are using DataStage version 9.1 and I need to know if there is a security patch for DS Engine.

Regards
Kumar

I am running this job from Control-M and I do checked the option to reset before run. I am calling the job sequence which will run the multi instance job. It's strange that the error message is not consistent every day. We had a clean run in production last night. The error message is very random. C...

Hi All, I am currently having issue with a multi instance job in Datastage which is triggered from Control-M. The job is failing with the following error message: Parameter set must be reset before it can rerun. I verified the parameter set on the server and it is all good. Can someone please point ...

Time(7) in SQL Server is DateTime2. When comparing Time from Datastage to DateTime2 in SQL server it's issuing a error message as mismatch in Datatypes. We then agreed to change the datatype in the target SQL Server to DateTime which is equivalent to TimeStamp in DataStage. We are now able to compar...

I misunderstood the concept of DelethenInsert: It actually deletes the matched records and then inserts the new records. I used the option beforeSQLstatement to actually delete the records in the table and then I selected the write mode as Insert to actually insert the records. All good. Regards Kumar

Hi, I am trying to write into an Oracle table with writemode as 'deletethenInsert' I am using user defined queries. To my knowledge this should run the delete query first and then insert the query. Looking at the logs it shows that it is performing delete and insert simultaneously. Any idea on how t...

Hi, I have a scenario where I need to compare time datatype from Datastage to Time(7) in SQL server in my update query. Upon running below is the error message I get The data types time and datetime2 are incompatible in the is operator ODBC function is reading Time(7) as DateTime2 data type which is...

Thanks for your prompt reply.

All good. Working now.

Regards
Kumar

Hi, I am trying to execute the following shell script from my job sequence #!/bin/sh cd /proj/DataSets/ Count=`dsrecords Test.ds |awk -F ' ' '{ print$1 }'` if [ "$Count" == 0 ]; then echo "PREVIOUS" else echo "CURRENT" fi; Upon execution I get the following message. /ho...

Hi All, The issue has been resolved. We are loading the table from a file and we are using a schema file to load the column definitions. In 8.5 we are defining the column definition as timestamp in the schema file and it is populating the time component perfectly fine. In 9.1 we are using the same f...

The Oracle datatype is Timestamp(6) and the column we are loading in is of datatype timestamp. Example: Record in 9.1 RMA_DATE Database 20140225 060253 25/FEB/14 12:00:00.000000000 AM Record in 8.5 RMA_DATE Database 20140225 060253 25/FEB/14 06:02:53.000000000 AM Also tried to run the job by setting...