combine multiple records into a single one using syncsort



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

combine multiple records into a single one using syncsort

Postby vidyanisha » Tue Jan 29, 2013 11:10 pm

Hi,

I have an input file of LRECL=50 in the following format.

DB1 20 FormA
DB2 10 FormA
DB6 15 FormB
DB3 60 FormA
DB7 80 FormC
in this way 1 to 8 records for each form type.

I need the o/p with LRECL=120 in the below format
Form-Type DB1 DB2 DB3 DB4 DB5 DB6 DB7 DB8
FormA 20 10 60
FormB 15
FormC 80

Can any one please let me know how to do this using syncsort.I cant use ifthen=(when=(group as it is not supported .
vidyanisha
 
Posts: 4
Joined: Tue Jan 29, 2013 10:49 pm
Has thanked: 0 time
Been thanked: 0 time

Re: combine multiple records into a single one using syncsort

 

Re: combine multiple records into a single one using syncsor

Postby vidyanisha » Tue Jan 29, 2013 11:17 pm

sorry..i forgot to mention that the output format should be the count for each form type under the specific DB number.
ie
FormType DB1 DB2 DB3 DB4 DB5 DB6 DB7 DB8
FormA
FormB
FormC

in a tabular format.
vidyanisha
 
Posts: 4
Joined: Tue Jan 29, 2013 10:49 pm
Has thanked: 0 time
Been thanked: 0 time

Re: combine multiple records into a single one using syncsor

Postby Akatsukami » Tue Jan 29, 2013 11:48 pm

Obviously, you did not read the rules, as rule #1 is:
Topics must be submitted to the relevant forums.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: combine multiple records into a single one using syncsor

Postby vidyanisha » Thu Jan 31, 2013 6:58 pm

sorry for the trouble
vidyanisha
 
Posts: 4
Joined: Tue Jan 29, 2013 10:49 pm
Has thanked: 0 time
Been thanked: 0 time


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post