DB2 FOR LUW / DB2FORLUW / A10 - DB2

Error SQL0206N  "SYSIBMINTERNAL_SQLERRM" is not valid in the 
context where it is used.  LINE NUMBER=11.  SQLSTATE=42703  is 
returned when the customer is executing the SQLERRM outside the 
exception block WITHOUT PARAMETERS. 
 
Issue faced on DB2 Galileo 10.1 on Windows 2008 
 
 
Issue can be reproduce by executing the below test case: 
----------------------------------------------- 
 
    CONNECT TO SAMPLE; 
 
SET SQLCOMPAT PLSQL; 
 
-- CREATE OR REPLACE PROCEDURE list_emp 
-- is 
DECLARE 
  v_ErrorText varchar(2048); 
  v_deptname varchar(100); 
-- SYSIBMINTERNAL_SQLERRM  VARCHAR(500); 
BEGIN 
 
     select deptname into v_deptname from org fetch first 1 row 
only; 
 
-- EXCEPTION 
--    WHEN NO_DATA_FOUND THEN 
        DBMS_OUTPUT.PUT_LINE(SQLERRM); 
 
END; 
/ 
 
----------------------------------------------------

**************************************************************** 
* USERS AFFECTED:                                              * 
* All user on Galileo version                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* NA                                                           * 
****************************************************************

DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

not known / see Local fix

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

26.07.2012
31.10.2012
31.10.2012