|
Hello, I am not able to execute my OPNQRYF statement properly in my program. So the file read in RPG is the entire file and not the one with selected records. The JobLog is as below: CALL J57II61 5300 - CHGJOB LOG(4 00 *SECLVL) LOGCLPGM(*YES) 11700 - OVRDBF FILE(F57II6) SHARE(*YES) 12200 - OPNQRYF FILE((F57II6)) OPTION(*ALL) QRYSLT('Z1@MVT = %VALUES("101" "102")') Unable to retrieve query options file. **************************************************************************** ************* F1 on this : Message ID . . . . . . : CPI433A Severity . . . . . . . : 00 Message type . . . . . : Information Date sent . . . . . . : 02/23/06 Time sent . . . . . . : 05:13:44 Message . . . . : Unable to retrieve query options file. Cause . . . . . : Unable to retrieve the query options from member QAQQINI in file QAQQINI in library QUSRSYS for reason code 2. The reason codes and their meanings follow: 1 - Library QUSRSYS was not found. 2 - File QAQQINI in library QUSRSYS was not found. 3 - The file was damaged. 4 - The file was locked by another process which prevented successful retrieval of the query options. 5 - File QAQQINI and the internal query options structures are out of sync. 6 - An unexpected error occurred while trying to retrieve the options **************************************************************************** ************* Arrival sequence access was used for file F57II6. Open of member F57II6 was changed to SEQONLY(*NO). Member F57II6 file F57II6 in PATNIDTA opened. Step completed at line 126 Please help on this .. Thanks and Regards, Gauri. http://www.patni.com World-Wide Partnerships. World-Class Solutions. _____________________________________________________________________ This e-mail message may contain proprietary, confidential or legally privileged information for the sole use of the person or entity to whom this message was originally addressed. Any review, e-transmission dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this e-mail in error kindly delete this e-mail from your records. If it appears that this mail has been forwarded to you without proper authority, please notify us immediately at netadmin@xxxxxxxxx and delete this mail. _____________________________________________________________________
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.