Search found 6797 matches

by DSguru2B
Tue Jan 02, 2007 10:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: px version of Ereplace()
Replies: 51
Views: 66642

Good suggestion. I am not exactly sure if its going to help but if I'll do that anyways, when i enhance it to handle the 'begin' part as well, sometime in the near future.
by DSguru2B
Tue Jan 02, 2007 10:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential file Import problem
Replies: 11
Views: 4035

I think sed should be enough.
Something like

Code: Select all

sed 's/||/|/' myFile.txt


This searches all occurances of '||' and replaces it with '|'.
by DSguru2B
Tue Jan 02, 2007 10:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem while loading Oracle Tables
Replies: 12
Views: 2721

Nah...just a friendly reminder for our dsxians that its "all" covered. :wink:
by DSguru2B
Tue Jan 02, 2007 3:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Relicensing an expired license
Replies: 2
Views: 672

You the man Craig. :wink:
by DSguru2B
Tue Jan 02, 2007 3:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Function to Replace a string with replacement string ?
Replies: 11
Views: 6258

Check thisrecent post out. See if you bump into any problems.
by DSguru2B
Tue Jan 02, 2007 3:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: px version of Ereplace()
Replies: 51
Views: 66642

px version of Ereplace()

Hi Dxsians, I wrote a px version of Ereplace(). It is not complete. I would say it is about 80% complete. The following syntax is directly out of DS help Ereplace (string, substring, replacement [ ,number [ ,begin] ] ) The code that I prepared does everything except the "[ ,begin]" part. I d...
by DSguru2B
Tue Jan 02, 2007 1:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to create multiple rows from a row
Replies: 10
Views: 3766

Pivot stage. Read the pdf help for specific ways to accomplish your task.
by DSguru2B
Tue Jan 02, 2007 1:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link Collector does not support active to active input or
Replies: 5
Views: 5035

But it does support interprocess active to active links.
by DSguru2B
Tue Jan 02, 2007 1:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: input file dataset doesnot exist
Replies: 5
Views: 2635

Search is your best friend. Check this out
by DSguru2B
Tue Jan 02, 2007 1:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Corrupt Sequence...???
Replies: 3
Views: 926

Make sure your parent sequencer is passing username for username and password for password to the child sequence.
by DSguru2B
Tue Jan 02, 2007 9:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting number of rows for Stages or Links
Replies: 3
Views: 1917

Where are you using those functions ? Is it inside the job, and if yes, where inside the job ?
by DSguru2B
Tue Jan 02, 2007 8:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: reject rows thru column derivation
Replies: 7
Views: 5613

Specify a stage variable say 'cond'. Its derivation will be

Code: Select all

If (DSLink3.SRV_ARE_RST_MDL_ID=46162) OR (currentUPC <> lastUPC) then 'X' else 'Y'


In the constraint of the reject link, specify

Code: Select all

cond = 'Y'


For the regular link provide constraint

Code: Select all

cond = 'X'
by DSguru2B
Tue Jan 02, 2007 7:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 connection required through shell script
Replies: 4
Views: 1851

Need to take a look at your script. And are you passing the variables to a script with a comma in between ???
by DSguru2B
Tue Jan 02, 2007 7:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link Collector does not support active to active input or
Replies: 5
Views: 5035

Great, you can mark it as resolved now.