Answer / syam

Before calling another program use DLTOVR fileName LVL(*).

LVL(*) = Call Level (*CALLLVL)

If I am wrong pls correct

Answer / syam

Sekhar214's answer is correct....Thanks

DLTOVR FILE(Filename) LVL(*JOB)

Answer / david lex

The question is somewhat ambiguous. The OVRDBF command
contains MANY parameters, all of which have a very
different impact on the file.
Very often the OVRDBF is used to access the same file in a
different library, but that is not always the case.

It is also of note that the TYPE of programs are not
mentioned - are they CL, CLLE, OPM RPG, ILE RPG, COBOL...
or a combination? It does make a difference, specifically
as to whether you even need to take this approach.

The most common scenario is a CL overriding a file/Lib1 to
file/Lib2 then calling an RPG/Cobol pgm. But in this
scenario the override is generally required in the
RPG/Cobol program.

Answer one does not address the override. Unless using
embedded SQL or some non standard technique, one must
include the file being used in the F-specs regardless of an
override scenario.

Answer two (with nuances) will have the desired effect, but
there are other things to consider before merely removing
the override.

Do you need the override in place upon return to the
calling program? If you do, you'll have to re-issue the
override.

Additionally, the call level on the DLTOVR command must be
the same that was on the original OVRDBF issued, otherwise
it will fail (albeit silently) with something
like 'Override not found at specified level'.

Defaults on the system in question also come into play.
What is your default activation group?

There are a variety of ways to handle this, each with
strengths & weaknesses.

Embedded SQL, new activation groups, using a QUALIFIED file
opening, call stored procedures, exported procedures in a
service program, etc.

It VERY much depends on the original intention of the file
override to begin with.

Answer / vivek dwivedi

Share ODM (*NO)

Answer / sekhar214

Depends on the coding. If that is an interactive JOB and OVERSCOPE os on *JOB level, you have delete the overrides.

DLTOVR *ALL LVL(*JOB)

If that is a batch job , no impact on other jobs.

Answer / s kumar

Suppose File Name(MyFile) is overriding to File(MyFile1) in
one Cl program (i.e ClPGM1) by

Ovrdbf File(MyFile) ToFile(MyLib/MyFile1)

Now You are calling the program(i.e RPG1)in Cl Pgm(CLPGM1)
and want to use same file(MyFile1)

So Just Declare the File in F- spec

F MyFile1 IE F Disk
.
.
.
In this way we can use the file

Hope you got your answer!

Thanks!!

write an RPG program to calculate the marks of 5 students (A,B, C, D, E)in 3 different subjects (eng, math, sci) an display on the screen

0 Answers  

wat is curser?? and its types???

4 Answers   HSBC,

Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?

0 Answers  

I have one cl program which calls two rpg programs named a & b. I am loading a run time array in Pgm A and the control comes back to cl pgm. i call pgmb and I want to read the runtime array in pgmb which was loaded in pgma. How it can be acheived. I should not use any intermediate file or dataarea to store the loaded values.

2 Answers  

Need a sql query: retrieve all duplicate records in table?

1 Answers  

What is SFLNXTCHG keyword why it has used and where? Briefly explain with Example.

2 Answers   IBM,

What is the difference between ITER and DO ? I know both are used to execute set of statements repeatedly, but what is the main difference?

2 Answers   CGI, Wipro,

I know whole thing ab't Arrays related to declaration..can anyone tell me what exactly use of array or anyone faced a situation where he found use of array must....

1 Answers  

what is the difference between the procedure and module in ILERPG?

4 Answers  

purpose of pannel group??/

2 Answers   CTS,

1.How to read a subfile in out put mode? 2.what are the keywords used to share same file? 3.using composite key which rpg code used?

3 Answers   HSBC,

How can we change element of compile time array?Can we do so

1 Answers   TCS,