Re: Trouble managing OVRDBF inside a program
Jon Paris <[email protected]>
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
Have you tried using SETSCHEMA instead of OVR as I suggested on another forum? Jon Paris [email protected] > On Feb 2, 2026, at 9:57 AM, Luca Giammattei <[email protected]> wrote: > > Martin, thanks for your reply. Just to clarify, to perform the insert, I > use a procedure within a service program that does many things beyond > simply "Insert." For example, it logs and reports data errors in the event > of an insert failure. For this reason, I'm having some difficulty changing > it. But now I've realized that I can't rely too heavily on the ovrdbf, and > as a result, I find myself having to manage a new procedure to insert into > our service program. Because both the dynamic nature of the insert and the > alias creation would require modifying the existing module. > Not a big deal, but very annoying. > > Il giorno lun 2 feb 2026 alle ore 15:36 Martijn van Breden < > [email protected]> ha scritto: > >> 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 < >> [email protected]> ha scritto: >> >> >> -- >> This is the RPG programming on IBM i (RPG400-L) mailing list >> To post a message email: [email protected] >> To subscribe, unsubscribe, or change list options, >> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l >> or email: [email protected] >> Before posting, please take a moment to review the archives >> at https://archive.midrange.com/rpg400-l. >> >> Please contact [email protected] for any subscription related >> questions. >> >> > -- > This is the RPG programming on IBM i (RPG400-L) mailing list > To post a message email: [email protected] > To subscribe, unsubscribe, or change list options, > visit: https://lists.midrange.com/mailman/listinfo/rpg400-l > or email: [email protected] > Before posting, please take a moment to review the archives > at https://archive.midrange.com/rpg400-l. > > Please contact [email protected] for any subscription related questions. > -- This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/rpg400-l or email: [email protected] Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l. Please contact [email protected] for any subscription related questions.