View previous topic :: View next topic
|
Author |
Message |
Niki
Active User
Joined: 20 Sep 2008 Posts: 106 Location: Bangalore
|
|
|
|
Hi,
I got a requirement to delete two columns from a record having 7 columns.
The column position starts from pos (7 to 10) and from (15 to 30).
The lrecl of my file is 80. and the output record's lrecl = 60.
This can be achieved by some DFSORT card it seems.
Could you all please help me regarding this. |
|
Back to top |
|
|
srinivas_cog
New User
Joined: 05 Jun 2008 Posts: 17 Location: chennai
|
|
|
|
Use outrec to get what ever the fileds you want.
Ex : Input is having NAME:1 to 10 , SSN: 11 to 20, DOB: 21 to 30
If you want only NAME and DOB you can give like
OUTREC FIELDS=(1:1,10,11:21,30) here i haven't given SSN |
|
Back to top |
|
|
Niki
Active User
Joined: 20 Sep 2008 Posts: 106 Location: Bangalore
|
|
|
|
Thanks.......
that worked..... |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Quote: |
I got a requirement to delete two columns from a record having 7 columns.
The column position starts from pos (7 to 10) and from (15 to 30).
The lrecl of my file is 80. and the output record's lrecl = 60. |
The DFSORT job for that would be as follows:
Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=... input file (FB/60)
//SORTOUT DD DSN=... output file (FB/40)
//SYSIN DD *
OPTION COPY
OUTREC BUILD=(1,6,11,4,31,30)
/*
|
|
|
Back to top |
|
|
|