alter table gbsclus.emp drop column emp_id
SQL0952 Processing of the SQL statement ended. Reason code 10. Cause . . . . . : The SQL operation was ended before normal completion. The reason code is 10. Reason codes and their meanings are: 1 -- An SQLCancel API request has been processed, for example from ODBC. 2 -- SQL processing was ended by sending an exception. 3 -- Abnormal termination. 4 -- Activation group termination. 5 -- Reclaim activation group or reclaim resources. 6 -- Process termination. 7 -- An EXIT function was called. 8 -- Unhandled exception. 9 -- A Long Jump was processed. 10 -- A cancel reply to an inquiry message was received. 0 -- Unknown cause. Recovery . . . : If the reason code is 1, a client request was made to cancel SQL processing. For all other reason codes, see previous messages to determine why SQL processing was ended.
Processing ended because the highlighted statement did not complete successfully
SystemAdmin 110000D4XK3129 Posts
Re: Error in dropping column2004-11-01T19:38:33ZThis is the accepted answer. This is the accepted answer.The cancel reply to an inquiry message has to do with CPA32B2 somewhere previous to the SQL0952 message. The default message reply is 'C'.
Two way I know around this is:
1. Change the default message reply in the message file (WRKMSGD CPA32B2) to an 'I'.
2. Add an entry in the reply list entry screen for CPA32B2 with the default reply as 'I'. You also need to make sure the job description for that job has the parameter 'Inquiry message reply' set to *sysrpyl.