Re: SQL Whenever to ignore warning

Thanks, I didn't think of searching there this time.

Art

On Wed, Sep 17, 2025 at 12:37 PM Daniel Gross <[email protected]> wrote:

> Hi Art,
>
> look here:
>
> -> https://archive.midrange.com/rpg400-l/202210/msg00082.html
>
> This topic was discussed at the list multiple times.
>
> The CPA32B2 comes from the OS and can't be catched by SQL itself.
>
> Another solution is to change the SQL defaults from QAQQINI by SQL
> procedure calls:
>
> CALL QSYS2.OVERRIDE_QAQQINI(1); -- open options override
> CALL QSYS2.OVERRIDE_QAQQINI(2, 'SUPPRESS_INQUIRY_MESSAGES', '*YES'); --
> override defaults
> [critical section]
> CALL QSYS2.OVERRIDE_QAQQINI(3); -- close ovverrides
>
> This solution was proposed by someone on the Midrange list.
>
> HTH
> Daniel
>
>
> > Am 17.09.2025 um 18:00 schrieb Art Tostaine, Jr. <[email protected]>:
> > I am in RPG dropping a column like this:
> > exec sql ALTER TABLE QTEMP/WHSR0135Q DROP COLUMN DID CASCADE
> >
> > I have this statement in the beginning but I still see CPA32B2
> > exec sql WHENEVER SQLWARNING CONTINUE;
> > ;
> > Change of file WHSR0135Q may cause data to be lost. (C I)
> >
> > Looking for some help to get this error to be ignored.
> >
> > Thanks, Art
> > --
> > 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: [email protected]
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/rpg400-l.
> >
> > Please contact [email protected] for any subscription
> related questions.
> --
> 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: [email protected]
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact [email protected] for any subscription related
> questions.
>
>
-- 
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: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact [email protected] for any subscription related questions.