View previous topic :: View next topic
|
Author |
Message |
vickey_tcs
New User
Joined: 14 Mar 2009 Posts: 5 Location: At Desk
|
|
|
|
Hi,
I want to know whether the follwing can be performed in SYNCSORT:
My input:
01352,Dalmer 08475 ,53041181AA ,SO9843500
, ,53041189AA ,SO9883300
, ,53041190AA ,SO9883500
, ,53041405AC ,SO9843700
, ,53041408AC ,SO9843900
My output should look like:
01352,Dalmer 08475 ,53041181AA ,SO9843500
01352,Dalmer 08475 ,53041189AA ,SO9883300
01352,Dalmer 08475 ,53041190AA ,SO9883500
01352,Dalmer 08475 ,53041405AC ,SO9843700
01352,Dalmer 08475 ,53041408AC ,SO9843900 |
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
Vickey,
This can also be accomplished in a single step using SyncSort for z/OS 1.3.2:
Code: |
//STEP1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
01352,DALMER 08475 ,53041181AA ,SO9843500
, ,53041189AA ,SO9883300
, ,53041190AA ,SO9883500
, ,53041405AC ,SO9843700
, ,53041408AC ,SO9843900
//SORTOUT DD SYSOUT=*
//SYSIN DD *
INREC IFTHEN=(WHEN=(1,1,CH,EQ,C','),BUILD=(20X,4,21))
SORT FIELDS=COPY
OUTREC IFTHEN=(WHEN=GROUP,BEGIN=(1,1,CH,EQ,C'0'),PUSH=(1:1,20))
/* |
|
|
Back to top |
|
|
|
|