I have learned quite a few things from this forum. So i am thankful to that. I hope to be active now because now i am working on mainframe technologies regularly.
I am facing a problem while using icetool:
I have a file, say FILE1 as follows:
8digit enrollment number 8 digit student ID
Now I have File-2, containing details of each student ID:
POSITION IN FILE ARE AS:
AAL00000 xxx yyyy zzzzz M0101010 H S
JAGBR01 sss ddd ccccc M0921311 Q T
TPS0000 aaa fff vvvvv M9876789 L
File 2 has unique records for EACH student id. While file can have more than 1 record for a student id, cuz enrollment number can be more than 1 for a student.
Now I want the list of student ID who are there in file-1 (with their enrollment number from file-1) as well as semester indicator, reg num, grade indicator from file-2.
i USED THE BELOW CODE BUT IT IS NOT WORKING. Kindly help:
//Step1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN1 DD DSN=work.file1,DISP=SHR
//IN2 DD DSN=work.file2,DISP=SHR
//Temp1 DD DSN=work.temp1,disp=(made a new file, FB, RECL=30)
//Temp2 DD DSN=work.temp2,disp= made a new file again
//OUT DD DSN=work.final, DISP=made a new file
//TOOLIN DD *
COPY FROM(IN1) TO(Temp1) USING(CTL1)
COPY FROM(IN2) TO(Temp1) USING(CTL2)
SPLICE FROM(Temp1) TO(Temp2) ON(1,08,CH) WITH(9,26) WITHALL -
COPY FROM (Temp2) TO (OUT) USING(CTL3)
//CTL1CNTL DD *
//CTL2CNTL DD *
//CTL3CNTL DD *
But I am getting empty files in Temp1 and so nothing seems working. Kindly elaborate a little ICETOOL and how can I do this.
I am stuck with this for last 4 hours.
Please help me out.