Page 1 of 1

How to create report with TITLE in File in Syncsort?

PostPosted: Thu Dec 01, 2011 5:12 pm
by pjagathis
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.

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

PostPosted: Thu Dec 01, 2011 6:05 pm
by BillyBoyo
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?

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

PostPosted: Wed Dec 07, 2011 2:54 pm
by pjagathis
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)))

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

PostPosted: Wed Dec 07, 2011 2:59 pm
by BillyBoyo
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".