View previous topic :: View next topic
|
Author |
Message |
prathap_ts Warnings : 1 New User
Joined: 07 May 2005 Posts: 9 Location: Duluth, US
|
|
|
|
i am having 2 ps say PS1 & PS2, both are having 10 records each, but in that records 3 are identical in both ps,now i want to copy that identical records to another ps say PS3 only through JCL. Can anyboby help me plz? |
|
Back to top |
|
|
Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005 Posts: 463
|
|
|
|
Hi,
Quote: |
i want to copy that identical records to another ps say PS3 only through JCL |
Try following code, you will get all identical records in PS3.
Code: |
//PSTEP01 EXEC PGM=SORT
//SORTIN DD DSN=PS1,DISP=shr
// DD DSN=PS2,DISP=shr
//SORTOUT DD DSN=<output dataset-1>,
// DISP=(new,catlg,delete)
//SORTXSUM DD DSN=PS3
// DISP=(new,catlg,delete)
//SYSIN DD *
SORT FIELDS=(1,10,CH,A)
SUM FIELDS=NONE,XSUM
/*
//SYSOUT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=* |
Hope this helps
Regards
Rupesh |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Quote: |
3 are identical in both ps,now i want to copy that identical records to another ps say PS3 |
It's not clear what you want to do for the 3 identical records. Do you want to copy all 3 records to PS3, or do you want to copy just the second and third record (but not the first) to PS3, or what? Are there matches and non-matches between PS1 and PS2? If so, what do you want to do about the matches and non-matches? Are there matches within PS1 or PS2? If so, what do you want to do about the matches within each file?
Please show an good example of the records in each input file and what you want the output file (or files?) to look like. Don't make us guess what you want. |
|
Back to top |
|
|
|