OPNQRYF

logical file

what is the difference between OPNQRYF and LF

OPNQRYF AS/400 (RPGILE)

Dear all, i am done one program in this program one data base file which are Master file and it's use all day and lot of records are there, my program make the report it taking too much time, i am want to use OPNQRYF but it s not posible in master file because it's use some time any other option...

How to track OPNQRYF performance

Hi all, Recently i have done OPNQRYF on one transaction file which has around millions of records Program is taking same time to process as doing without OPNQRF. then what is the use of doing OPNQRYF. how can i track howmuch time OPNQRY has consumed. Regards, Mohan K

how to create new result field by concatinating two or more fields in OPNQRY.

Hi All, i want to create a new result field by concatinating two or more fields in OPNQRY for comparision. In detail: I have one tranaction file having millions on records however i want only records which were trasacted in last twodays. I have 3 seperate fields in trans file as TRYEAR, TRMONTH,...

OPNQRYF

Is it possible to access a file created by opnqryf in an RPG/400 program using keys? I have defined the KEYFLD parameter but the RPG doesn't find the records when using READE or CHAIN

OPNQRYF

DCLF FILE(LIBRARY/DISPLAY) START: SNDRCVF RCDFMT(REC) WAIT(*YES) IF COND(&IN03 *EQ '1') THEN(DO) GOTO CMDLBL(END) ENDDO IF COND(&ENQQUA1 *EQ ' ') THEN(DO) GOTO CMDLBL(START) ENDDO IF COND(&ENQQUA1 *NE *BLANKS) THEN(DO) OPNQRYF FILE((SARKNS/ENQP002)) OPTION(*ALL) + QRYSLT('&ENQQUA *EQ ''' *CAT...

OPNQRYF

PGM DCLF FILE(LIBRARY/DISPLAY) START: SNDRCVF RCDFMT(REC) WAIT(*YES) IF...

OPNQRYF

I have 4-fileds on Display File like frdiv(zoned),todiv(zoned),frpr(char),topr(char) all the fields are of size 2 only. I am using a "OPNQRYF" to filter the records froma Physical file (pfdiv), it containes 1,25,000 records . Through this openqryf all the selected records I will copy to a file...

CL400/OPNQRY

I HAVE A CASE LIKE THIS IN CL/400OPNQRYF 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 filter data according to...

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

opnqry

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

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 + ...

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.

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)...

CL - OPNQRYF

How to compare CL character field (year#) with packed decimal field(QRPS)of 3P0 length from file QRBT as equal. Please provide OPNQRYF statement for the same.

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 + ...

RCVF In CL

I am using nested RCVF to read PF's in a CL program. The second iteration of the inner loop does not happen because the pointer is set to end of file. How do I reset the pointer to start at the begining? I have tried OVRDBF, OPNQRYF, POSDBF and deleting and recreating the PF. Thank you for your...

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

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