Sort 2 input VSAM files and output a flat file with Lrec 250

job1919 · New User Joined: 19 Jul 2010 Posts: 21 Location: Chennai

Hi ,

I have 2 VSAM files or rec len 200 / 240 each
file 1 - 200
File 2 - 240

Nic Clouston · Posted: Wed May 11, 2011 2:29 pm

field2 compared to col1 you typed but field2 is 4 bytes and col1 is 20 bytes. Suggest you check your posting.

What is the header to look like? What is the trailer to look like? Can there be duplicates.

If you have not already done so - review some of the other sort topics to make sure you have supplied all the required details including sample data.

Have you checked other postings for headers and trailers?

Have you done ANYTHING to answer the question yourself?

job1919 · New User Joined: 19 Jul 2010 Posts: 21 Location: Chennai

Dear Nic,

Like I said , I have already done it in COBOL , I am only looking for any sort card.

And to answer your queries. Felied2 = Col2 Its a typo of X(20) . Here is the format

01 File 1
03 field1 - x20
03 filler - x
03 field2 - x4
03 field 3- 175

01 file 2
03 col1 - x4
03 filler - x
03 col2 - x4
03 filler - x
03 col3- 240

Output file
01 File 3
03 filler1s9(4) usage comp
03 filler x20
03 filler x10
03 field1 x20
03 filler x
03 col2 x4
03 filler rest of the space

I am sure you know the Col3 is left for the future use.

And about the header & Trailers.
here is the format that the utput is to look like
--------------------
File _Id: HDR
Date : Current date
Time : Current Time
--------------------

Records

--------------------
Trl_Id: TRL
Rec Count :
______________

Hope this informative

Thanks
job1919

sqlcode1 · Active Member Joined: 08 Apr 2010 Posts: 577 Location: USA

job1919,
Could you post sample input and expected output along header and trailer?

Thanks,

Nic Clouston · Posted: Wed May 11, 2011 11:37 pm

Skolusu · Posted: Wed May 11, 2011 11:40 pm

Job1919,

Here is a job which will give you the desired results based on my assumptions.