Search found 20 matches
- Wed May 21, 2008 6:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Same code works in TEST but not in Production.
- Replies: 2
- Views: 1135
Same code works in TEST but not in Production.
Hi, I need to update the DB2 table in the flow, after inserting the values in the table. This logic is works fine in TEST environment,but when this deployed into production it doesnt. It dint say any error at all. Its in the sequence. If we run the job seperately it works fine. Could any one have fa...
- Tue Dec 06, 2005 12:05 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routines to load data in to a sequential file
- Replies: 9
- Views: 3238
Hi All, Thanks Ray,Ramesh DHL and D for your valuable inputs.Every code which has been published works good in its one way when tested. Once again I thank you all for your valuable suggestions. Hi Ray, Thanks for your comments!! I believe this is knowledge sharing area where we can share our ideas ...
- Sat Dec 03, 2005 4:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routines to load data in to a sequential file
- Replies: 9
- Views: 3238
Try this Routine also!!!
Hi dsquestion, You could try this also!!! TestEOF is your input filename. FILEPATH is the directory. openseq FILEPATH:'/TestEOF' to filehandle else call DSLogFatal('cannot open TestEOF','TestEOF') end Cmd = 'cd ':FILEPATH:'/; wc -l ':'TestEOF' Call DSExecute("UNIX",Cmd,Output,RetCode) Call...
- Tue Oct 18, 2005 3:01 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transformation Rows to columns
- Replies: 4
- Views: 2068
Vertical Pivot
Hi, Please design your job as follows, sourcefile - (columnA,coulmnB)--->SortStage(sortby columnA) --Transformer-HashFile(ColumnA as Key) In Transformer, define 5 stage variables, sorted.test1 = NewVal NewVal<>PrevVal = NotEqual NewVal = PrevVal sorted.test2 = Column2Val If Not(NotEqual) then Column...
- Wed Nov 17, 2004 1:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to convert DATE in internal format for comparison
- Replies: 5
- Views: 3259
Re: How to convert DATE in internal format for comparison
In server job we use Iconv and Oconv to do conversion of date and then compare between the internal values.. how can ido the same in parallel extender... tried using DatetoString but does not work for me please help We can still use Iconv and Oconv in parallel extender by using shared container. It...