Hi Luca - good to hear about 24/7 🙂
Likely the best approach here might be to use a create alias for every Library/file combo you need to update.
You can create the alias in qtemp ( it will be a ddm-file object ).
Then you will be able to keep your sql-logic almost intact.
This is the same as making alcohol the main course but ..... 😱
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 10:09
To: rpg400-l@xxxxxxxxxxxxxxxxxx <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Trouble managing OVRDBF inside a program
Il 03/02/2026 09:55, stefan@xxxxxxxxxx ha scritto:
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
Hi Stefan, don't worry, we're open 24/7 :-)
I've pretty much come to the same conclusion: mixing legacy access and SQL in
the same program isn't a good idea, much like mixing different types of alcohol
during a meal or party isn't exactly a good idea. :-)
Thanks.
--
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
