Search found 20 matches

by rameshDHL
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...
by rameshDHL
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 ...
by rameshDHL
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...
by rameshDHL
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...
by rameshDHL
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...