View previous topic :: View next topic
|
Author |
Message |
anaik100
New User
Joined: 05 Dec 2006 Posts: 1 Location: India
|
|
|
|
Hi,
I have a requirement to create a delimited output file.
File 1: has columns
a b c d e
in file 2 :
my data order should be
b;d;c;e;a
I can achieve the format of File2 from file1 by using OUTREC.
But i have one more condition. I need to include the column names on the first line and then the data should be copied.
So file 2 output will be in the format
Column1;Column2;column3;column4;column5
b;d;c;e;a
b;d;c;e;a
b;d;c;e;a |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
anaik100,
You can achieve this using the 'HEADER1' parameter of the OUTFIL statement. Search the forum and you will find lot of working code. |
|
Back to top |
|
|
|