|
View previous topic :: View next topic
|
| Author |
Message |
Dasarathy
New User
Joined: 20 May 2014
Posts: 5
Location: india
|
|
|
|
| I need to sort 2 different input files and sorted output also should be in 2 different files. How can i do this in a single sort step? |
|
| Back to top |
|
 |
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| Show some sample input, expected output, output you receive from what you have tried, RECFM and LRECL. |
|
| Back to top |
|
|
Dasarathy
New User
Joined: 20 May 2014
Posts: 5
Location: india
|
|
|
|
| We dont have enough steps in the JOB.. we have to complete it in 1 step... |
|
| Back to top |
|
|
Dasarathy
New User
Joined: 20 May 2014
Posts: 5
Location: india
|
|
|
|
| Code: |
//STEP02 EXEC PGM=SYNCTOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//SORTIN1 DD DSN=TCR201.PRL.V2DG510.CARD.MEMBER.UNLD.G0001V00,
// DISP=SHR
//SORTIN2 DD DSN=TCR201.PRL.V2DG520.COPTNEFO.FILE.G0001V00,
// DISP=SHR
//OUT1 DD DSN=TCR201.PRL.V2DG520.COPTNEFO.FILE.SORT,
// DISP=(NEW,CATLG,DELETE),
// UNIT=SYSDA,
// DATACLAS=STANDARD
//OUT2 DD DSN=TCR201.PRL.V2DG510.CARD.MEMBER.UNLD.SORT,
// DISP=(NEW,CATLG,DELETE),
// UNIT=SYSDA,
// DATACLAS=STANDARD
//TOOLIN DD *
SELECT FROM(SORTIN1) TO(OUT1) ON(1,40,CH) -
ALLDUPS
SELECT FROM(SORTIN2) TO(OUT2) ON(20,40,CH) -
ALLDUPS
//* |
|
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
The JOB should be split. In my opinion, jobsteps should never get near the maximum. Not even close. Not even far away, but far, far away. Makes things much easier.
If you want to add two different SORTs to an existing ICETOOL step to keep the number of steps in a job down, you can do that, but you're making things more complex and more difficult to restart. |
|
| Back to top |
|
|
Dasarathy
New User
Joined: 20 May 2014
Posts: 5
Location: india
|
|
|
|
| Yeah but we have no other go.. The above snippet doesnt work... Can u please rectify the flaws..? |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
No, I have no real clue what you want. Why are you using SELECT instead of ICETOOL's SORT operator if you just want to sort the files?
Plus, I have no way of knowing in what way it didn't work.
If you answer the earlier questions and say what is wrong with your current approach, we may get somewhere. |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
Please learn to use the code tags, example below, to make our lives easier when looking at what you post
| Code: |
[code] Put your stuff
in here [/code] |
Also suggest paying attention to detail as it looks from the dataset names that you really want SORTIN1 to go to OUT2
I'm confused too |
|
| Back to top |
|
|
|
|
