Joinkeys with no key

Rajesh S · New User Joined: 11 Jul 2007 Posts: 54 Location: Chennai

Hi,

I have requirement to reformat the records as below. Both the input files are fixed length of 520.

Input file-1:

1111 RAMESH CHENNAI *#&##@ INDIA
2222 SURESH BANGALORE *$*%#*@ INDIA
3333 RAVI MUMBAI *%*%##2 INDIA
4444 AJAY KOLKATA ^&%*$(#@ INDIA

Input file-2:

VITE001 PGMR
VITE002 ASSIT
VITE002 MNGR
VITE003 PGMR

Output File:

1111 RAMESH CHENNAI PGMR INDIA
2222 SURESH BANGALORE ASSIT INDIA
3333 RAVI MUMBAI MNGR INDIA
4444 AJAY KOLKATA PGMR INDIA

I tried with below control card, it’s not working as expected. Please help me in this?

//SYSIN DD *
OPTION COPY
JOINKEYS FILE=F1,FIELDS=(520,1,A),SORTED,NOSEQCK
JOINKEYS FILE=F2,FIELDS=(520,1,A),SORTED,NOSEQCK
REFORMAT FIELDS=(F1:1,32,F2:33,160,F1:193,428)
//*
//JNF1CNTL DD *
OPTION STOPAFT=45
INREC OVERLAY=(520:C'A')
//*
//JNF2CNTL DD *
OPTION STOPAFT=45
INREC OVERLAY=(520:C'A')
/*

Thanks in advance

Regards,
Rajesh S.

Rajesh S · New User Joined: 11 Jul 2007 Posts: 54 Location: Chennai

To make it more clear. Below is my requirement

Input file-1:

Bill Woodger · Posted: Tue Jan 13, 2015 5:36 pm

If you create a key which only has one value on both files, you will get a Cartesian Join. Every record on both files will match every other.

You need to instead use a sequence number added to each record of both files, and use that as the key.

You can cut down the size/format of the data that you want with BUILD on INREC in the JNFnCNTL files, then order it with the REFORMAT statement.

Rajesh S · New User Joined: 11 Jul 2007 Posts: 54 Location: Chennai

Thanks Bill,

It works as you said.

Rajesh S · New User Joined: 11 Jul 2007 Posts: 54 Location: Chennai

Hi,

I need to modify the control card to retain some of the record fields are in readable format from file-1. how can we do it?

Input File-1:

Bill Woodger · Posted: Wed Jan 14, 2015 6:03 pm

You'll have to be more explicit about what you mean. I can read all of your sample output, so what is the problem?

Rajesh S · New User Joined: 11 Jul 2007 Posts: 54 Location: Chennai

Sorry Bill,
I have modify the input files as below. First field in both file are same. I want to retain the records 'ZZT' which are readable format.

Input file-1