jackare
New User
Joined: 27 Aug 2008 Posts: 35 Location: Brazil
|
|
|
|
Bill Woodger wrote: |
Since you have SyncSORT, why don't you just try it? |
Bill,
In a single step using a DB2 query would be like this
Code: |
//SORTSQL EXEC PGM=SYNCSORT,PARM='DB2=DSN'
//SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,20)
//SORTWK02 DD UNIT=SYSDA,SPACE=(CYL,20)
//SORTDBIN DD *
SELECT COD_PRODUCT, NAME_PRODUCT
FROM DB2LST.PRODUCT
WHERE STATUS = 'P';
/*
//SORTIN DD DUMMY
//SORTOUT DD DSN=<output dataset name>,
// DISP=(,CATLG,DELETE),
// LRECL=80,RECFM=FB,BLKSIZE=0,
// SPACE=(CYL,(500,50),RLSE),MGMTCLAS=WORKM
//SYSOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY
/* |
So how to code in the same step the "SORTJNF1" with the result of the DB2 query and "SORTJNF2" with another sequential file previously generated in another JOB ? |
|