How to create report with TITLE in File in Syncsort?



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

How to create report with TITLE in File in Syncsort?

Postby pjagathis » Thu Dec 01, 2011 5:12 pm

HI,

Please any one post a sample code to print TITLE in the file along with detail records.

Also I want to Print a System date and time in the flat file along with date
When i am copying to another file , I want to write TITLE with DATE and TIME.
Thanks and Regards,
Jagathis P
pjagathis
 
Posts: 67
Joined: Wed May 04, 2011 5:04 pm
Location: Chennai
Has thanked: 0 time
Been thanked: 0 time

Re: How to create report with TITLE in File in Syncsort?

Postby BillyBoyo » Thu Dec 01, 2011 6:05 pm

Get hold of a copy of the Syncsort manual. There will be examples there. Also, you can try google.

What do you want the system date and time for?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: How to create report with TITLE in File in Syncsort?

Postby pjagathis » Wed Dec 07, 2011 2:54 pm

HI..

I got the code from Manual..

SORT FIELDS=(1,23,CH,A)
SUM FIELDS=(24,4,PD,
28,4,PD,
32,4,PD,
36,4,PD,
40,4,PD,
44,4,PD)
OUTFIL OUTREC=(17:1,23,
52:24,4,PD,M2,
63:28,4,PD,M2,
74:32,4,PD,M2,
85:36,4,PD,M2,
96:40,4,PD,M2,
107:44,4,PD,M2),
HEADER2=(44:’OUTSTANDING PAYMENTS’,
73:’DATE:’,
78:&DATE,//,
17:’COMPANY’,
106:’BALANCE’,/,
67:’TAX’,
113:’TAX’,2/),

TRAILER2=(31:’TOTALS:’,
51:TOT=(24,4,PD,EDIT=($II,IIT.TT)),
62:TOT=(28,4,PD,EDIT=($II,IIT.TT)),
106:TOT=(44,4,PD,EDIT=($II,IIT.TT)))
Thanks and Regards,
Jagathis P
pjagathis
 
Posts: 67
Joined: Wed May 04, 2011 5:04 pm
Location: Chennai
Has thanked: 0 time
Been thanked: 0 time

Re: How to create report with TITLE in File in Syncsort?

Postby BillyBoyo » Wed Dec 07, 2011 2:59 pm

Good for you. Thanks for letting us know, it may help someone with a similar requirement in the future.

Bear in mind that if the job is run on a different "day" than you expect (like before/after midnight when usually it is the other) the date will be "wrong". If you ever have to re-run the job, the date will be "wrong".
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post