Page 1 of 1

Control characters as Delimter in a seq File

Posted: Tue Jan 07, 2014 1:25 am
by nansekar
Hi All

Is it posible to have a Control Character as delimter in datastage.
We have a requirement to geenrate a seq file with ^A as delimter.

Please let us know if we have any options to specify it in Datastage.

Source: DB2
Target: Seq File
Delimiter : 0x01( ^A)

In Addition to it , we also need the file in the UTF-8 format, Please let me the options to be specified for the same.

Posted: Tue Jan 07, 2014 2:25 am
by ray.wurlod
When you import the table definition for the sequential file specify 001 (three digit decimal ASCII code) as the delimiter.