How to overlay a text on particular record using Sync sort?



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

How to overlay a text on particular record using Sync sort?

Postby venkatapetchetti » Wed Jul 15, 2009 12:38 am

Hi,

The attached file will have input and output format of my requirement. The input and output files are LRECL=133 and FBA. Could you help me how we can code using sync sort. Thanks

Venkat
You do not have the required permissions to view the files attached to this post.
venkatapetchetti
 
Posts: 6
Joined: Tue Jul 14, 2009 11:41 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to overlay a text on particular record using Sync sort?

Postby Alissa Margulies » Wed Jul 15, 2009 1:02 am

I don't understand your requirement. Are these header and trailer records? Do you simply want another trailer record inserted just before the last line?
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times

Re: How to overlay a text on particular record using Sync sort?

Postby venkatapetchetti » Wed Jul 15, 2009 1:12 am

In the file '1' indicates the begining of the each record. The every 8th record after 1(ie, 9th record including 1st record) should have 'Report' from 11th column. Let me know still you have any questions.

Thanks
Venkat
venkatapetchetti
 
Posts: 6
Joined: Tue Jul 14, 2009 11:41 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to overlay a text on particular record using Sync sort?

Postby Alissa Margulies » Wed Jul 15, 2009 1:45 am

Thank you for the clarification. It now makes sense. This SyncSort for z/OS 1.3 job should give you the requested results:
//STEP1 EXEC PGM=SORT
//SYSOUT  DD SYSOUT=*
//SORTIN  DD DSN=Input.File,DISP=SHR  (FBA/133)
//SORTOUT DD DSN=Output.File
//SYSIN   DD *                                                       
   SORT FIELDS=COPY                                                   
   OUTREC IFTHEN=(WHEN=GROUP,BEGIN=(1,1,CH,EQ,C'1'),PUSH=(134:SEQ=3)),
          IFTHEN=(WHEN=(134,3,ZD,EQ,9),BUILD=(1,10,C'REPORT',17,116)),
          IFTHEN=(WHEN=NONE,BUILD=(1,133))                                                 
/* 
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times

Re: How to overlay a text on particular record using Sync sort?

Postby venkatapetchetti » Wed Jul 15, 2009 2:03 am

Thanks for your response.

Do you know why am I getting the below error?
SYSIN :
SORT FIELDS=COPY
OUTREC IFTHEN=(WHEN=GROUP,BEGIN=(1,1,CH,EQ,C'1',AND,16,1,CH,EQ,C' '),
*
PUSH=(134:SEQ=3)),
IFTHEN=(WHEN=(134,3,ZD,EQ,9),BUILD=(1,11,C'REPORT',17,116)),
IFTHEN=(WHEN=NONE,BUILD=(1,133))
WER268A OUTREC STATEMENT : SYNTAX ERROR
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
venkatapetchetti
 
Posts: 6
Joined: Tue Jul 14, 2009 11:41 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to overlay a text on particular record using Sync sort?

Postby Alissa Margulies » Wed Jul 15, 2009 2:04 am

Support for WHEN=GROUP was included in SyncSort for z/OS 1.3.2. Are you running an older release of SyncSort?
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times

Re: How to overlay a text on particular record using Sync sort?

Postby venkatapetchetti » Wed Jul 15, 2009 2:15 am

I am using SYNCSORT FOR Z/OS 1.3.0.3R
venkatapetchetti
 
Posts: 6
Joined: Tue Jul 14, 2009 11:41 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to overlay a text on particular record using Sync sort?

Postby venkatapetchetti » Wed Jul 15, 2009 7:16 pm

Alissa,

Can't we acheive this using the older version?

Thanks
Venkat
venkatapetchetti
 
Posts: 6
Joined: Tue Jul 14, 2009 11:41 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to overlay a text on particular record using Sync sort?

Postby dick scherrer » Thu Jul 16, 2009 2:13 am

Hello,

Sorry, but if your organization is not willing to install the current release of the software, why should people waste time working on an already out-dated solution.

If the organization is unwilling to upgrade, maybe they should face the expense of writing their own code. . . :?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: How to overlay a text on particular record using Sync sort?

Postby venkatapetchetti » Fri Jul 17, 2009 2:33 am

Yes, I agree.. But that's not in our hands :-)
venkatapetchetti
 
Posts: 6
Joined: Tue Jul 14, 2009 11:41 pm
Has thanked: 0 time
Been thanked: 0 time

Next

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post