• OPNQRY and OVRDBF

    Hi, Can you please tell me more about OPNQRY and OVRDBF and why we are going to use them? Thanks &Regars, Raum

    VENKYAS40075 pointsBadges:
  • What is ovrdbf?

    Hi all, Actually I know OVRDBF is used to override database file. After OVRDBF, we have to use OPENQRY command. But my question is: What purpose this OVRDBF file created and after creation it will be accessible to all the programs at a single time? Meaning can we access OVRDBF file in multiple...

    Sms121185 pointsBadges:
  • Having a file with multiple members in it

    Hi, I have a file with multiple member in it. In CL, I'm saying to ovrdbf mbr(*all). I want an logic to find when the first member got finish reading. And also when the member is reading, I want to find when that particular member got completed.

    srivijay1145 pointsBadges:
  • OVRDBF Command (Record not present after file Overridden.)

    I'm trying to execute following command: OVRDBF FILE(PF2) TOFILE(TESTLIB/PF@) MBR(*ALL) SHARE(*YES) PF2 file having records and PF@ is replica of PF2. PF@ doesn't have any record but after OVRDBF, it should have records. After executing above OVRDBF command, PF@ still showing blank.

    ssssssssssssssss115 pointsBadges:
  • How to use OVRDBF to find specific field in my physical file data.

    So right now im trying to make a CLfile that prints out the fields on the SDA fields when i input the field number. For example, i have a customer database which has the fields EMPNO,EMPNAME,COMPNAME ,etc. so by typing the empno (lets say 'A00001' ) in the input field, i want to able to pull the...

    rootlocus5 pointsBadges:
  • OVRDBF -POSITION

    Hi,     How to position the record in CL based on the key value? I have tried this.my CL program is as follows... ***************************  PGM                                                    DCLF       FILE(PMS90/EMPMST90)                      ...

    22917515 pointsBadges:
  • OVRDBF and OPNQRYF

    Can we write OPNQRYF then OVRDBF with SHARE(*YES) and then call a program. Will this program will process only selected records from OPNQRYF or process all records?

    sunnygupta35 pointsBadges:
  • OVRDBF in real time

    Hi, Can anybody tell me about OVRDBF in real time answers?

    Ben Rubenstein7,535 pointsBadges:
  • OVRDBF does not convert all records

    I have 5 Different Files with 5 Members. I wanted to process all records in all members. I used OVRDBF FILE(FILE) TOFILE(FILE) MBR(*ALL command. It did not convert all records in all members. My AS400 version is not supporting EXTMBR(*ALL).

    rajeshece1,215 pointsBadges:
  • OVRDBF and UPDDTA

    I am using command OVRDBF to override my database physical file suppose "ABC " (file to be overridden) and second physical file let "DEF" (the one with which we are overriding) now I execute this command: OVRDBF FILE(ABC) TOFILE(LIBRARY/DEF). After the execution of this command when I use the...

    Durgesh813370 pointsBadges:
  • Unable to overwrite file with OVRDBF

    DCLF FILE(EMP001P) RCvF RcdFmt(EMPREC) OVRDBF FILE(EMP001P) TOFILE(EMP001P) MBR(SECOND) + SHARE(*YES) MONMSG MSGID(CPF0000) EXEC(SNDUSRMSG MSG("ERROR") ) RCvF RcdFmt(EMPREC) Here, I'm unable to overwrite the EMP001P file with second record. pls suggest correct way to do it.

    Kar425 pointsBadges:
  • Write record value onto DSPF using OVRDBF

    In a single CL/400 program, is it possible to declare physical file File1, then read a record and later writing the record value onto the DSPF using OVRDBF with in a same CLP?

    Kar425 pointsBadges:
  • OVRDBF not showing all file records

    In CL program, declared a file FILE01 and read some records, later using OVRDBF accessed another file FILE02. Still I'm getting records of FILE01 only but not FILE02. Why? Thanks Venkat

    VENKYAS40075 pointsBadges:
  • Temporary logical files with OVRDBF and OPNQRYF

    Hi All, I have a series of questions I would like to discuss few of them here. I'll post them in a different threads so that it will be easier to track them: AS 400 question 1: When you say that an OVRDBF and an OPNQRY creates a temporary logical file, - Say I am just using OVRDBF and not OPNQRY....

    juslikdat1440 pointsBadges:
  • Why use OVRDBF before OPNQRYF in AS/400?

    Why we need to use OVRDBF file before doing OPNQRYF? What is it (OVRDBF) doing actually?

    Sureyz2,475 pointsBadges:
  • AS/400 ODP

    What is use -> OPNSCOPE v. OVRSCOPE on OVRDBF?

    AS190 pointsBadges:
  • OVRDBF example

    I have been asked to prepare a small project in which we use a display file and and physical files. Now, I have to create a COBOL/400 program in which the user enters that name of the physical file and according to the name I have to enter empid and empname in that particular physical file. Now for...

    Durgesh813370 pointsBadges:
  • Can I override the record format name in a CLLE to be used in an RPGLE or can I qualify the record format name with a field value?

    Hello All, I ran into a roadblock writing a new purge process for my company. Here's the situation: I have 3 files that hold EDI Data that I need to purge: FILEA - Record Format FILEAR FILEB - Record Format FILEBR FILEC - Record Format FILECR All of the above files have the same record length,...

    Eric Witham690 pointsBadges:
  • OVRDBF & OPNQRY – AS/400 question

    AS/400 question: There is a scenario where: OVRDBF share (*yes) OPNQRY – To select only Active records CALL RPG1 But in my RPG all records are being processed. Just not active. What could be the reason behind it? And also, OVRDBF share (*no) OPNQRY – To select only Active records CALL RPG1 But...

    juslikdat1440 pointsBadges:
  • OVRDBF & OPNQRY – AS/400 question

    AS/400 question: Say, there are 3 programs. RPG 1, RPG2 & RPG 3. I have OVRDBF and OPNQRY which selects only active customer records. I want RPG 1 to use the OPNQRYF output data. I want RPG 2 to use the complete data I want RPG 3 to use the OPNQRYF output data again. This is how it was...

    juslikdat1440 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