Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


In a particular program one file is used where override
command is applied to a file, now this program calls
another program where we want to use the same file but
without override.How it can be done?

Answers were Sorted based on User's Feedback



In a particular program one file is used where override command is applied to a file, now this pro..

Answer / syam

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

LVL(*) = Call Level (*CALLLVL)

If I am wrong pls correct

Is This Answer Correct ?    15 Yes 1 No

In a particular program one file is used where override command is applied to a file, now this pro..

Answer / syam

Sekhar214's answer is correct....Thanks

DLTOVR FILE(Filename) LVL(*JOB)

Is This Answer Correct ?    3 Yes 0 No

In a particular program one file is used where override command is applied to a file, now this pro..

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.

Is This Answer Correct ?    2 Yes 0 No

In a particular program one file is used where override command is applied to a file, now this pro..

Answer / vivek dwivedi

Share ODM (*NO)

Is This Answer Correct ?    0 Yes 0 No

In a particular program one file is used where override command is applied to a file, now this pro..

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.

Is This Answer Correct ?    0 Yes 1 No

In a particular program one file is used where override command is applied to a file, now this pro..

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!!

Is This Answer Correct ?    3 Yes 13 No

Post New Answer



More RPG400 Interview Questions

can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.

0 Answers  


Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.

0 Answers  


what do you mean by an input subfile, what are the keywords required?

0 Answers   IBM,


WHERE DO WE USE COMIT KEYWORD IN AN RPG PROGRAM? YOU MADE SOME CHANGES TO DATABASE BUT YOU DON'T WANT TO SAVE THOSE CHANGES NOW? HOW DO YOU HANDLE THIS ONE?

2 Answers  


what procedure should we use to find whether the following operations are successful or not setll setgt chain read reade readp pls tell with example i'm not lazy to read the manual or not lazy to do anything.but sometimes i cannot understand the things given in manual in high level english its little bit complicated for me,i can't understand their way of writing thats why i ask these questions here and find the solution in simple words that i can understand thats the real reason sir.sorry if i had hurt you or disturbed you.please understand my situation.

5 Answers   iGate,






in which journalling which attributes are necessary

2 Answers   CTS,


I have learnt through Net that Debugging a Batch job involves 1. Submit the job with the HOLD (*YES) parameter: SBMJOB HOLD(*YES) or Hold the job queue that before submitting the job by using the HLDJOBQ command. 2. Determine the job name, user, and number of the submitted job by using the WRKSBMJOB command. 3. Type the Start Service Job command on your screen: STRSRVJOB JOB(job name/user/number) 4. Type the Start Debug command on your screen: STRDBG 5. Release the job in the jobq. Type WRKSBMJOB and then put a 6 beside the job to be released and press enter, or, if the job queue was put on hold, release the job queue with the RLSJOBQ command. 6. A display appears when the job is ready to start, saying that you can now begin debugging the job. Press F10 to show the Command Entry display. 7. Now you can start debugging by entering an Add Break Point command: ADDBKP 8.ENDDBG 9.ENDSRVJOB I tried this for RPG/400 Program and up to six steps of the above it's ok,but for me no source is displayed and i typed DSPMODSRC in Command line but still i can't see the sourceif i press F.10 and enter command ADDBKP i don't know how to add break points through it,usually i add break points using F.6 for Interactive job debugs,but since this is batch i don't know sir,Please help me out. I was asked this question in a interview,i know only RPG/400 and i’m asking for debugging of RPG/400 program only sir. or is it only possible to debug BATCH RPG ILE JOB and it is not possible to debug BATCH RPG/400 JOB kindly help me out sir

4 Answers   HSBC,


while i am using the dspmsg command on comman line in Mocha am getting error like Not authorized to message queue message my messagequeue Name? can anybody help me how to change my message queue Am anable to see my messages in message queue

1 Answers  


how can I tell when to replace the array?

0 Answers   IBM,


What you have to do in the display file when you are using message subfile?

1 Answers  


If there are 1000 member(PGM type) in a SRC file. How can we compile in a CL program? ( It need to be done in a loop)?

1 Answers  


this is rpg3 code W0RTN IFEQ @CN,002 what is the means @CN,002

1 Answers  






Categories