Joined: 31 Mar 2005 Posts: 435 Location: chennai, India
Thanks, Nelson. The sort card works fine. But with region 0M.
Actually, it needed region parameter as 0M. Else it fails repeatedly whatever sort script we write. But I would like to understand the condition INCLUDE=(105,1,CH,EQ,C'B') since following code also gives the same match with region=0M.
Code:
000036 JOINKEYS F1=IN01,FIELDS=(10,6,A),SORTED
000037 JOINKEYS F2=IN02,FIELDS=(10,6,A),SORTED
000038 REFORMAT FIELDS=(F1:1,104)
000039 OPTION COPY -- if SORTOUT is provided
will there be any performance difference.
one last question. how much efficient I can do this JOIN SORT if I have LRECL=104 and Total record count will reach from 1 to 8 million.
what will be the sort exceeded limit here in my case.
Joined: 09 Apr 2008 Posts: 133 Location: Phoenix, AZ
At Position 105 i have given a Join indicator. This indicator is used to get the Matched and Unmatched records.
Code:
INCLUDE=(105,1,CH,EQ,C'1') --> Unmatched records from File 1
INCLUDE=(105,1,CH,EQ,C'2') --> Unmatched records from File 2
INCLUDE=(105,1,CH,EQ,C'B') --> Matched records.
Quote:
one last question. how much efficient I can do this JOIN SORT if I have LRECL=104 and Total record count will reach from 1 to 8 million.
I have seen DFSORT/ICETOOL jobs preform more than 10 million records in my previous shop. So there wont be any issue
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
radhakrishnan v,
I'm not sure what you're trying to accomplish, or what questions you actually want answered, but going back to your first post, this DFSORT message:
Code:
ICE418A 3 JOINKEYS F1 SUBTASK FOR IN01 TERMINATED - SEE JNF1JMSG MESSAGES
tells you that the cause of the error is listed in JNF1JMSG. So you need to look at the messages in JNF1JMSG to determine the error. Since you didn't post those messages, I can't tell you what you did wrong.