• Embedded SQL over multiple physical file members

    Hi, I'm writing a program to process all the members in a physical file. I've done this using embedded SQL because the selection criteria is quite complex. The physical file belongs to an application which I can't change, so I will always have to deal with multiple members. I also don't have the...

    Gilly40023,730 pointsBadges:
  • ovrdbf doesn’t get deleted with a dltovr

    I've got a cl that copies a PF file to qtemp then I use CRTDUPOBJ to get a LF attached to the qtemp PF file. Then ovrdbf of LF to qtemp/LF with OVRSCOPE(*JOB). After calling 2 programs to update the qtemp/LF I DLTOVR FILE(*ALL) LVL(*JOB). But the override stays doesn't get deleted. I can't figure...

    Mtspudgun45 pointsBadges:
  • Not able to override a database file in CL

    Hi, I am trying to override a physical file using CL. But,when I go and delete the override, I get an exception that it was never overriden. :( Any help will be highly appreciated

    Prabhjot8515 pointsBadges:
  • I have an OVRDBF command that quit working.

    I added 3 fields to each of the files referenced in the OVRDBF command and then recompiled all 5 CLP's that have the same OVRDBF command in them. Here is a copy of the CLP.... CHGVAR VAR(&TITLE) VALUE('SETLMAST' *CAT &YEARC) CPYF FROMFILE(*LIBL/&TITLE) TOFILE(SM1099) + MBROPT(*REPLACE) FMTOPT(*MAP...

    BobAnnBri5 pointsBadges:
  • Embedded SQL to process ALL members

    Hi, I'm trying to get an RPG with embedded SQL to read all the members in a file. I know I used to be able to do this with an OVRDBF command with *ALL specified for the member, but this doesn't seem to work anymore. In the joblog I get a CPF4268 message which says the file has no members or is not...

    Gilly40023,730 pointsBadges:
  • File access in Rpg

    Hi All, Suppose you have 3 members in a database file. How to read records from all the members without using CL (OVRDBF) ie it should be handled exclusively in an RPG program? Thanks Venkat

    VENKYAS40075 pointsBadges:
  • Override to file in QTEMP deleted on its own?

    We have a job that is run each night during our batch, that has the following functionality: 1. A utility is called, to create a flat file in QTEMP (32766 characters). I'll call this "File A" 2. An OVRDBF command then overrides to this file ("File A") 3. A program is then run, which processes...

    Deasel9820 pointsBadges:
  • SQL File Member Can SQL on i allows users to select a specific member to be processed without using a OVRDBF command

    Cqn SQL on i allows users to select a specific member to be processed without using a OVRDBF command

    Cragrat5 pointsBadges:
  • SQP file members

    Does SQL on AS400/iSeries allow selecting a specific member to be prcesssed without using a OVRDBF command?

    DMinNC10 pointsBadges:
  • what are the main functionalities of ovrdbf ?

    what are the main functionalities of ovrdbf ?

    Zilan85 pointsBadges:
  • OVRDSPF and OVRDBF

    Hi, Good afternoon.Can you tell me what is difference beteween ovrdspf and ovrdpf?

    0 pointsBadges:
  • SECURE(*YES)

    Hi, This is venkatesh.what is the meaning of SECURE(*YES)and SHARE(*YES) in OVRDBF in real time senario?

    0 pointsBadges:
  • OPNQRY and ovrdbf

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

    VENKYAS40075 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