• OPNQRYF

    I HAVE A CASE LIKE THIS IN CL/400 OPNQRYF FILE((MADE07/GLM0120)) QRYSLT('(GLFINP *NE 99) *AND (GLPRDC *EQ "AR" *OR GLPRDC *EQ "SW" *OR GLPRDC *EQ "WP" *OR GLPRDC *EQ "LR" *OR GLPRDC *EQ "MD") *and (glbrnc *eq "%substr(&bc 1 1)")') HERE BC IS A FIELD IN DISPLAY FILE I NEED TO SELECT BRANCH CODE(BC)...

    Zilan85 pointsBadges:
  • OPNQRY

    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*/...

    Secskc25 pointsBadges:
  • Can anybody give me an example for OPNQRYF and call program?

    Can anybody give me an example for OPNQRYF and call program with detail? ( i.e. how a call program is retrieving the data to the OPNQRYF program) Moderator note: This is a reader submitted question to our inbox.

    BrentSheets6,925 pointsBadges:
  • Getting wildcard results from OPNQRYF

    Hi all, I am trying to query a PF to get back all records where fields OWNER1 and OWNER2 have an entered user value (ie; JOHN - I would want to return JOHN, JOHNATHON, JOHNS, ARJOHNS, etc) The best so far I have been able to come up with is: DCL VAR(&CF03) TYPE(*CHAR) DCL VAR(&INOWN) TYPE(*CHAR)...

    Geojf385 pointsBadges:
  • Activation Groups and Open Query File use

    I am executing a CLLE program that uses an OPNQRYF to select records from file "FILE1" which is a physical file containing in excess of 1 million records. I only need records with a specific date (about 5000 records) The file is opened for share = *yes and the program calls an RPGLE program that...

    wmfsr20 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following