Posted: Sat May 14, 2011 12:50 am Post subject: Need help with sort/icetool - create header and trailer
I have a requirement to create a header and trailer record in a file that has only detail records. The header has some static information and two dates. Date 1 is the beginning date which comes from the first record (position 98 - 107) in the file and the ending date which is in the last record (position 98 - 107) of the file. The trailer record has some static data and a record count of the number of detail records + 2 (includes the header and trailer). Any help would be appreciated.
Thanks _________________ Dave
Joined: 18 Feb 2006 Posts: 812 Location: San Jose, CA
Posted: Sat May 14, 2011 1:35 am Post subject:
Please show an example of the records in your input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files.
Also, run this job and show the //SYSOUT messages you receive, so we can see which sort product/level you have:
Posted: Sat May 14, 2011 3:14 am Post subject: processing "rules"
This is the sort product/level (let me know if you need more info):
ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5
The rules are as follows:
1. all records copied "as is" in the same order from input to output (records fixed (FB) length = 225)
2. in the output file create a header (FB) as follows:
1 - 10 "HEADER "
15-24 is a date which comes from the first record in the file from positions 98-107
25-34 is a date which comes from the last record in the file from positions 98-107
39-225 padded with spaces
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum