Re: Trouble managing OVRDBF inside a program

Hello Luca

We have al lot of these situations in which you need to perform CRUD operations on tables in different libraries depending on a value in some config file.
If you don't want to create a dynamic statement you can also create an alias for the table in Qtemp and perform the insert on that alias.
Although the "create alias" needs to be done in a dynamic statement as well, you can wrap it in a service program and dispatch all the alias handling and administration to that service program. Placing them in Qtemp saves you some garbage collection.

In your program you just code
Exec sql
     Insert into myAlias (x, y, z) values(:x, :y, :z)
which in most cases is easier to code that a dynamic statement


Kind regards



Martijn van Breden

lead software architect




The file is not specified in any F or dcl-f specification. The program does
not contain any F or dcl-f specification of its own. Unless OVRDBF does an
implicit opening itself.
I must add that the closing of the over dub is done by the program, in fact
at the next iteration of the cycle the data is written in the default file
present in the library list instead of in the file that I would like to
replace with the OVRDBF

Il giorno lun 2 feb 2026 alle ore 14:51 David Gibbs via RPG400-L <
rpg400-l@xxxxxxxxxxxxxxxxxx> ha scritto: