Sequential file stage record delimiter

bkar · Post by **bkar** » Wed Jun 01, 2011 6:51 am

How I can have record delimiter as DOS newline character.

I'm extracting table data to a flat file and sequential file stage is my target.

chulett · Post by **chulett** » Wed Jun 01, 2011 7:03 am

Use a Record Delimiter String as that DOS 'newline' is actually two characters.

bkar · Post by **bkar** » Wed Jun 01, 2011 7:08 am

chulett wrote:Use a Record Delimiter String as that DOS 'newline' is actually two characters. ...

could not get what you mean by two characters.

Do i need to put "\N"?

chulett · Post by **chulett** » Wed Jun 01, 2011 7:24 am

No. UNIX uses a LF for a record delimiter while DOS uses a CR/LF pair. To implement a DOS newline, use the Record delimiter string property set to ″\R\N″ or chooseFormat as → DOS line terminator from the shortcut menu. This is straight from the docs.