Re: ACS Run SQL Scripts and inquiry message CPA32B2

[Buck Calabro <kc2hiz@xxxxxxxxx>]

On 11/29/2016 10:56 AM, Paul Bailey wrote:
> If I run this in Run SQL Scripts, I get SQL State 57014, and "[SQL0952]
> Processing of the SQL statement ended.  Reason code 10." Looking at the job
> log I find that I had message CPD32CC (Change to field ... may result in
> data loss) followed by CPD32CC (Change of file ... cancelled). The second
> level text for message CPD32CC says "The reply to inquiry message CPA32B2
> specified that the change request be cancelled".
>
> If I run the ALTER statement using STRSQL then the CPA32B2 inquiry message
> pops up and I can type I to ignore the warning and complete the file change.
>
> Is there a way to get the Run SQL Script tool to allow me to supply an
> answer to the CPA32B2 message somehow? I don't really want to change the
> default message reply for the whole machine.

At the top of your ACS scripts, issue the CL command

cl: chgjob inqmsgrpy(*rqd);

What is happening is the associated IBM i job that is attached to your
ACS script program is running with inqmsgrpy(*SYSRPYL) which tells the
job to 'automatically' answer messages via the system reply list.