mainframegurukul.com

Kolusu,

That is an awesome solution. It is so quick and I got expected results in a short while.

I apologize for the delay in reply. But it saved me a lot of time as I was in the midst of implementation and had to come up with quick solution.

Thanks a lot for all your help!

Thanks,
Nachi

In this same context, my input is 14 million rows and I have 25 max duplicate keys. This join multiplies 14 million with 25 which will be a huge number of rows in the temp. I tried running it but with no surprise my SORT job went down due to size limitations. Is this is the only solution for this sc...

That is exactly what I wanted. It took a while for me to understand the control cards, but when I got that, it looks great.

I am getting the expected results. I customized the control cards to my need. Thanks for all your help!

Thanks,
Nachi

Costa, In my personal opinion and experience, I say that both COBOL or EZTRIEVE program when compared with DFSORT/ICETOOL got more or less the same performance. Advantage in going with DFSORT is its ease of developement (as you already mentioned) and maintenance (no compile required for any requirem...

Here is the Sort JCL which may satisfy your requirement. //STEP010N EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //IN1 DD * 12345 1425 56478 //OUT DD SYSOUT=* //TOOLIN DD * COPY FROM(IN1) TO(OUT) USING(CTL1) /* //CTL1CNTL DD * OUTREC IFOUTLEN=05, IFTHEN=(WH...

Frank,

Did you had a chance to look at my question?

Thanks,
Nachi

I missed to inform you what the outcome after using the above SYSIN card
Here it is

NACHI MATB....
NACHI MATBSTG.
NACHI MATBSAS.

Thanks,
Nachi

I wish to write multiple records by matching 2 files which has the same key. For example, IN1 NACHI MAT FRANK MAT IN2 MAT STG MAT SAS I want the output to look like NACHI MAT STG NACHI MAT SAS FRANK MAT STG FRANK MAT SAS Read the first record, and find for the key in pos (7,3) is in (1,3) of file 2....

Frank,

That's exactly right. It has to be PROG and not PROG1.

The solution that you gave also worked! I got the required output and very happy about it. Thanks for all your help!

Thanks,
Nachi

Frank, I have another question. If I have to eliminate few records while writing to output, how can that be done. For example: Input: FB 80 ROBYN ARIAS,QTR2:05-19-2009,1,PROG1,LINE1, NACHI KATHIR,QTR2:05-20-2009,2,PROG2,LINE2, SOLAI SAKTHI,QTR2:05-21-2009,1,PROG3,LINE3, If I need only records which ...

Frank,

Wonderful! It is working. I was trying to remove blanks with 'PREBLANK = QUOTE'. It didn't work.

As always, thanks for all your help!

Thanks,
Nachi

Hi, I have a comma separated file which needs formatting before loading into a DB2 table. A new value needs to be introduced between 2 fields. Example: Input file (LRECL 80, FB): ROBYN ARIAS,QTR2:05-19-2009,PROG1,LINE1, NACHI KATHIR,QTR2:05-20-2009,PROG2,LINE2, SOLAI SAKTHI,QTR2:05-21-2009,PROG3,LIN...

Frank and Dick,

I tried with OPTION EQUALS and I got the expected result. Thanks a lot for all your help!

Thanks,
Nachi

Frank and Dick,

Thanks a lot! I will try this option and let you know

- Nachi

I wish to sort an input file of LRECL 357 on position 19, length 7 which is a packed decimal. Input file contains 300,000 records. Records having same value (as example) are located at 33777, 33835, 138230 and 252826 lines. When I execute the sort, the order became 252826, 33777, 33835, 138230 Now I...