Re: SQL commands over ODBC: Changing tables triggers inquiry messages

My pleasure !!

The qaqqini table can do a lot of optimization and behaviour of "old"
defaults. Now you can even override it with the qsys2.override_qaqqini
procedure;

https://www.ibm.com/docs/en/i/7.4.0?topic=qaqqini-query-options

You are so welcome Patrik;



On Mon, Aug 18, 2025 at 9:32 AM Patrik Schindler <poc@xxxxxxxxxx> wrote:

Hello Niels,

Am 18.08.2025 um 08:30 schrieb Niels Liisberg <nli@xxxxxxxxxxxxxxxxx>:

Try this - call this procedure before any drop tables / drop columns etc:

call qsys2.override_qaqqini(2, 'SUPPRESS_INQUIRY_MESSAGES','*YES');

Excellent!! You not only answered my question, but you also helped me to
know how to change the default! Thanks a lot!!

:wq! PoC


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.