I had responded on a previous issue and it is suggested I create a new one for mine. Doing that and I am adding some of the info below my question. I hope this is not too confusing. I apologize in advance if so.
I starting having an issue with a RPGLE program after it was recompiled due to a different file change 2 weeks ago. I was searching for something like my issue and found this that sounds like it may be what is happening to me.
Link to previous issue http://go.techtarget.com/r/12585115/9007042/9
The program was working fine until the recompile. Since that recompile the OPNQRYF is no longer working. The physical file is keyed by shipto and the opnqryf command says to use billto. The RPG that is called is using the arcust in shipto order.
Below is a snippet of the CL.
OVRDBF FILE(ARCUST) TOFILE(&CSLIB/ARCUST) SHARE(*YES)
OPNQRYF FILE((ARCUST)) OPTION(*ALL) + KEYFLD(BILLTO)
CALL PGM(ARR0402) PARM(&AGCY &AGNAME &EDATE + &DETAIL &BTTOT &DAYS1 &DAYS2 &DAYS3 + &DAYS4 &DAYS5 &BSUM &ARDAYS)
Am I understanding it correctly that the ARR0402 program has to be recompiled over an ARCUST file that is in billto order for this to work now? Was this something that changed in OS 6.1? The last time the program was changed was in 2000 and recompiled in 2007 on iSeries OS 5.3. Gail
Phil answered and asked:
My answer. both billto and shipto are alpha 10. There was a previous ovrdb for calling a different program higher in the CL. I added a dltovr but the same results.