View previous topic :: View next topic
|
Author |
Message |
subramanianup Warnings : 1 New User
Joined: 18 May 2005 Posts: 46 Location: Bangalore, INDIA
|
|
|
|
If the columns in the input are like ACCNO, NAME, BALANCE. How can we create a output file in the format NAME, ACCNO , BALANCE? |
|
Back to top |
|
|
fixdoubts
New User
Joined: 21 Oct 2005 Posts: 54
|
|
|
|
Hi,
Man you should give the field length rather then the names.
Okay lets take 1-10 as ACCNO
11-30 as NAME
31-40 as BALANCE
For a sort your sysin should be
Code: |
SYSIN DD *
SORT FIELDS=COPY
OUTREC FIELDS=(11,20,1,10,31,10)
/*
|
Your out put file will have its NAME,ACCNO,BALANCE
Regards, |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Or using DFSORT symbols:
Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SYMNAMES DD *
ACCNO,1,10
NAME,*,20
BALANCE,*,10
/*
//SORTIN DD DSN=... input file
//SORTOUT DD DSN=... output file
//SYSIN DD *
OPTION COPY
OUTREC FIELDS=(NAME,ACCNO,BALANCE)
/*
|
|
|
Back to top |
|
|
|