Ignoring messages in SQL scripts

["McCallion, Martin" <martin.mccallion@xxxxxxxxx>]

Hi all.

I have written an SQL script which simply removes the null-capability
from a column.  The entirety of the code is this:

        ALTER TABLE DVMLINK.INCOMINGMESSAGES ALTER COLUMN MOR SET DATA
TYPE
        VARCHAR ( 28) NOT NULL;

If I run this interactively in STRSQL, I get a program message which I
can respond to with an 'I' to ignore.  When I run it from OpsNav, it is
automatically answered with the cancel message.

I know I could change the system reply list to force the 'I' answer, but
we will be giving this to clients, and I'd like them just to be able to
run the script, without having to change the reply list first and then
remember to change it back afterwards.  Is there a way to tell the
script to ignore the message?

I can't find anything in the manuals, or on the web, except one exchange
in the archives, where David Gibbs asked how to do the same thing in RPG
with embedded SQL.  R. Bruce Hoffman, Jr. answered that he always did
this in scripts (see
http://archive.midrange.com/rpg400-l/200109/msg00327.html).

So, David?  Bruce?  Anyone?

TIA.

Cheers,

Martin.

--
Martin McCallion
Senior Technical Consultant
Work:  martin.mccallion@misys.com
Home: martin.mccallion@ukonline.co.uk
Misys International Banking Systems
1 St George's Road, London, SW19 4DR, UK
T +44 (0)20 8486 1951
F +44 (0) 20 8947 3373
www.misys.com
This email message is intended for the named recipient only. It may be
privileged and/or confidential. If you are not the  intended named
recipient of this email then you should not  copy it or use it for any
purpose, nor disclose its contents to any other person. You should
contact Misys International Banking Systems as shown below so that we
can take appropriate action at no cost to yourself.
Misys International Banking Systems Ltd,1 St
George's Road, London, SW19 4DR, UK. Email: ibs.postmaster@misys.com.
Tel: +44 (0) 20 8879 1188 Fax: +44 (0) 20 8947 3373
Misys International Banking Systems Ltd is
registered in England and Wales under company no. 971479