OPNQRY
Home > IT Answers > AS/400 > OPNQRY
Secskc
15 pts.
0
Q:
OPNQRY
OPNQRYF, AS/400 Query, RUNQRY, AS/400 error messages, Open Query, Run Query
Hi ALL,
I am trying to pass to variable to the query select.
-----------------------------------------------------------------------------------------------
OVRDBF FILE(filename) SHARE(*YES)
OPNQRYF FILE((library/filename) QRYSLT('DATE +
*EQ "&SATDYYMD"') /*the variable contains the date*/
CPYFRMQRYF FROMOPNID(filename) TOFILE(library/outputfile) +
MBROPT(*REPLACE) CRTFILE(*NO)
RUNQRY QRY(library/queryname) +
QRYFILE((Library/filename) (library/outputfile)
CLOF OPNID(filename)
DLTOVR FILE(filename)
-----------------------------------------------------------------------------------------
error message:Cause . . . . . : Control language (CL) program RCDSLCT11 in library TEST1
detected an error at statement number 2300. Message text for QRY2276 is:
RUNQRY has too many files specified for query XXXXX in TEST1.


Can anyone help me out.
ASKED: Nov 26 2008  9:03 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Gilly400
23625 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button

Hi,

You have 2 files specified for your RUNQRY statement. I suspect that your existing *QRYDFN is only designed to use 1 file.

Regards,

Martin Gilbert.
Last Answered: Nov 26 2008  9:39 AM GMT by Gilly400   23625 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Secskc   15 pts.  |   Nov 26 2008  10:03AM GMT

Hi,
Thank for the reply..below is the code what I have wriiten for clear understanding..Please help me out
———————————————————————————
OVRDBF FILE(ABC13DEF) SHARE(*YES)
OPNQRYF FILE((TEST1/ABC13DEF)) QRYSLT(’DATE +
*EQ “&SATDYYMD”‘)
CPYFRMQRYF FROMOPNID(ABC13DEF) TOFILE(TEST1/ABCD13) +
MBROPT(*REPLACE) CRTFILE(*NO)
RUNQRY QRY(TEST1/CRADPAYDAT) +
QRYFILE(TEST1/ABC13DEF) (TEST1/ABCDC13)
CLOF OPNID(ABC13DEF)
DLTOVR FILE(ABC13DEF)
———————————————————————————

 

Gilly400   23625 pts.  |   Nov 26 2008  10:43AM GMT

Hi,

I think you only need to use (TEST1/ABCDC13) for your RUNQRY - this file should only contain the data you select using OPNQRYF :-

OVRDBF FILE(ABC13DEF) SHARE(*YES)
OPNQRYF FILE((TEST1/ABC13DEF)) QRYSLT(’DATE *EQ “&SATDYYMD”‘)

CPYFRMQRYF FROMOPNID(ABC13DEF) TOFILE(TEST1/ABCD13) +
MBROPT(*REPLACE) CRTFILE(*NO)

CLOF OPNID(ABC13DEF)
DLTOVR FILE(ABC13DEF)

RUNQRY QRY(TEST1/CRADPAYDAT) QRYFILE(TEST1/ABCDC13)

Regards,

Martin Gilbert.

 
0