• OPNQRYF & CPYFRMQRYF error

    The log is: output file file1 created file1 added to library mmember of file1 is opened in library. data option was not allowed with open option error reading member file1 in file1 0 records copied to file2

    Archnav01270 pointsBadges:
  • Outfile printing

    In CL, I've created a outfile out of dspobjd cmd. To this file, i've filtered a column using opnqryf. I've copied the output (cpyqryf) to a new file. While doing this, i'm getting the error data option was not allowed with open option' The log shows :The first file is created-> added to library....

    Archnav01270 pointsBadges:
  • OPNQRY File

    OPNQRYF Query Hi, I am having difficulty in figuring out the syntax for using the special keyword %values with the variables in the OPNQRYF command. Below is the &QRYSLT I used.  CHGVAR VAR(&QRYSLT) VALUE('(DQB8ST *EQ "A" *AND + DQJRCE *EQ %VALUES( ' *TCAT &MARKET + *CAT ' )) *OR (DQB8ST = "D"...

    Ankita135 pointsBadges:
  • OPNQRYF in CL

    HI I need to filter the records for the particular date range from a file and i need to store it in a temp file.File has date field with length 7,0 centurion date format... Can anyone post the code

    22917510 pointsBadges:
  • 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...

    Zilan85 pointsBadges:
  • CL/400 OPNQRYF returning empty records.

    hey there, I got an issue to be corrected. Current CL has and OPNQRYF select which sometimes return blank records. I need to add a condition which should check for such blank query result and by pass a call program. Can you guys help me in giving a hint on which way I can bypass this blank record...

    itkr125 pointsBadges:
  • QPNQRY start over

    Is there a CL command to restart/reset an Open Query from the beginning ? I could repeat the OPNQRYF command, but that's silly if a single command does the same thing   Mike

    aceofdelts1,850 pointsBadges:
  • OPNQRYF HOW?

    HI Everyone,  i need a idea, i have on CL program (pgm parm) a field wndate(8,0) and i need make a opnqryf (file1) compare wndate with mvdatl(8,0), but i only wanted the first 6 position (yyyymm) of both . Anyone give a idea how can i made this? OS/400 in V5R4M1 thanks in advanced.  

    BUG68235 pointsBadges:
  • OPNQRYF and iSeries V6R1 issue

    I had responded on a previous issue and it is suggested I create a new one for mine. Doing that and I am adding some of the info below my question.  I hope this is not too confusing.  I apologize in advance if so.  I starting having an issue with a RPGLE program after it was recompiled due to a...

    VGP300 pointsBadges:
  • AS400 OPNQRY FILE

    I want to use one non keyed Physical file as keyed file in RPGLE Program. I want to achieve this OPNQRYF Command. Is it possible? If 'Yes', How to compile the RPGLE Program? Eg: File1 - Non Keyed File Program1 I want to use FFILE1IF E K DISK How do i achieve this?

    rajeshece1,215 pointsBadges:
  • QRYSLT in OPNQRYF

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

    svankipu560 pointsBadges:
  • logical file

    what is the difference between OPNQRYF and LF

    Hemavijay85 pointsBadges:
  • 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 or...

    Nelson01250 pointsBadges:
  • 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,...

    Mohan K695 pointsBadges:
  • 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

    Mohan K695 pointsBadges:
  • 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...

    Ashnirody100 pointsBadges:
  • 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:

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