Hi, Sorry for being late to the party. My understanding is that you are using OVRDBF in combination with SQL based io ( Insert ).
If so - I guess that after the second I/O sql manager keep the file open regardsless of what you do in terms of open/close.
And if the file is still open it will not honor your ovrdbf's.
Run in debug mode and what's going on.
Best regards
Stefan
--
No trees were killed in the sending of this message, but a large number of electrons were terribly upset.
Stefan Tageson
+46 732 369934
stefan@xxxxxxxxxx<mailto:stefan@xxxxxxxxxx>
________________________________
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Luca Giammattei <luca.giammattei@xxxxxxxxx>
Sent: Tuesday, February 3, 2026 09:44
To: rpg400-l@xxxxxxxxxxxxxxxxxx <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Trouble managing OVRDBF inside a program
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
Jon.Paris@xxxxxxxxxxxxxx
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: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
midrange.com
