Re: SQL DROP field without overriding message replies?

As a follow-up, I wrote a post regarding this question in IBM's
developerWorks site, and Kent Milligan kindly gave an answer. The relevant
posts were:

------------
LuisRodriguez<http://www.ibm.com/developerworks/forums/profile.jspa?userID=97646>
Posts: 4
Registered: Jan 26, 2006 08:28:00 AM How to drop a column with JDBC?
Posted: Aug 15, 2011 05:49:09 PM
[image: Click to report
abuse...]<http://www.ibm.com/developerworks/forums/abuse!default.jspa?messageID=14672488>
[image: Click to reply to this
thread]<http://www.ibm.com/developerworks/forums/post!reply.jspa?messageID=14672488>
Reply<http://www.ibm.com/developerworks/forums/post!reply.jspa?messageID=14672488>
How can I run an ALTER TABLE / DROP COLUMN against a DB2/i table using JDBC
WITHOUT having to add and / or change the message reply list?

Thanks,

Luis Rodriguez
krmilligan<http://www.ibm.com/developerworks/forums/profile.jspa?userID=176160>
Posts: 164
Registered: Jul 31, 2007 05:12:13 PM Re: How to drop a column with JDBC?
Posted: Aug 16, 2011 12:59:14 PM [image: in response to:
LuisRodriguez]<http://www.ibm.com/developerworks/forums/message.jspa?messageID=14672488#14672488>in
response to: LuisRodriguez's
post<http://www.ibm.com/developerworks/forums/message.jspa?messageID=14672488#14672488>

[image: Click to report
abuse...]<http://www.ibm.com/developerworks/forums/abuse!default.jspa?messageID=14672823>
[image: Click to reply to this
thread]<http://www.ibm.com/developerworks/forums/post!reply.jspa?messageID=14672823>
Reply<http://www.ibm.com/developerworks/forums/post!reply.jspa?messageID=14672823>
I'm not aware of any other options.

You can manage the reply list entry with SQL, but making calls to the
QCMDEXC stored procedure from your Java program.
Posted: Aug 15, 2011 05:49:09 PM
How can I run an ALTER TABLE / DROP COLUMN against a DB2/i table using JDBC
WITHOUT having to add and / or change the message reply list?
Thanks,
Luis Rodriguez
------------
[Milligan]
Re: How to drop a column with JDBC?
Posted: Aug 16, 2011 12:59:14 PM in response
I'm not aware of any other options.
You can manage the reply list entry with SQL, but making calls to the
QCMDEXC stored procedure from your Java program.

------------

So it would seem that the only way is changing the message's default reply.
Not really the best solution, I agree.

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Mon, Aug 15, 2011 at 2:51 PM, Luis Rodriguez <luisro58@xxxxxxxxx> wrote:

I concur that it is very annoying. I haven't found any way to circumvent
this, although I suppose there should be a way (Ops Nav seems to go the
CHGJOB INQMSGRPY route).

A search in the IBM support site shows an entry that looks promising:

--------
*Handling Inquiry Messages in Database Server Jobs
*
This document lists some of the problems that may occur in database host
server jobs
(QZDASOINIT) due to inquiry messages. It discusses several options on how
the inquiry messages
can be handled.
--------

Alas, the link does not work :-(

If you find a solution to this, please let us know...

Best Regards,
Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Mon, Aug 15, 2011 at 2:13 PM, David Gibbs <david@xxxxxxxxxxxx> wrote:

On 8/15/2011 9:28 AM, Luis Rodriguez wrote:

ADDRPYLE SEQNBR(1000) MSGID(CPA32B2) RPY('I')
CHGJOB INQMSGRPY(*SYSRPYL)

That's annoying ... because it's not always possible to alter the reply
list entries when running a alter table command via JDBC.

david


--
IBM i on Power - For when you can't afford to be out of business
--
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.