I am allowed to increase O/P file length due to commas for first case and for second 80 fixed.Could you please advise which way I can achieve this. I don't want the way to separate these 3 types of records into 3 different temp files and do outrec,then merge those three again.
Can you suggest optimized one step for this using icetool.
You also need to tell SORT product installed at your site.
Your previous posts are present both in JCL and DFSORT parts of forum...
and as Gerry as asked
How you arrived at output of second file?
for first output file is the field lengths is is criteria to make it comma separated? If so mention it in detail for each field from header\detail line and trailer.
Actually I can use ICETOOL in our system.And Yes, all the data I have shown, you can consider similar calculation for bytes.
For 1st, its just fields of different length for 3 different type of records and need those as "," separated as shown.
For 2 nd its just outrec for (2,2,8,2,16,2) for trailer record i.e. (1,1,EQ,C'T')
But I want to create one step for both..Actually I am in design phase.You please consider no of bytes exactly as shown in example.
My problem is as H,D,T have different fields and they need to comma separated as shown in example, I am not getting how to do that in one step.
Joined: 14 Mar 2007 Posts: 8631 Location: Back in jolly old England
Although you say that you can use ICETOOL for this, ICETOOL may possibly be an alias for the SYNCSORT equivilent, so it would be greatly appreciated if you could perform the step below and clarify exactly which product and release level is being used by running the simple sort step shown below.
If the messages start with ICE then your product is DFSORT and will be moved to the correct forum by one of the moderators. Please also post the output of the complete line which has a message code ICE201I, as this will enable our DFSORT experts to determine which release of DFSORT that you have installed. This may also affect the solution offered.
If the messages start with WER or SYT then the product is SYNCSORT and the topic will remain in the JCL forum. Please also post the information telling which version of SYNCSORT is installed, as this may also affect the solution offered.
Thank you for taking your time to ensure that the valuable time of others is not wasted by offering inappropriate solutions which are not relevant due to the sort product being used and/or the release that is installed in your site.
Gerry has asked what the rules are, and so far you have not answered him. From what I can see the rules are as clear as mud if they exist at all. Does the subsequent formatting of the records depend on the first character of the record, if so, please explain the rules clearly. If not, then describe in detail how the record needs to be reformatted.
Unless YOU tell us the exact rules we can only guess at what you want to do, and quite frankly I would rather do something else where I know the rules rather than waste my time by guessing at things that you have not told us.