Need to generate an empty line.

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
bicap
Premium Member
Premium Member
Posts: 95
Joined: Mon May 03, 2010 10:22 pm
Location: India
Contact:

Need to generate an empty line.

Post by bicap »

Hi everyone
I have a requirement. My source file contain 3 types records Header follows with Item and Control records. Every file contain N number of these record sets. My requirement is after every set of these records I have to generate an empty line. Below is the example. Can anyone help me on this.

Input
------
HDR
ITM
CTR
HDR
ITM
CTR
HDR
ITM
CTR


Output
--------
HDR
ITM
CTR

HDR
ITM
CTR

HDR
ITM
CTR
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Add an extra line terminator character to the end of each CTR record.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
bicap
Premium Member
Premium Member
Posts: 95
Joined: Mon May 03, 2010 10:22 pm
Location: India
Contact:

Post by bicap »

Hi Ray,
Thanks for your response.

You mean \n ?

Thank you.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Yes. If you are using default UNIX sequential file terminators, putting a CHAR(10) in your job will add a line feed.
Post Reply