OVRDBF does not convert all records

1,215 pts.
Tags:
AS/400
AS/400 administration
OVRDBF
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). 

Software/Hardware used:
AS400
ASKED: May 5, 2010  6:07 PM
UPDATED: August 26, 2013  3:45 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

The most common cause is when a job uses ILE activation groups and the OVRDBF ignores activation groups.

The most likely correction is:<pre>
OVRDBF FILE(FILE) TOFILE(FILE) MBR(*ALL) OVRSCOPE(*JOB)</pre>
But that might be an improper scope. It might affect other programs in the job that should not see the override.

Test the change carefully.

Tom

Discuss This Question: 4  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
    It did not convert all records in all members. How do you know that it didn't? That is, what was the sequence of commands and what method did you use to read the file? Tom
    125,585 pointsBadges:
    report
  • rajeshece
    OVRDBF FILE(FILE) TOFILE(FILE) MBR(*ALL) Call RPGPGM In RPG Program Read file Dow Not %Eof(File) Update RFile; Read File Enddo I have checked manually in all the members. Records in member one got converted
    1,215 pointsBadges:
    report
  • TomLiotta
    OVRDBF FILE(FILE) TOFILE(FILE) MBR(*ALL) Since this has no scope specification... Call RPGPGM ...we need to know how this program runs. We can tell that it's RPG IV, but we can't tell if it is running as ILE. Is it in the *CALLER activation group? ...the default activation group? ...the same activation group as the OVRDBF? If you run this way:
    OVRDBF FILE(FILE) TOFILE(FILE) MBR(*ALL) OVRSCOPE(*JOB)
    ...does the behavior change? Tom
    125,585 pointsBadges:
    report
  • rajeshece
    I have tried with OVRSCOPE(*JOB). Its working fine. Thanks Tom
    1,215 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