Why use OVRDBF before OPNQRYF in AS/400?

2475 pts.
Tags:
AS/400
cl 400
OVRDBF
Why we need to use OVRDBF file before doing OPNQRYF? What is it (OVRDBF) doing actually?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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

Discuss This Question: 8  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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
  • TomLiotta
    This is not the place to ask that question. Use the Information Center to find basic system information. This site is for problem assistance. Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    And we can't know why you would need OVRDBF before OPNQRYF because you haven't shown us your code nor told us what the problem is. Since OVRDBF isn't required in order to use OPNQRYF, we don't know why it is needed in your situation. -- Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    Tom is right use the information center.Here is a quick, inaccurate guide to what you read.Opnqryf creates a path to the data.ovrdbf replaces a path used by your application program with another path such as the one created by he opnqryf.Phil
    50,860 pointsBadges:
    report
  • Sureyz
    Oh.. But in many articles they telling we need to define OVRDBF before using OPNQRYF. Let me try then i will come here.. Thanks
    2,475 pointsBadges:
    report
  • philpl1jb
    Certainly the practice is OVRDBF before OPNQRYF but I don't know if the order matters.  Today we are much more likely to use SQL in the application programs to achieve the same results.
    50,860 pointsBadges:
    report
  • TomLiotta
    If your use of OPNQRYF requires OVRDBF, then the OVRDBF does need to be before OPNQRYF. If you put it after OPNQRYF, then it won't be in effect when OPNQRYF executes.   That's always true of OVRDBF. It always must be executed before it is needed. It doesn't make any difference if you're using it for OPNQRYF or for some other purpose. OVRDBF is only required with OPNQRYF if your programming needs an override. If it doesn't need an override, then you don't need OVRDBF.   But we can't spend our time teaching about what OVRDBF does. That's what you go to school for, or that's what the Information Center is for, or that's what you practice and experiment for. We are all volunteers here. We're not paid teachers.   Unless you actually have a problem, we can't help.   Tom
    125,585 pointsBadges:
    report
  • Sureyz
    Thanks Tom..
    2,475 pointsBadges:
    report
  • y2xx
    How can you be so stupid? You do not like what you do?
    10 pointsBadges:
    report

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