Search found 9 matches

by pgoe9
Fri Apr 01, 2011 12:17 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Need help to compare 2 files and write the matched records
Replies: 18
Views: 33820

Yes Anuj, I did try all the possible combinations of using 1, 2 blank spaces. However what I have understood by now is that the syncsort version release [1998 SYNCSORT INC] that I'm using is pretty old and that the Joinkeys functionality is not available on that old release [z/OS 1.0.0]. What I just...
by pgoe9
Wed Mar 30, 2011 5:16 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Need help to compare 2 files and write the matched records
Replies: 18
Views: 33820

By the way, I also tried using PGM=SYNCTOOL but it failed with RC 0020. I know this forum is mainly for DFSORT but if anyone is having info whether joinkeys utility can work on Syncsort for z/OS 1.0.0. What I mean is, am I trying to use Joinkeys on the OS not upgraded to use this facility? If anyone...
by pgoe9
Wed Mar 30, 2011 2:49 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Need help to compare 2 files and write the matched records
Replies: 18
Views: 33820

Ok Anuj, I got what you and Frank are saying. So even if I code ICETOOL utility its going to invoke Synctool. I know you suggested me to look in to the manuals and see what interface SyncSort needs for the JOINKEYs application. Unfortunately I don't have access to such manuals. I tried your code too...
by pgoe9
Wed Mar 30, 2011 10:26 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Need help to compare 2 files and write the matched records
Replies: 18
Views: 33820

Well, this is what I've been writing from the beginning. I requested your help on the ICETOOL utility because syncsort doesn't work in my mainframe job. I'm not asking any questions on Syncsort. Please let me know how can I achieve the result using ICETOOL since you are an expert in that field, Fran...
by pgoe9
Tue Mar 29, 2011 5:16 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Need help to compare 2 files and write the matched records
Replies: 18
Views: 33820

Its still not working :cry: The same error pops up again... SYNCSORT 3.7BR TPF1 US PATENTS: 4210961,5117495, OTHER PAT. PEND. (C) 1998 S61,5117495, OTHER PAT. PEND. (C) 1998 SYNCSORT INC. DATE=2011/088 TIME=08.08.42 z/OS 1.0.0 CPU MODEL 2097 SYSIN : JOINKEYS FILE=F1,FIELDS=(1,8,A) * JOINKEYS FILE=F2...
by pgoe9
Tue Mar 29, 2011 9:40 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Need help to compare 2 files and write the matched records
Replies: 18
Views: 33820

Hello,

Can someone please help me with this query? Frank, if you can help with the job using ICETOOL and splice statements, it will be great. Unfortunately joinkeys is not working in my mainframe job... :(
by pgoe9
Mon Mar 28, 2011 2:09 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Need help to compare 2 files and write the matched records
Replies: 18
Views: 33820

Yes you are right. The job is using SYNCSORT. As far as I know, this utility somehow does not work in our jobs.

Can the same job be converted using ICETOOL that will perform the same functionality? If yes, then please help me.
ICETOOL works quite well in my other mainframe jobs.
by pgoe9
Mon Mar 28, 2011 11:54 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Need help to compare 2 files and write the matched records
Replies: 18
Views: 33820

Thanks Frank. I did try your option, but its giving the following error in sysout: 1 SYNCSORT 3.7BR TPF1 US PATENTS: 4210961,5117495, OTHER PAT. PEND. (C) 1998 61,5117495, OTHER PAT. PEND. (C) 1998 SYNCSORT INC. DATE=2011/087 TIME=02.40.32 z/OS 1.0.0 CPU MODEL 2097 SYSIN : JOINKEYS F1=IN2,FIELDS=(10...
by pgoe9
Fri Mar 25, 2011 6:36 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Need help to compare 2 files and write the matched records
Replies: 18
Views: 33820

Need help to compare 2 files and write the matched records

Hi, I have 2 files. First file (Input1) having only 1 record is of 8 bytes containing the date in YYYYMMDD format. The second input file (Input2) having many records is of 107 bytes. This 2nd input file (Input2) contains the date from the column 100 to 107. I need to compare both these files on the ...