Search found 816 matches
- Wed Aug 05, 2015 5:56 pm
- Forum: General
- Topic: Sequence status is 99
- Replies: 18
- Views: 10855
This is the suggestion i got from IBM: InfoSphere DataStage: Problems when running multiple instances of a job from a job sequence, or from a script using dsjob Environment variable: DSWaitResetStartup When multiple instances of a job are run from a sequence, and one or more of the job instances are...
- Tue Aug 28, 2012 11:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Update is not working correctly in Oracle stage
- Replies: 9
- Views: 5455
- Wed Jun 06, 2012 3:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ORA-01722: invalid number
- Replies: 17
- Views: 16793
- Wed Apr 25, 2012 12:07 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: New row in source is not loaded into target table
- Replies: 3
- Views: 3224
- Wed Apr 25, 2012 11:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need Help to Implement Logic
- Replies: 14
- Views: 8521
- Tue Oct 04, 2011 3:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Logic for implementation of the req
- Replies: 4
- Views: 3208
- Wed Mar 30, 2011 1:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to pad zero to a string with out using transformer stage
- Replies: 2
- Views: 2806
- Thu Oct 22, 2009 3:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: error with DRS stage
- Replies: 3
- Views: 3419
- Fri May 29, 2009 3:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error in timestamp_from_string function in Modify stage
- Replies: 1
- Views: 2494
- Tue Mar 17, 2009 1:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: get Current TimeStamp-(MINUS) 1 Day
- Replies: 5
- Views: 7890
- Tue Mar 17, 2009 1:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: remove leading zeros in decimal field in sequential file
- Replies: 26
- Views: 79086
I hope this will solve your issue..
sAM
Code: Select all
Trim(DecimalTostring(In.Col),'0','L')
- Tue Nov 25, 2008 2:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Target table has more data than Source View
- Replies: 2
- Views: 2299
There might be two seperate issues you are facing. ''OCI has fetched truncated data'' There might be some column in the source which is having column length greater than the one in the target. ''ORA-01002: fetch out of sequence '' I would recommend you to search the forum there had been few differen...
- Tue Nov 25, 2008 2:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Increment sequence
- Replies: 2
- Views: 2467
Simple solution will be to use stage variables. Try something like this.... Sort the data on your three columns. Initialize sVValue as 1 sVCurrent = COLA:COLB:COLC sVValue = If sVCurrent = sVPrevious then sVValue+1 else sVValue sVPrevious = sVCurrent And use sVValue in your column derivation of INT ...
- Tue Nov 25, 2008 2:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem with paralle direct load
- Replies: 1
- Views: 1825
- Tue Nov 25, 2008 2:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Adding the amount column value from Sequencial file.
- Replies: 4
- Views: 2398