suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT19653 Status: Closed

PROBLEM WITH THE GENERATED C/C++ CODE FROM THE DB2 PREP. IT CANNOT COMPILE
WHEN IT CONTAINS THE ARRAY INSERT/UPDATE.

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
Problem with the generated C/C++ code from the db2 prep command. 
It cannot compile the generated code. 
 
There seems to be a difference between the FETCH and the 
UPDATE/DELETE/INSERT. 
FETCH generates the proper code, but  UPDATE uses the invalid 
variable, will get the following compilation error. 
 
: error: '__sqla_loop_itr' was not declared in this scope 
 
 
If we remove the indicator from the UPDATE statement, it is 
generating the code correctly and compiling successfully. 
Problem is only when we use indicator along with variable in 
UPDATE statement.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 10.5 Fix Pack 9 or higher                     * 
****************************************************************
Local Fix:
If we remove the indicator from the UPDATE statement, it is 
generating the code correctly and compiling successfully. 
Problem is only when we use indicator along with variable in 
UPDATE statement.
Solution
First fixed in Db2 10.5 Fix Pack 9
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
10.03.2017
29.09.2017
29.09.2017
Problem solved at the following versions (IBM BugInfos)
9.0.
Problem solved according to the fixlist(s) of the following version(s)