View previous topic :: View next topic
|
Author |
Message |
badal_mainframe
New User
Joined: 10 Aug 2004 Posts: 7
|
|
|
|
I HAVE THREE PHYSICAL SEQUENTIAL FILES-- PS1,PS2,PS3.
PS1 HAVING RECORDS
MADRID
JOHN
GEORGE
DR TOWN
HALL
PS2 HAVING RECORDS
DANNY
BEKHAM
MADRID
GILCHIST
HALL
MY PROBLEM IS --------
PS3 WILL CONTAIN RECORDS THOSE ARE IN PS1 BUT NOT IN PS2-HOW! USING ANY UTILITY U CAN ? |
|
Back to top |
|
|
sandip_datta
Active User
Joined: 02 Dec 2003 Posts: 150 Location: Tokyo, Japan
|
|
|
|
You can try this code if you have DFSORT. Look that the input file2 has been concatenated twice.
Code: |
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//CON DD DSN=... input file1
// DD DSN=... input file2
// DD DSN=... input file2
//OUT DD DSN=... output file
//TOOLIN DD *
SELECT FROM(CON) TO(OUT) ON(1,87,CH) NODUPS
/* |
Regards,
Sandip. |
|
Back to top |
|
|
sandip_datta
Active User
Joined: 02 Dec 2003 Posts: 150 Location: Tokyo, Japan
|
|
|
|
I am sorry not to mention in my above post. You should put your record length instead of "87". I have just copy paste from my code.
Regards,
Sandip. |
|
Back to top |
|
|
mmwife
Super Moderator
Joined: 30 May 2003 Posts: 1592
|
|
|
|
You left out an important piece of info. What should P3 look like?
Regards, Jack. |
|
Back to top |
|
|
badal_mainframe
New User
Joined: 10 Aug 2004 Posts: 7
|
|
|
|
sandip_datta wrote: |
You can try this code if you have DFSORT. Look that the input file2 has been concatenated twice.
Code: |
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//CON DD DSN=... input file1
// DD DSN=... input file2
// DD DSN=... input file2
//OUT DD DSN=... output file
//TOOLIN DD *
SELECT FROM(CON) TO(OUT) ON(1,87,CH) NODUPS
/* |
thanx lot
Regards,
Sandip. |
|
|
Back to top |
|
|
|