DB2 FOR LUW / DB2FORLUW / A10 - 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:                                              * 
* All Db2 Users who uses CLP                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2_v101fp3 or later                              * 
****************************************************************

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
 

Problem fixed in db2_v101fp3

not known / see Local fix

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

22.04.2013
26.10.2013
26.10.2013