Search found 18 matches
- Fri Dec 05, 2008 8:51 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Parsing Multi-Length Strings
- Replies: 1
- Views: 1028
Parsing Multi-Length Strings
I have a programming problem that I can't figure out how to do in DS Server ... I have a column that can contain the following example set of values: WRX-0001 WRX-0001.r1 WRX-0001.r2 RERWEEW-0001 RERWEEW-0001.r1 RERWEEW-0001.r2 I am trying to figure out how to read in a string, parse it as array, st...
- Fri Nov 07, 2008 3:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to load data with Special Characters
- Replies: 4
- Views: 2129
Thanks for the information so far ... the XML Best Practices information seems to be helping us ... Here is what we are doing. Based on a specific set of extract criteria, we use a DB2 API stage to pull data and land in a file (whether it be XML or Sequential). Due to the facts that any possible typ...
- Thu Nov 06, 2008 8:44 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to load data with Special Characters
- Replies: 4
- Views: 2129
How to load data with Special Characters
Hi and thanks for reading ... We have a database that we are extracting from that has the possibility of ALL and ANY special characters that is humanly / computerly (is that a word?) possible. So ... We can't use a pipe (|) delimiter or any other type of delimiter. If our data was just varchar, we c...