IBM Mainframe Forum

Dear All,

I am trying to join the data from two datasets using Join Keys and in the output dataset, I need it with Header and am using the following sort card.

The output as per reformat is

I didnt mention the record length but am getting error as follow:


Thanks in advance.

What do you need help with? The error message is quite clear as to what is wrong. Have you looked at what DFSORT says is the length of your output data set? How does that compare to your SORT control statements?

If you poke the message reference into a web search-engine, you'll get to the description of the message in the IBM Knowledgecentre.

A process of elimination will get you to this:

an OUTFIL field was defined as extending beyond the maximum OUTFIL input record length

And what that means in your case is the you've defined the HEADER1 output as being longer than the input to that OUTFIL processing.

Don't use OUTREC FIELDS, use OUTREC BUILD. Perhaps you can even do everything with OUTFIL BUILD (not OUTFIL OUTREC)?

Confused? That's why you should use BUILD. BUILD is a synonym for FIELDS on INREC and OUTREC and for OUTREC on OUTFIL. If you just use BUILD, I never have to type sentences like the previous two.

However you do it, the length of the record on OUTFIL cannot be shorter than what is created with HEADERn/TRAILERn.

Dear BillyBoyo,

I have tried OUTFIL BUILD as below


But didnt got the desired output.. I am getting output as follow:

I like to generate the output as below

please help me with the alignment..

Thanks in advance.

You now have two OUTFIL statements for the same file. The second (your BUILD) is being ignored. Put a comma at the end of your first OUTFIL, remove OUTFIL from the BUILD.

You don't need all the column-numbers if you are using X to pad the fields. It's often clearer to use the X, so probably best to just remove the column-numbers form the BUILD.

These users thanked the author BillyBoyo for the post:

srrc (Tue Apr 11, 2017 3:18 pm)