• Using %NOT in OPNQRYF

    I know that %NOT is a function available for using in the qryslt parameter of opnqryf but I can't figure out how to code it. I would like to eliminate all records with a range in the middle of the possible range, for example, select all facilities except those is the range of 600 - 699. Is this...

    ITKE1,060,070 pointsBadges:
  • Improving performance using OPNQRYF

    I have a requirement that, in a country related code file. (CntryCode, Name, AccessNo) if these are three fields... and I would like to pass the respective country code and get only the required country values. But this is also taking time when using OPNQRYF with QRYSLT country code. Is there any...

    Varun123190 pointsBadges:
  • Problem with the syntax of OPNQRY command

    Hi I have a problem with the syntax of OPNQRY command I am getting values from a display file using RCVF and then using the qryslt parameter in OPNQRY to select a few records;See the command below OPNQRYF FILE((*LIBL/APH *FIRST *ONLY)) + QRYSLT('APCMPY *EQ ''*CAT XPCMP *CAT''') Where XPCMP(numeric)...

    itanswers0 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:

    How to write the qry in OPNQRYF for below condition All are char fields Field Names are F1,F2 & F3 F1 = 'ABC' or F1 BCD and F2 = 'OPQ' F3 = 'ghi' Please provide me sample code to write QRYSLT Expression

    Msharbudeen50 pointsBadges:
  • CL/400 – I want to know about QRYSLT(Please see below explanation)

    Hi, I am not well versed with code in CL/400, i know the concepts. I want to know what is he doing in the below code. e.g usibng the symbols '|>' and '||' and '<|' IF COND(&TODUE7 *NE '0000000') THEN(DO) CHGVAR VAR(&QRYSL) VALUE(&QRYSL |> ' *AND (ODUDT *GE + ' || &FRDUE7 || ') *AND')...

    svankipu625 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:

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.