1
  • Open query file selecting records(qryslt)

    This is my Physical file 'EMPS' existing in library "TAMIL1" and its record format is 'EMPRCD" a)its source is R EMPRCD                    ENO            4  0       ENAME         10          EADD          10   b)The records present in EMPS are as follows ENO  ...

    Kaly470 pointsBadges:
  • CLLE – Openqry Files

    Using opnqry files, we create any key field for physical file for temporarily usage.Instead of creating another logical can i create opnqry? Please give code

    Sudheerk9950 pointsBadges:
  • what is the query to be used in openquery file to read records in reverse from a database file

    what is the query to be used in openquery file to read records in reverse from a database file that is what is similar to readp in CL opnqryf

    Kaly470 pointsBadges:
  • OPNQRY and WRKQRY

    In wrkqry there is an option to save the selected records to an output file.Similarly is there a way to use OPNQRY in a CL or in an SQLRPG to directly move the selected records to another file?

    0 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:
1

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