Page 1 of 1

Use SYNCSORT to obtain tot no of records,write to a file

PostPosted: Tue Apr 24, 2012 11:19 am
by shirazi2589
Hello,
I have in my file lets say 9 records for eg:
111111111111111
222222222222222
333333333333333
444444444444444
555555555555555
666666666666666
.....................
999999999999999

I want in my same file as a trailer record the total number of records of length 5.
i.e my final op file should be.

11111111111111
22222222222222
33333333333333
...................
99999999999999
00009


What do i do?
I tried using ICETOOL to obtain tot no. of records and wrote to a different file.
And thought i could IEBGENER the two files. But ICETOOL created a file with many other information along with total no. of records.

Below is the Sample Ouptut from ICETOOL
**************************************************************************************************
SYT000I SYNCTOOL RELEASE 1.6.2 - COPYRIGHT 2007 SYNCSORT INC.
SYT001I INITIAL PROCESSING MODE IS "STOP"
SYT002I "TOOLIN" INTERFACE BEING USED

COUNT FROM(IN) USING(CTL1)
SYT020I SYNCSORT CALLED WITH IDENTIFIER "0001"
SYT031I NUMBER OF RECORDS PROCESSED: 000000000003847
SYT030I OPERATION COMPLETED WITH RETURN CODE 0

SYT004I SYNCTOOL PROCESSING COMPLETED WITH RETURN CODE 0
**************************************************************************************************shirazi2589

Posts: 8
Joined: Mon Nov 14, 2011 9:08 pm

Re: Use SYNCSORT to obtain tot no of records,write to a file

PostPosted: Tue Apr 24, 2012 11:48 am
by BillyBoyo
Have a look in your documentation for TRAILER1, or search in this forum for TRAILER1, you'll find examples.