Join key - Populate Zeros when Unpaired from File 1

rexx77 · New User Joined: 14 Apr 2008 Posts: 78 Location: Mysore

I am using Join keys to for the below example.

File 1:

RahulG31 · Active User Joined: 20 Dec 2014 Posts: 446 Location: USA

Perhaps you can use 'Overlay' like this:

Bill Woodger · Posted: Thu May 12, 2016 2:18 am

RahulG31,

I should have coded before fixing the typos on your post :-)

rexx77,

Please use the Code-tags to preserve spacing.

Look at the use of the match-marker (a ? in the REFORMAT, which is replaced with the result of the join, B for both (a match), 1 for a mismatched file1, 2 for a mismatched file 2).

Use INREC, you need a BUILD to turn the REFORMAT record into the expected output, then an OVERLAY (and use IFOUTLEN to cut the record down) or a conditional BUILD with a second BUILD on WHEN=NONE - one BUILD doing a packed-zero, the other doing the actual value from the REFORMAT record.

rexx77 · New User Joined: 14 Apr 2008 Posts: 78 Location: Mysore

Thanks Rahul for the solution. This will work.

My fellow colleague gave me below logic, this also worked.

Rohit Umarjikar · Posted: Thu May 12, 2016 2:35 am

Or this may be as per Bill's direction.

rexx77 · New User Joined: 14 Apr 2008 Posts: 78 Location: Mysore

It was copy paste mistake. COPY option was missed while posting.. Thanks Rohit.

Bill Woodger · Posted: Thu May 12, 2016 3:25 am

And in a topic for typos, the 5Z should be 4Z since the fifth byte gets appended.