DB2 FOR LUW / DB2FORLUW / 970 - DB2

While executing a PL/SQL anonymous block (or SQL PL compiled 
compound statement), you will obtain error SQL0751N in the 
following situations: 
 
- The anonymous block contains a ROLLBACK statement. 
- The anonymous block invokes a routine that causes a ROLLBACK 
statement to be executed. 
 
For example: 
 
begin 
  rollback; 
end; 
/ 
 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0751N  Routine "SYSIBMINTERNAL.COMPILED_ANON_BLOCK_INVOKE" 
(specific name 
"SQL100310140808540") attempted to execute a statement that is 
not allowed. 
 
create or replace procedure P 
is 
begin 
  rollback; 
end; 
/ 
 
begin 
  p; 
end; 
/ 
 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0751N  Routine "MYSCHEMA.P" (specific name "P") attempted to 
execute a 
statement that is not allowed. 
 
This behaviour is a known limitation in DB2 Version 9.7.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL.                                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See the APAR description.                                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade DB2 UDB version 9.7 fix pack 2.                      * 
****************************************************************

Convert the anonymous block to a stored procedure, and invoke 
the procedure using CALL.  For example: 
 
create or replace procedure Q 
is 
begin 
  p; 
end; 
/ 
 
call Q; 
 
drop procedure Q;

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 UDB Version 9.7 Fix Pack 2.

See LOCAL FIX.

forerunner  : APAR is sysrouted TO one or more of the following: IC67297 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

11.02.2010
17.05.2010
17.05.2010

9.7.FP2