• Read selective file in CL by using OVRDBF

    How do I read selective file in CL by using OVRDBF by positioning to from particular record till selective record? Lets say I have Emp (record format is REC) file which is having 10 records (rrn or key field). Now I want to read file from 2nd record till 8th  record, how can we do this with...

    hndajad195 pointsBadges:
  • How to use OVRDBF via ‘QCMDEXC’ for Creating Override Database File in RPGLE?

    Hi All, I am trying to do Prompt option for my disply file. So that I created *OUTFILE (PPROMPT) using DSPFFD. Then I declared Program-Described File (TPPROMPT) with USROPN. Then while trying to Create Override Database File (OVRDBF) using CALL 'QCMDEXC' PLIST1, It couldn't create that. When try to...

    smmloganathan50 pointsBadges:
  • Is OVRDBF good to use for a query selection?

    Is OVRDBF good to use? I'm planning to query selection from a huge database file and then use OVRDBF. This job will be submitted multiple. Is this a good design in term of processing time?

    yeepiyaya220 pointsBadges:
  • OVRDBF at different call levels

    Hi, I am using the command: ovrdbf file(file1) tofile(file2) in the CL program and I'm calling an RPG program again in that I want to override the same file (file2) to different members (using qcmdexe). How to do that?

    Friends10219875 pointsBadges:
  • What are the main functionalities of ovrdbf?

    What are the main functionalities of ovrdbf?

    Zilan85 pointsBadges:

    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.

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

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

    22917560 pointsBadges:

    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 Rubenstein11,160 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:

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

    Durgesh813375 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,735 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.