SYNCSORT - NEED TO ADD HEADER



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

SYNCSORT - NEED TO ADD HEADER

Postby shrishant » Wed Dec 14, 2011 3:27 pm

Hi all,
I have a step in my JCL where I am changing the picture clause of the input file field and populating the same value in output file in readable format using SYNCSORT.
Everything is perfect and I am getting the expected output in the output report.

I want to add the header record into the output report that is not present in the input file.

The header is as below and should be displayed at the top of the output report.

SOURCE,GL-BUSS-UNIT,GL-DEPT-ID,STATE-PRO-SECU,ZIP-PRO-SECU,STATE-CUS,ZIP-CODE-CUS,EOM-OPB,YTD-INT-INCME,YTD-FEE-INCME,BK-NUM,ORG-LVL-NUM-6,

Please let me know if anyone have idea of achiving this in same step.

Regards,
Shri
shrishant
 
Posts: 4
Joined: Sat Dec 10, 2011 4:45 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SYNCSORT - NEED TO ADD HEADER

Postby dick scherrer » Thu Dec 15, 2011 11:21 am

Hello,

Post a few sample input records and the output you want when this sample is processed.
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: SYNCSORT - NEED TO ADD HEADER

Postby xknight » Fri Dec 16, 2011 5:24 pm

Hello,

Why not having static header in the seperate file and merge it, while copying/sorting your input file. Just a hint!!

Regards,
Xavier
User avatar
xknight
 
Posts: 2
Joined: Thu Dec 15, 2011 10:51 am
Has thanked: 0 time
Been thanked: 0 time

Re: SYNCSORT - NEED TO ADD HEADER

Postby Alissa Margulies » Wed Dec 21, 2011 12:25 am

Hello Shri.

Since we cannot see what your current control cards are, try adding the following OUTFIL statement to the SYSIN of your existing sort step:

//SYSIN DD *
  .
  .
  .
  OUTFIL HEADER1=(1:C'SOURCE,GL-BUSS-UNIT,GL-DEPT-ID,STATE-PRO-SECU,',
     47:C'ZIP-PRO-SECU,STATE-CUS,ZIP-CODE-CUS,EOM-OPB,',           
     91:C'YTD-INT-INCME,YTD-FEE-INCME,BK-NUM,ORG-LVL-NUM-6')


If you run into a problem, please post the sample input and expected output (as previously requested) along with the error messages.

Thank you.
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


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post