DB2 FOR LUW / DB2FORLUW / 970 - DB2

if you have LANG set to a locale that uses a character other 
than '.' as the decimal point, the decimal values returned by a 
stored procedure are incorrect. 
 
example : 
 
more repro.sql : 
 
create table t1  (c1 real); 
insert into t1 values (1) 
; 
 
 
CREATE PROCEDURE sp1 ( IN stmt1 VARCHAR(4000) ) 
    SPECIFIC sp1 
    RESULT SETS 1 
    LANGUAGE SQL 
P1: BEGIN 
    DECLARE c1 CURSOR WITH RETURN FOR s1 
    PREPARE s1 FROM stmt1 
    OPEN c1 
END P1 
; 
call sp1('select * from t1'); 
select * from t1; 
 
 
export LANG=fr_FR.ISO8859-1 
db2start 
db2 create database sample 
 
db2 -tvf sp1.sql 
.... 
call sp1('select * from sp1_t1') 
 
 
  Ensemble de rﾂsultats 1 
  -------------- 
 
  C_REAL 
  ------------------------ 
             +0,00000E+000 
 
  1 enregistrement(s) sﾂlectionnﾂ(s). 
 
  Etat du retour = 0 
 
select * from sp1_t1 
 
C_REAL 
------------------------ 
           +1,00000E+000 
 
  1 enregistrement(s) sﾂlectionnﾂ(s). 
 
The same problem could also be seen if a stored procedure has 
output parameters of type Real. 
e.g: 
db2 "create table sp3_t1(c_real real)"; 
db2 "insert into sp3_t1 values(3.787878)" 
db2 "CREATE PROCEDURE sp3 (  out outcol real ) 
            SPECIFIC sp3 
            RESULT SETS 1 
            LANGUAGE SQL 
 
        P1: BEGIN 
            Select c_real into outcol from sp3_t1;-- 
        END P1" 
 
 
db2 "call sp3(?)" 
 
  Value of output parameters 
  -------------------------- 
  Parameter Name  : OUTCOL 
  Parameter Value : +0,00000E+000 
 
  Return Status = 0 
 
db2 "select * from sp3_t1" 
 
C_REAL 
------------------------ 
           +3,78788E+000 
 
  1 record(s) selected.

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 FP8                                       * 
****************************************************************

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 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

The problem is first fixed in DB2 9.7 FP8

not known / see Local fix

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

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

27.11.2012
02.05.2013
02.05.2013

9.7.FP8