Carriage Return ^M ascii character 13

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
edmtenzing
Premium Member
Premium Member
Posts: 22
Joined: Wed Jul 23, 2008 5:59 pm
Contact:

Carriage Return ^M ascii character 13

Post by edmtenzing »

Hi,
I need to include the carriage return ascii char 13 or ^M at the end of the record.

I have tried these using the sequential file properties, format

1. Record delimiter string = DOS format
2. Final delimiter string = \13 ---> this give me the output ^K, but if i tried other numbers, ^M still does not come out.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

DOS-style Record Delimiter String gives \x0D\x0A (CR/LF).

A simple CR at the end is a very unusual requirement. Are you totally certain that's what you want?

If so try using hex notation (\x0D).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
edmtenzing
Premium Member
Premium Member
Posts: 22
Joined: Wed Jul 23, 2008 5:59 pm
Contact:

Post by edmtenzing »

Thanks! It does not work using hex notation (\x0D).

But tq for prompting the rare case using that CR only, I rechecked again, and found out that they actually need the Carriage Return & Line Feed.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

My bad. :oops:

Should have been &h0D
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
edmtenzing
Premium Member
Premium Member
Posts: 22
Joined: Wed Jul 23, 2008 5:59 pm
Contact:

Post by edmtenzing »

I tried this &h0D, but gave me fatal error
if i put backslash \ prior to that, it will actually print out the string itself

main_program: Syntax error: Error in "export" operator: Error in operator arg: Error parsing schema: In top-level property list: Expected value for property "final_delim_string", got: "&", line 44
Post Reply