|
View previous topic :: View next topic
|
| Author |
Message |
veena_nagesh2002
Warnings : 1
Active User
Joined: 07 May 2005
Posts: 110
Location: hyderabad
|
|
|
|
Can some body tell me there are two sort steps in my jcl
ex : sysut1
sysut2
we are sorting the data of sysut1 and writing into sysut2 and in the next step we are taking the output of first step and again sorting and writing into another file. my question is can we do in a single step. |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
Not sure that SYSUT1 & 2 are common sort files.
Please post your JCL |
|
| Back to top |
|
|
Aaru
Senior Member
Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India
|
|
|
|
Veena,
If you can SORT the data from the input files in the first step and the second step, you should be able to use those SORT statements combined in a single step.
As requested, Post your JCL. |
|
| Back to top |
|
|
Prasanthhere
Active User
Joined: 03 Aug 2005
Posts: 306
|
|
|
|
I guess we should be able to do in one step
By the way whats your sort criteria |
|
| Back to top |
|
|
veena_nagesh2002
Warnings : 1
Active User
Joined: 07 May 2005
Posts: 110
Location: hyderabad
|
|
|
|
| Code: |
//STEP060 EXEC PGM=SYNCSORT
//SYSIN DD DSN=AMX.PROD.DATALIB(EFBR2735),
// DISP=SHR
//SORTIN DD DSN=SSR.XXBRX.EFBRD273.SETRANS.UNSORT,
// DISP=SHR
//SORTOUT DD DSN=XXXXXX.XXBRX.EFBRD273.SETRANS.BZROC,
// DISP=(,CATLG,DELETE),
// DATACLAS=STANDARD,
// UNIT=SYSDA
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//*
//STEP010 EXEC PGM=SYNCSORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DISP=SHR,DSN=XXXXXX.XXBRX.EFBRD273.SETRANS.BZROC
//*
//SORTOUT DD DSN=&&TEMP,
// DISP=(,PASS),
// UNIT=SYSDA,
// DATACLAS=STANDARD
//SYSIN DD DSN=AMX.PROD.DATALIB(EFW19991),
// DISP=SHR
|
|
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
Great - My sort criteria are
AMX.PROD.DATALIB(EFBR2735)
AMX.PROD.DATALIB(EFW19991)
Methinks the requestor wants to see what is INSIDE these pds members. |
|
| Back to top |
|
|
veena_nagesh2002
Warnings : 1
Active User
Joined: 07 May 2005
Posts: 110
Location: hyderabad
|
|
|
|
AMX.PROD.DATALIB(EFBR2735)
SORT FIELDS=(7,3,CH,A,10,10,CH,A,20,20,CH,A,5,2,CH,A)
AMX.PROD.DATALIB(EFW19991)
SORT FIELDS=(007,03,CH,A, *SETTLEMENT CURRENCY
010,25,CH,A, *PARTIAL SOC KEY
035,05,PD,A, *IP DATE
005,02,CH,A, *RECORD CODE
079,08,PD,A) *ROC REF NO |
|
| Back to top |
|
|
ksk
Active User
.jpg)
Joined: 08 Jun 2006
Posts: 355
Location: New York
|
|
|
|
| If you want quick reply, post all the details. Without looking into SORT cards, cannot tell whether this can be done in a single step or not. |
|
| Back to top |
|
|
veena_nagesh2002
Warnings : 1
Active User
Joined: 07 May 2005
Posts: 110
Location: hyderabad
|
|
|
|
| posted all the details which ever requested. can you tell me how come my question will depend upon the sort cards. Also give me sample code if its possible |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| can you tell me how come my question will depend upon the sort cards |
Because some things can work together and some things cannot.
You cannot have 2 "sort fields=" in the same sysin of a Syncsort execution. You will get a "duplicate" error - which you can verify by simply trying it on your system. |
|
| Back to top |
|
|
Bill Dennis
Active Member
Joined: 17 Aug 2007
Posts: 562
Location: Iowa, USA
|
|
|
|
Each sort is a different sequence. These cannot be combined.
Is the sorted BZROC file from step 1 used somewhere else?
The current job just happens to need the records in a special sequence (step 2). |
|
| Back to top |
|
|
|
|
