I had Records in file Like this
Company Code
IBM 2
IBM 1
IBM 4
WIPRO 3
WIPRO 2
WIPRO 9
TCS 4
TCS 6
TCS 3
i want the record of every company with highest code How can
i do that?
Answers were Sorted based on User's Feedback
Answer / sathish
//STEP1 EXEC PGM=SORT
//SORTIN DD *
IBM 2
IBM 1
IBM 4
WIPRO 3
WIPRO 2
WIPRO 9
TCS 4
TCS 6
TCS 3
//SORTOUT DD DSN=D362967.TEST.PS1,DISP=SHR
//SYSOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=(1,12,CH,D)
/*
//STEP1 EXEC PGM=SORT
//SORTIN DD DSN=D362967.TEST.PS1,DISP=SHR
//SORTOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=(1,5,CH,A)
SUM FIELDS=NONE
/*
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / sk
Sort the file in decrement order , the key of sort is
Company name and company code, and also use SUM FIELDS =
NONE , then it will remove the duplicates also
| Is This Answer Correct ? | 0 Yes | 0 No |
How many types we can give input to JCL
Can we browse or edit the GDG dataset if it is a tape entry?
i need some shortcuts and tso commands can any on ehelp me in these ?
what is full form of AIX
How do you submit a JCL under CICS environment ?
Explain how can an in-stream dataset be terminated?
If your job fails at particular step then what would be the return code for next steps
What is the format of comment statement?
Differentiate between the joblib and the steplib statements?
MOD, DELETE; What does a disposition of (,DELETE) mean ?
wht happens if cond=true ? pls give me with an example ?
hi friends........if u know syntax of IEBEDIT IN JCL