1
  • 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?

    AnonymousUser18,240 pointsBadges:
  • 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

    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.

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

Following