|
View previous topic :: View next topic
|
| Author |
Message |
ajayvamsi
New User
.jpg)
Joined: 21 Jul 2005
Posts: 56
Location: Hyderabad
|
|
|
|
Hi all,
I have a requirement to split a record into different records
ex:
my input file is as follows
aaa bbb ccc ddd
111 222 333 444
now my outfile should be as
aaa
bbb
ccc
ddd
111
222
333
444
will it be possible using sort please suggest me in detail..!!
Thanks,
ajay |
|
| Back to top |
|
 |
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
|
|
Use the slash (/) to force a line-feed:
| Code: |
//SYSIN DD *
OPTION COPY
OUTREC FIELDS=(1,3,/,5,3,/,9,3,/,13,3)
/*
|
|
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
Superk,
/ is not allowed in the OUTREC statement. / can only be used with the OUTFIL statement. So the correct statement would be:
| Code: |
OUTFIL OUTREC=(1,3,/,5,3,/,9,3,/,13,3)
|
|
|
| Back to top |
|
|
ajayvamsi
New User
Joined: 21 Jul 2005
Posts: 56
Location: Hyderabad
|
|
|
|
Thanks alot it is working fine ...!!
ajay.k |
|
| Back to top |
|
|
|
|
