Search found 60 matches
- Wed Jun 20, 2018 4:49 pm
- Forum: General
- Topic: Datastage Repository interface errror
- Replies: 2
- Views: 2610
Datastage Repository interface errror
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...
- Thu Jun 07, 2018 4:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Duplicate Key values in CDC Stage
- Replies: 7
- Views: 6611
Duplicate Key values in CDC Stage
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...
- Wed Jun 06, 2018 12:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage Varchar vs NVarchar
- Replies: 0
- Views: 2245
DataStage Varchar vs NVarchar
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
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
- Tue Jun 13, 2017 11:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove Duplicates
- Replies: 1
- Views: 2121
Remove Duplicates
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
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
- Thu Oct 22, 2015 10:22 pm
- Forum: General
- Topic: Security Patch for DSEngine
- Replies: 4
- Views: 2402
Security Patch for DSEngine
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
We are using DataStage version 9.1 and I need to know if there is a security patch for DS Engine.
Regards
Kumar
- Wed Sep 02, 2015 5:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage job Warning
- Replies: 2
- Views: 2333
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...
- Tue Sep 01, 2015 9:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage job Warning
- Replies: 2
- Views: 2333
Datastage job Warning
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 ...
- Wed Feb 11, 2015 9:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparing Time(7) in SQL server
- Replies: 2
- Views: 2491
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...
- Wed Feb 11, 2015 9:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Connector Delete then Insert (write mode)
- Replies: 3
- Views: 4056
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
- Wed Feb 11, 2015 7:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Connector Delete then Insert (write mode)
- Replies: 3
- Views: 4056
Oracle Connector Delete then Insert (write mode)
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...
- Mon Feb 09, 2015 8:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparing Time(7) in SQL server
- Replies: 2
- Views: 2491
Comparing Time(7) in SQL server
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...
- Tue Jan 20, 2015 9:51 pm
- Forum: General
- Topic: dsrecords not found
- Replies: 2
- Views: 1757
- Tue Jan 20, 2015 9:16 pm
- Forum: General
- Topic: dsrecords not found
- Replies: 2
- Views: 1757
dsrecords not found
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...
- Thu Apr 10, 2014 10:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: loading Timestamp into Oracle
- Replies: 9
- Views: 4738
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...
- Wed Apr 09, 2014 4:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: loading Timestamp into Oracle
- Replies: 9
- Views: 4738
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...