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



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

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

Postby shirazi2589 » Tue Apr 24, 2012 11:19 am

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
shirazi2589
 
Posts: 15
Joined: Mon Nov 14, 2011 9:08 pm
Has thanked: 0 time
Been thanked: 0 time

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

Postby BillyBoyo » Tue Apr 24, 2012 11:48 am

Have a look in your documentation for TRAILER1, or search in this forum for TRAILER1, you'll find examples.
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