• 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,790 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...

    Durgesh813375 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:
  • CL – OVRDBF

    I am executed the below statements using CL. FileA got deleted. I want to know the reason. Please help me to understand the logic. PGM OVRDBF FILE(TESTPF) TOFILE(TESTPF1) OVRDBF FILE(TESTPF1) TOFILE(TESTPF2) OVRDBF FILE(TESTPF2) TOFILE(TESTPF) DLTF FILE(TESTPF) DLTOVR FILE(*ALL) ENDPGM FILEA got...

    rajeshece1,230 pointsBadges:
  • Problems using QTEMP in a CLLE

    I have a CLLE program. I'm creating a file in QTEMP. Then I do an OVRDBF to the QTEMP file. Then I call an RPGLE to output records to the QTEMP file. The records are actually going to a file in my library list, not QTEMP. How do I get a CLLE to use my QTEMP file?

    krtkrt5 pointsBadges:
  • CPF4102 ON FILE THAT IS IN QTEMP ACTIVATION GROUP PROBLEM(MAYBE)

    CLPgm_1 …..: FILE_1 IS CREATED IN QTEMP FROM A CRTDUPOBJ AND DATA IS COPIED INTO IT FOR A CERTAIN MEMBER. CLPgm_1 …..: CALLS CLPGM_2 THAT EVENTUALLY DOES AN OVERRIDE WITH MBR(&FMBR) SECURE(*YES) OVRSCOPE(*JOB) SHARE(*YES) OPNSCOPE(*JOB) FILE_0 TO FILE_1. ClpGM_2……: CALLS RPGPGM_1 AND THE...

    Amjim25 pointsBadges:
  • Can you use an USROPN speceifcation on a file that is being overridden?

    Can FILE1 in the over ride also have USROPN assigned to it in PGM1? PGM  OVRDBF FILE(FILE1) TOFILE(QTEMP/FILE2) + MBR(&FMBR) SECURE(*YES) SHARE(*YES) CALL *libl/PGM1 ENDPGM

    Amjim25 pointsBadges:
  • Error while using OVRDBF

    Hi I am using OVRDBF command in my cl program in order to apply a particular select criteria on a database file in order to pass it to the RPGLE code. The syntax I used is as below: OVRDBF     FILE(MYFILE) TOFILE(MYFILE) +                      MBR(MYFILE) OVRSCOPE(*JOB)...

    VivekSharma120 pointsBadges:
  • RPGIV Coding Approach for 1 billion records

    I have 1billion records in a PF.Key filed  is Date.I want to generate a report based on Key field.Which approach will be best for me (I mean shall i go with OVRDBF or any other approach)Please suggest.(RPGIV-Free Format-V5R4)

    Pankaj112265 pointsBadges:
  • What could be the reson for OVRDBF and OPEN on file is not working in RPGLE program.

    Hi All, Can anyone please help me with below issue. The is a program abend in our production system in RPGLE program and with in that following operations happening, but i found errors while running program as below. following are the breif Sequence of operations written in RPGLE: 1. File(FMABCF)is...

    Mohan K695 pointsBadges:
  • What is Open Data path in OVRDBF?

    What is meaning of Share(*yes) In Ovrdbf?

    Sms121185 pointsBadges:
  • Unable to override a PF member

    Hi, I am trying to override a physical file using CL. The CL program is being called by a CBLLE program. In the CBLLE program, I want to process the overridden member.But,all the processing is going on the first member only.It looks like as soon as the CL program terminates DLTOVR gets executed...

    Prabhjot8515 pointsBadges:
  • OVRDBF without any parameters specified

    Can we specify an overide statement without actually specifying any parameters to be overridden. In one of the exisiting codes (in a CL)I saw a line as follows: OVRDBF             File(ZFT00981)     ToFile(ZFT00981) No parameters were specified. The file name is exactly same. The...

    WaheedAnsari5 pointsBadges:
  • OVRDBF SHARE(*YES)

    When OVRDBF SHARE(*YES) is used on "FILEA" and you have "FILEA" defined in "ProgramA" and "ProgramB". I know that doing a READ, START etc... in either program moves the Pointer for both programs since they share the buffer. But are the FIELD values for "FILEA" the same in both programs? EXAMPLE:...

    BeanBaggs220 pointsBadges:
  • How to use “Program-Described-File” for converting an AS/400 numeric field into Char-field

    My situation is..... I have a file which is old & got 18,000 records in it. It has a numeric-field(Amount, Len 9,2). Now the 'Amount'Field in the file is changed to 12-char, in the new library. only this field's name is changed in order to avoid ambiguity. Otherwise the file-name & other fields...

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

Following