Hi All:
I have a cl program which has the following:
Today we noticed that every time this program is run (which is at least 75 times/day) there is an index built on myfile. (wrkactjob function = IDX-MYFILE)
What's going on here? The join of the 2 files is on the key of MYFILE and the sort is on PA107 fields. Why is an index being built?
Thanks in advance
GLS
I have a cl program which has the following:
Code:
RUNQRY QRY(NOSTART) QRYFILE((*LIBL/PA107 &DSP) + (*LIBL/MYFILE)) RCDSLT(*NO)
What's going on here? The join of the 2 files is on the key of MYFILE and the sort is on PA107 fields. Why is an index being built?
Thanks in advance
GLS
Comment