Produce a multiplication times table for some training



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Re: Produce a multiplication times table for some contest

Postby Robert Sample » Wed Dec 14, 2016 6:26 pm

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.
Robert Sample
Global moderator
 
Posts: 3367
Joined: Sat Dec 19, 2009 8:32 pm
Location: East Dubuque, Illinois
Has thanked: 1 time
Been thanked: 222 times

Re: Re: Produce a multiplication times table for some contest

 

Re: Produce a multiplication times table for some training

Postby BillyBoyo » Thu Dec 15, 2016 1:11 am

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post