Hi Chullet,
Here is i have my input column1 have 'USD' and second column2 have 'GBD' so based on first point i need to get column2 value 'GBD'
becuse it is in firsr alphabatical order, how can we do in datastage job?
and my input data is dabase table.
Search found 154 matches
- Thu Jul 09, 2015 11:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How can we get records in first and second alphabetically
- Replies: 4
- Views: 2818
- Thu Jul 09, 2015 10:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How can we get records in first and second alphabetically
- Replies: 4
- Views: 2818
How can we get records in first and second alphabetically
Hi All, I have two coulmns column 1 and column 2, i need to get the records in first and second alphabatical order 1)Select 'column1' or 'column2 'based on which value populated comes first alphabetically 2)Select 'column1' or 'column2 'based on which value populated comes second alphabetically 3)Se...
- Mon May 27, 2013 11:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 "Delete" failing with Transaction log full msg
- Replies: 8
- Views: 6259
Use APT_RDBMS_COMMIT_ROWS for DB2. Default is 2048. ... Hi Chulett, I tried the option you mentioned set, APT_RDBMS_COMMIT_ROWS=500000 and also tried with Insert array size=500000.... still job is failing with same reason. Any other options?? FYI The log size is set to 25GB in DB2.. Error: Failure ...
- Mon May 27, 2013 8:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 "Delete" failing with Transaction log full msg
- Replies: 8
- Views: 6259
- Mon May 27, 2013 7:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 "Delete" failing with Transaction log full msg
- Replies: 8
- Views: 6259
DB2 "Delete" failing with Transaction log full msg
Hi Friends, I am facing a serious issue in production. There is a job which deletes records from a table every week end from datastage using ODBC enterprice stage. Target DB:DB2 V9X Records to be deleted every time:around 7.5 million total size of the table: 18.5 million records Failing with the rea...
- Fri Apr 05, 2013 8:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: getting erroe on Decimal values update
- Replies: 4
- Views: 3257
- Fri Apr 05, 2013 7:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: getting erroe on Decimal values update
- Replies: 4
- Views: 3257
- Fri Apr 05, 2013 5:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: getting erroe on Decimal values update
- Replies: 4
- Views: 3257
getting erroe on Decimal values update
Hi , I am trying to update 3000 records from dataset to DB2 table.(dataset-->XFM-->odbc connector) but I am getting the following error and job aborts.I have 12 I/p fields and I can update without any failure if I remove decimal fields.but with decimal fields, its failing I/P field A =Decimal(18,2) ...
- Fri Mar 22, 2013 10:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complex flat file with constraint
- Replies: 1
- Views: 1870
Complex flat file with constraint
We are reading an EBCDIC data file successfully with cff stage but there's one issue- not able to use constraint on the Output tab with a job parameter. The requirement is to filter out certain records and if I hard-code the value it works fine but not when I use a job param. Funny thing is the drop...
- Fri Mar 15, 2013 12:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date conversion
- Replies: 2
- Views: 2550
Date conversion
Hi My incoming data is this way m/dd/yyyy ,mm/d/yyyy, mm/dd/yyyy, m/d/yyyy so the target should be in this format yyyy-mm-dd(datastage default format). For m/dd/yyyy if there is 2/24/2011 then i should populate it as 02/24/2011 For mm/d/yyyy if there is 12/2/2011 then i should populate it as 12/02/2...
- Thu Mar 14, 2013 3:10 pm
- Forum: General
- Topic: Design scenario for calling sequence multiple times
- Replies: 9
- Views: 4088
Thanks for the responses. I'm unsure whether I can write to a file and read from it as the params are passed via a UNIX script.... And to answer the frequency of reset Q, I'm not sure about that one either. All I know is that they have to be unique for every run and there may be thousands of run for...
- Thu Mar 14, 2013 10:30 am
- Forum: General
- Topic: Design scenario for calling sequence multiple times
- Replies: 9
- Views: 4088
- Thu Mar 14, 2013 9:57 am
- Forum: General
- Topic: Design scenario for calling sequence multiple times
- Replies: 9
- Views: 4088
- Thu Feb 28, 2013 9:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Connector Warning
- Replies: 1
- Views: 1915
Oracle Connector Warning
Hi I am getting a warning when using oracle connector The connector was configured to run in parallel mode on 8 nodes, but the partitioned reads were not enabled. The connector will run in sequential mode. Then the job is getting aborted with error as Parallel job reports failure (code 256) Please c...
- Tue Feb 26, 2013 5:08 pm
- Forum: General
- Topic: Design scenario for calling sequence multiple times
- Replies: 9
- Views: 4088