MVSFORUMS.com

ranga_subham · Intermediate Joined: 31 Jan 2006 Posts: 255 Topics: 72

Hi,

I have two input files (LRECL=80, RECFM=FB).

File-1:

Frank Yaeger · Posted: Thu Apr 08, 2010 3:32 pm Post subject:

You can use a DFSORT JOINKEYS job like the following to do what you asked for:

papadi · Supermod Joined: 20 Oct 2009 Posts: 594 Topics: 1

Which sort product is used on your system?
_________________
All the best,

di

ranga_subham · Intermediate Joined: 31 Jan 2006 Posts: 255 Topics: 72

Thank you Frank.
_________________
Ranga
*****
None of us is as smart as all of us - Ken Blanchard

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

Frank,
Out of curiosity what is the purpose of JNF1CNTL in this sort card?
OP never asked for sorted output file and from looking at his expected output, assuming he forgot to mention about sorted o/p, it seems he wants reformatted be sorted on first 6 bytes.

Would below mentioned card work?

Frank Yaeger · Posted: Wed Apr 14, 2010 12:02 pm Post subject:

From his input and output example, I assumed that he wanted the output in the original order of the input records. I added the SEQNUM to the file1 records with JNF1CNTL so I could sort on them to get that result. If, in fact, he just needed the output records sorted on the first file1 field, then your job would work. That wasn't the way I read the requirement, but it's certainly a possibility.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

Frank,
Thanks for the quick response and explanation.

Thanks,

ranga_subham · Intermediate Joined: 31 Jan 2006 Posts: 255 Topics: 72

Hi, Frank,

How to apply SEQNUM on IN1 without using JNF1CNTL?

Thanks.
_________________
Ranga
*****
None of us is as smart as all of us - Ken Blanchard

kolusu · Posted: Tue May 04, 2010 10:41 am Post subject:

ranga_subham · Intermediate Joined: 31 Jan 2006 Posts: 255 Topics: 72

No issues.......mistaken with CNTL being used with SORT because I saw it used in ICETOOL !!

Thanks.
_________________
Ranga
*****
None of us is as smart as all of us - Ken Blanchard

Anuj Dhawan · Posted: Wed May 05, 2010 3:41 am Post subject:

JNFnCNTLs are used because you are using a JOINKEYS application. Such control cards are optional JCL statements for a JOINKEYS application.

You can also use JOINKEYS with ICETOOL, but you need to care about what control-card you are dealing with - CTLnCNTL or JNFnCNTL. Both are control-cards from a DFSort Application per se but we, as programmers, need to make a choice what will work for us.
_________________
Regards,
Anuj

Frank Yaeger · Posted: Wed May 05, 2010 11:32 am Post subject:

Anuj Dhawan · Posted: Thu May 06, 2010 4:05 am Post subject:

Thank you, Frank - you've been always helpful. I'll keep this post in my "collections" Smile

Take care,
_________________
Regards,
Anuj