Home > IT Answers > AS/400 > AS400
rajeshece
1,025 pts.
 AS400
AS/400, AS/400 administration
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). Kindly suggect me to achieve this

Software/Hardware used:
AS400
ASKED: May 5, 2010  6:07 PM
UPDATED: May 17, 2010  10:11 PM
RELATED QUESTIONS
Answer Wiki:
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
Last Wiki Answer Submitted:  May 17, 2010  10:11 pm  by  TomLiotta   108,300 pts.
All Answer Wiki Contributors:  TomLiotta   108,300 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

TomLiotta
 108,300 pts.
 

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

rajeshece
 1,025 pts.
 

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

TomLiotta
 108,300 pts.
 

I have tried with OVRSCOPE(*JOB). Its working fine. Thanks Tom

rajeshece
 1,025 pts.