|
|
| Author |
Message |
subramanianup
Warnings : 1
New User
Joined: 18 May 2005
Posts: 37
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 |
|
 |
References
|
|
 |
fixdoubts
Active User
Joined: 21 Oct 2005
Posts: 52
|
|
|
|
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 Moderator
Joined: 15 Feb 2005
Posts: 4684
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 |
|
|
|
|
|
