IBM Mainframe Forum

Hi

Right now we have the below sort card in test region for sorting input file of length 34 with a header and trailer.



As we do not have DFSORT V1R12 in production, we have been asked to modify the sort card to work in DFSORT V1R10.
Can someone please help me with a right sort card?

Thanks
Prasanna G

You should realize that people willing to help might not be at the 1.12 level,
so it would necessary for them to spend time looking at the manuals to decode the syntax
to backtrack to the requirement

it would have been nicer from Your side to have posted
a description in WORDS of the requirement,
a snippet of the input data
and the corresponding snippet of the expected output

Hi Enricho

My requirement is as follows
There is an input file with header identified with first two bytes as zero (s9(04 ) comp), then detailed record with first two bytes as a non zero value (partition number s9(04) comp) then trailer record as 999 as the first two bytes with record count starting at position 11 (s9(09) comp). The record length of the file is 34. I have to concatenate 2 input files and get output file with one header, set of detailed records sorted in ascending order using first 2 bytes then trailer updated with correct record count from the two files. I tried to arrive at the below sort card to work in V1.R10. But not yielding the result as I am not much familiar with DFSORT.



The output file that I get is not having header record. It gives me two 999 records at the end.
Quick response will be very much helpful as we have a code move up tonight.

Thanks in advance
Prasanna G.

Well you are ignoring the header record(s) in the INCLUDE.

If you get two 999 records on the output, that is because there are two on the input - one from each concatenated file? So if you keep the headers, you'll probably have two of those as well.

If the two headers are correct and the two trailers are correct, then you could assign a sequence number with OUTREC (after the data is sorted) for headers and trailers and then with OUTFIL INCLUDE write all the data records, but a header or trailer only when the sequence number is one.

first of all learn to spell correctly people name
my name is Enrico, NOT Enricho

second

Quick response will be very much helpful as we have a code move up tonight.

a Forum is not the best place to ask if You have any time constraint..
You cannot expect people to drop what they are doing to start working on Your requirement

How did someone manage to write code which plain does not work with the DFSORT in Production?

Having done that, how come no-one found out until 24 hours before the code goes into Production?

Something hasn't been thought through somewhere with this. How are you planning to do satisfactory testing? Are there any other sort steps being implemented, have they been checked?

We have DFSORT V1.R12 in test regions. We were not aware that V1R12 will not be available in production. There was an implementation happened last Friday. One of the instances had V1.R12 where as some other instances do not. So to avoid that we have been asked to update the sort card in such a way that it runs for V1R10.

enrico-sorichetti wrote:first of all learn to spell correctly people name
my name is Enrico, NOT Enricho

second

Quick response will be very much helpful as we have a code move up tonight.

a Forum is not the best place to ask if You have any time constraint..
You cannot expect people to drop what they are doing to start working on Your requirement

Hi

Am extremely sorry for wrongly spelling your name.
As I am new to DFSORT, I tried to come up with above sort card. But could not get it right. Hence wanted a quick response.

Thanks ENRICO
Regards
Prasanna G.

BillyBoyo wrote:Well you are ignoring the header record(s) in the INCLUDE.

If you get two 999 records on the output, that is because there are two on the input - one from each concatenated file? So if you keep the headers, you'll probably have two of those as well.

If the two headers are correct and the two trailers are correct, then you could assign a sequence number with OUTREC (after the data is sorted) for headers and trailers and then with OUTFIL INCLUDE write all the data records, but a header or trailer only when the sequence number is one.

Thanks.
But how about updating the trailer record with correct trailer count?
Can you help me with that?

Prasanna G.

Hello,

It would have been much more helpful if you had shown some sample input and the output you wanted when you rn your process.

You now mention a "trailer". DFSORT can generate a trailer, but we would need to know what it should contain. Maybe i've misread or i'm old and work better with actual data . . . Read sbout TRAILER1 and COUNT=.

Some of us should be available for a while yet . . .