Search found 18 matches

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