Home > IT Answers > AS/400 > OVRDBF without any parameters specified
WaheedAnsari
5 pts.
 OVRDBF without any parameters specified
AS/400, AS/400 Parameters, CL, CL Parameters, iSeries, OVRDBF
Can we specify an overide statement without actually specifying any parameters to be overridden.

In one of the exisiting codes (in a CL)I saw a line as follows:

OVRDBF             File(ZFT00981)     ToFile(ZFT00981)

No parameters were specified. The file name is exactly same.

The program is being used since ages. Hence I know this will not result in any runtime error.

But will this command have any affect on the file access or any affect in the program?

I think it will not have any affect. I think it will not make any difference anywhere even if we remove this line.

Please comment.



Software/Hardware used:
AS/400
ASKED: May 27, 2011  9:54 AM
UPDATED: May 30, 2011  5:18 AM
RELATED QUESTIONS
Answer Wiki:
Yes, I do agrre with you. There will not be any impact even after removing the command from CL. And, When it comes to parameters for that command, it is not mandatory to have the parameters for OVRDBF command. So, it will not give any error. Make sure that, You are removing corresponding DLTOVR command also. But, in general we use parameters with this command for Overriding the actual DataBase file. There will not be any impact of this command in progra. You can test the same by removing the same. Pradeep.
Last Wiki Answer Submitted:  May 30, 2011  5:17 am  by  deepu9321   3,370 pts.
All Answer Wiki Contributors:  deepu9321   3,370 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

I’m not aware of an impact in normal operations.

Potential impacts do exist, though.

First, a later DLTOVR might fail if this is removed. Ensure that no DLTOVRs reference this OVRDBF.

Second, if parameter defaults have been modified or if a duplicate of the *CMD object exists with different parameters, then there might be overriden values that affect program execution. Make sure that neither of those conditions exist.

Third, programming later in the job might look for an override for ZFT00981 and cause different logic paths depending on existence or non-existence.

There might be other possibilities. Those are what come to mind immediately. None of them seem very likely, especially if there are no comments that indicate something unusual is being done.

Regardless, be prepared for possible side-effects.

Tom

TomLiotta
 108,095 pts.