Re: ACS Run SQL Scripts and inquiry message CPA32B2

Is Options, "Stop On Error" checked?


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Paul Bailey <PabloMotte+Midrange@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 11/29/2016 10:57 AM
Subject: ACS Run SQL Scripts and inquiry message CPA32B2
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



I'm messing about with some new files, building a small set with the Run
SQL Scripts plugin for IBM's ACS.

I've built a fairly standard set of SQL statements for dealing with a
file,
starting with a CREATE, going through some LABELs, a few INSERTs and a
SELECT or two. I decided that the size of one field was too big so I ran
the following statement:
ALTER TABLE Employee_Details ALTER COLUMN Surname SET DATA TYPE CHAR(50);

I'm expecting that to change the length of Surname from 80 to 50. (This
example is a little contrived, for the sake of example, but this happens
for any ALTER TABLE or CREATE OR REPLACE statement where loss of data
might
occur.)

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.


-Paul.


P.S. I'm using ACS v1.1.6.1 and IBM i v7r1.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.


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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.