Re: Trouble managing OVRDBF inside a program
Luca Giammattei <[email protected]>
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
Il 02/02/2026 22:53, Jon Paris ha scritto: > Have you tried using SETSCHEMA instead of OVR as I suggested on another forum? > > > Jon Paris > [email protected] > I'm sorry I haven't updated you on the Scott Klement's forum. Yes, SETSCHEMA could work, but it would have required a much more complex program design modification, introducing a new procedure into an existing service program. This isn't a big deal, but it's much more tedious than altering an existing procedure, which I've already completed the necessary modifications to. Keep in mind that in our system, all file reading/writing is handled by procedures in dedicated service programs. In any case, I'm still curious as to why overdub works the first time and not the second, without leaving any error traces in the job log. In debug, I tried changing the various command parameters, and it doesn't work. The simplest explanation I've come up with is that perhaps overdub requires the declared file (it's the only change I haven't been able to make at the moment). Obviously, working with a full SQL environment also requires abandoning certain techniques, switching from a file overdub to a dynamic SQL file or a statement like setschema. -- 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: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l. Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.