DB2 FOR LUW / DB2FORLUW / 970 - DB2

When trying to create a COBOL routine SQL0451 is returned for 
the column defined as the DECIMAL data type. 
 
 
Example: 
========= 
 
 
create procedure DB2INST1.TESTSP ( 
 in    in_parm1            char(8), 
 in    in_parm2            char(8), 
 in    in_parm3            decimal(1,0), 
) 
       external name 'TESTSP' 
       language cobol 
       PARAMETER STYLE GENERAL WITH NULLS 
       modifies sql data 
 
Output: 
========= 
 
 
DB21034E  The command was processed as an SQL statement because 
it was not a valid Command Line Processor command.  During SQL 
processing it returned: 
 
SQL0451N  The "PARAMETER #3" definition, in the statement that 
defines routine "DB2INST1.TESTSP", contains a data type 
"DECIMAL" that is not appropriate for a non-sourced routine 
written in the given language.  LINE NUMBER=4. 
SQLSTATE=42815 
 
 
However the routine can be created in DB2 v8.x and DB2 v9.1 
without any problems.

Users affected: All 
Problem Description: See above 
Problem Summary: See above

Change DECIMAL data type to FLOAT type

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
 

First fixed in next release

N/A

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

22.02.2010
17.03.2010
20.08.2010