Eric,
Thank you very much for providing the solution.
Thanks
Vineet
Search found 21 matches
- Wed Apr 25, 2012 4:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need Help to Implement Logic
- Replies: 14
- Views: 8460
- Wed Apr 25, 2012 3:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need Help to Implement Logic
- Replies: 14
- Views: 8460
- Wed Apr 25, 2012 11:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need Help to Implement Logic
- Replies: 14
- Views: 8460
- Tue Apr 24, 2012 7:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need Help to Implement Logic
- Replies: 14
- Views: 8460
- Tue Apr 24, 2012 6:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need Help to Implement Logic
- Replies: 14
- Views: 8460
Need Help to Implement Logic
Hi, I am trying to implement the following scenario which came up as part of our recent requirements. I have stated the logic below. We have a Product table which has with Product and Amount as it's attributes. Product ID Amount FX123 100 Ab234 200 XZ567 300 SD234 400 As per the logic we have to com...
- Thu Jun 09, 2011 3:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Identify dead job threads
- Replies: 4
- Views: 2556
Re: How to Identify dead job threads
Every job will have a unique process id associated with it.Please log on to the unix box and see the process id's against the User. Then you can kill the corresponding process id's.
Thanks
Vineet
Thanks
Vineet
- Mon Nov 01, 2010 11:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage 7.5 to SQL Server Connection
- Replies: 5
- Views: 4341
Here go with the exact Warning message from the log : DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO sbc_nform_DS_db.SBCdbo.PS_TNT_GTR_MID_MM(FI_INSTRUMENT_ID, ASOF_DT, PF_SYSTEM_CODE, DEPTID, CUST_ID, PRODUCT_ID, CURRENCY_CD, BASE_CURRENCY, SRC_SYS_ID, TRANSACTION_DT, FI_COMMITMENT...
- Mon Nov 01, 2010 9:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage 7.5 to SQL Server Connection
- Replies: 5
- Views: 4341
- Mon Nov 01, 2010 8:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage 7.5 to SQL Server Connection
- Replies: 5
- Views: 4341
Datastage 7.5 to SQL Server Connection
We are trying to push data from Oracle Database to SQL Server. I have a couple of jobs. Some jobs run fine but some are behaving very weird. I am using Dynamic RDMS stage to read data from Oracle and ODBC stage to write into SQL Server. Couple of jobs run fine when Array Size is tweaked(Default is s...
- Fri Apr 02, 2010 12:29 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job Locked
- Replies: 10
- Views: 5324
- Thu Apr 01, 2010 3:52 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal termination of stage tfmr detected
- Replies: 10
- Views: 14691
- Thu Apr 01, 2010 3:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How can I backup DataStage jobs?
- Replies: 4
- Views: 3210
- Thu Apr 01, 2010 3:20 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to get quarter date format
- Replies: 8
- Views: 4026
- Thu Apr 01, 2010 3:12 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: SAS stage
- Replies: 3
- Views: 2614
Re: SAS stage
Could you please specify which Datastage Version you are using. The SAS plugin satge is available in Datastage Parallel edition. We don't have the option of SAS plugin in Datastage Server Edition.
- Tue Feb 23, 2010 10:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal termination of stage tfmr detected
- Replies: 10
- Views: 14691