Need to get the not sorted Key fields in a flat file

naveen.m · New User Joined: 02 Nov 2007 Posts: 9 Location: BENGALURU

Hi,

I need to sort a master file using key fields passed thru sysin card.

As it is a support wrk. I cant use cobol code for sort process.

Jst i need to run the job for this providing the Key Fields.

after job is run i want to know which key fileds were not present in master file and need to get those Key Field values to be written in another flat file.

Pls help me out

sril.krishy · Posted: Thu Mar 27, 2008 3:54 pm

Naveen,
Could you plese elobarate your requirement.It will be good if you provide the sample input and expected output.

Thanks
Krishy

Frank Yaeger · Posted: Thu Mar 27, 2008 9:19 pm

Also:

Give the RECFM and LRECL of the input file.

Give the starting position, length and format of each relevant field.

What is the approximate number of "key fields" you need to pass through SYSIN?

dick scherrer · Posted: Thu Mar 27, 2008 9:58 pm

Hello,

Sounds like maybe a good candidate for putting the "key fields" in a second data file and creating output of matched/unmatched to meet the requirement. . .

Frank Yaeger · Posted: Thu Mar 27, 2008 10:14 pm

INCLUDE might be a better choice depending on the number, length and format of the "key fields".

naveen.m · New User Joined: 02 Nov 2007 Posts: 9 Location: BENGALURU

naveen.m · New User Joined: 02 Nov 2007 Posts: 9 Location: BENGALURU

What is the approximate number of "key fields" you need to pass through SYSIN?[/quote]

It depends on request.
Some thing around 150-200 keyfields.

Frank Yaeger · Posted: Fri Mar 28, 2008 8:46 pm