I am trying to combine records from two files say IN1 and IN2 using 'JOINKEYS'. But doing that i am getting some errors as mentioned below:
ICE005A 0 BLANK NEEDED IN COLUMN 1 OR OPERATION NOT DEFINED CORRECTLY
REFORMAT FIELDS=(F1:1,2,F2:1,2)
$
ICE005A 0 BLANK NEEDED IN COLUMN 1 OR OPERATION NOT DEFINED CORRECTLY
OPTION COPY
The reference code i used to achieve this is as below:
//S1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//IN1 DD *
AB
BC
CD
/*
//IN2 DD *
11
22
33
44
/*
//SORTOUT DD SYSOUT=*
//SYSIN DD *
JOINKEYS F1=IN1,FIELDS=(3,1,A),SORTED
JOINKEYS F2=IN2,FIELDS=(3,1,A),SORTED
REFORMAT FIELDS=(F1:1,2,F2:1,2)
OPTION COPY
/*
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
arun nehra wrote:
ICE005A 0 BLANK NEEDED IN COLUMN 1 OR OPERATION NOT DEFINED CORRECTLY
REFORMAT FIELDS=(F1:1,2,F2:1,2)
$
ICE005A 0 BLANK NEEDED IN COLUMN 1 OR OPERATION NOT DEFINED CORRECTLY
OPTION COPY
Looks like you don't have blanks at the start of each line in //SYSIN. That's what the message BLANK NEEDED IN COLUMN 1 is telling you, please check that.
Actually i have placed blank in the first column in the SYSIN and it looks like it is just a typo in the above screen shot. I believe spaces in column one is not an issue here. Can this be because this (SORT) utility is not supporting JOINKEYS at my shop or not upgraded for the same because i am trying out similar thing using ICETOOL and getting some similar messages:
Actually the dollar sign is just below J of (JKFROM) but it got shifted while pasting thus i mentioned it in the error message:
SORT JKFROM TO(OUT) USING(CTL1)
$(Dollar sign is just below J of JKFROM)
Also now i am quite sure that SORT Utility at my shop is not an upgraded version and thus it is not supporting "JOINKEYS" feature. But for ICETOOL i am still not sure, also i am not getting much help on 'ICETOOL + JOINKEYS' from the WEB in this regard.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
As you guessed, you do NOT have the DFSORT PTF installed that would allow you to use JOINKEYS for DFSORT or ICETOOL (which includes JKFROM for ICETOOL). Ask your System Programmer to install the appropriate PTF. See the following for details: