Control characters as Delimter in a seq File

nansekar · Post by **nansekar** » Tue Jan 07, 2014 1:25 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 07, 2014 2:25 am

When you import the table definition for the sequential file specify 001 (three digit decimal ASCII code) as the delimiter.