|
|
| Author |
Message |
Unique
New User
Joined: 10 Jul 2007
Posts: 27
Location: Blore
|
|
|
|
I want to combine the data of file1 which is a FB and data of file2 which is VB into a file FILE3 which is VB similar to FILE2.
| Code: |
//STEP1 EXEC PGM=SYNCSORT
//SORTIN DD DSN=FILE1,DISP=SHR
// DD DSN=FILE2,DISP=SHR
//SORTOUT DD DSN=FILE3,DISP=OLD
//SYSOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY
//*
|
i tried the above code, but i am getting abend.can you please guide.
Regards |
|
| Back to top |
|
 |
References
|
 Posted: Wed Mar 26, 2008 12:30 am Post subject: Re: Insert FB records in a file with VB |
|
|
|
|
dick scherrer
Global Moderator
Joined: 23 Nov 2006
Posts: 6724
Location: 221 B Baker St
|
|
|
|
Hello,
You need to post the entire diagnostic output.
You will probably need to copy the fb data to vb and then combine the vb files. |
|
| Back to top |
|
|
Richa Jain
New User
Joined: 18 Mar 2008
Posts: 27
Location: Chennai
|
|
|
|
I donno if it is possible with syncsort..
You need to add a step to copy FB file(file1) into a temporary VB file using IEBGENER.
| Code: |
//STEP1 EXEC PGM=IEBGENER
//SYSIN DD DUMMY
//SYSUT1 DD DSN=TEST.INPUT.FB.FILE1,
// DISP=SHR
//SYSUT2 DD DSN=TEST.OUTPUT.VB.TEMP,
// DISP=(NEW,CATLG,DELETE),
// SPACE=(CYL,(1,1),RLSE),
// DCB=(RECFM=VB,LRECL=84,BLKSIZE=6720)
//SYSPRINT DD SYSOUT=*
|
In second step you can use sort to combine the two files (tempfile and FILE2) into FILE3 [/code] |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 2435
Location: Brussels once more ...
|
|
|
|
Both files need to be of the same format, either FB or VB.
Use SORT to convert the FB into VB, and then merge the files. |
|
| Back to top |
|
|
|
|
