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 mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
