DLTOVR

Tags:
AS/400
DLTOVR
Why we have to use DLTOVR after OVRDBF command?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.
You can override database and printer files using OVRDBF and OVRPRTF.
This is to allow a temporary change for use of another fileto be used by the program without making another version of the progam.
The DLTOVR is to remove the temporary change of the database or print file,and allow normal processing to continue.
These commands can be done in an ILE program but are mostly done in a CLLE or manually from a command line.

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.
  • TheRealRaven
    Why are you thinking it has to be deleted? (Is this needed for an interview?)
    35,620 pointsBadges:
    report
  • Splat
    You don't have to, but it may well cause problems if you don't.
    12,895 pointsBadges:
    report
  • ToddN2000
    IF it is a batch job then the program will "delete" the OVRDBF when it ends. It this is done manually or by an interactive program it remains in effect until you "delete" it manually. Like the others said you do not have to delete if you want this to remain in effect. If you are running another job that uses the same file you may not get the results you are looking for.
    133,625 pointsBadges:
    report
  • pdraebel
    I think pairong OVRDBF and DLTOVR in programs is a sound practice particularly for Interactive programs. Overrides that remain active after a certain program has ended can cause issues in programs called after the initial program. Once you find an override that was left active is the cause of the second program not producing the desired results you will have to chase the program that left the override active. Bonne Chance, or in English Good Luck to find the offending program.
    7,545 pointsBadges:
    report
  • TheRealRaven
    It can also be "sound practice" not to have a DLTOVR. It depends on why an override is needed in the first place. For example, members might be created on a per-user or per-workstation basis and the member might be used throughout the life of an interactive job. A DLTOVR could cause trouble if it shouldn't be run.
    35,620 pointsBadges:
    report
  • pdraebel
    Agreed RealRaven, as always it depends on the setup of things. One could need Overrides that have to stay in effect throughout the lifetime of a job.
    7,545 pointsBadges:
    report
  • ToddN2000
    That is true, I worked for a company years ago that had overrides that took place in the profiles initial program call. Their file structure had multiple members. A member for test, production, configuration and a few others. Your login determined which member set you were to use. These needed to stay active until the user signed off. Otherwise they could corrupt data unintentionally.
    133,625 pointsBadges:
    report
  • dkumarvats909
    Thanks All for your valuable answers.
    20 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.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: