Search found 6797 matches
- 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
- 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
This searches all occurances of '||' and replaces it with '|'.
Something like
Code: Select all
sed 's/||/|/' myFile.txt
This searches all occurances of '||' and replaces it with '|'.
- 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
- Tue Jan 02, 2007 7:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem while loading Oracle Tables
- Replies: 12
- Views: 2721
See if this post helps.
- Tue Jan 02, 2007 3:42 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Relicensing an expired license
- Replies: 2
- Views: 672
- 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.
- 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...
- 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
- 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
- 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
- Tue Jan 02, 2007 1:46 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Corrupt Sequence...???
- Replies: 3
- Views: 926
- 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
- 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
In the constraint of the reject link, specify
For the regular link provide constraint
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'
- 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
- 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