IBM Mainframe Forum

if I use a cartesian join how am i supposed to give the key?

Google is your friend. Googling dfsort cartesian join returns 632 results, including hits with sample code from IBM.

If the key you want does not exist, you make it exist.

Use JNF1CNTL and JNF2CNTL datasets to modify each input record to have a "0" (for instance) at position three. The use position 3 for a length of 1 as the "key".

Then, for each record on your F1 input, each F2 record will match.