|
Problem IC61719
|
Status: Closed |
DRDA: MONEY TYPES < 0.5 ARE SET TO 0 WHEN USED AS HOST VARIABLESFOR SELECT, UPDATE, DELETE |
| product: |
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50 |
| Problem description: |
The value of host variables assigned to MONEY types are set to 0
for SELECT, UPDATE and DELETE statements. It works for INSERT.
Checking statement history shows that the type for money values
< 0.5 is "money", the type for values >= 5 is "decimal".
Example for c1=0.4
Database: mydb
Statement text:
update instab set c1=? where id=1
UPDATE using tables [ instab ]
Iterator/Explain
================
ID Left Right Est Cost Est Rows Num Rows Partnum
Type
1 0 0 2 1 1
2097219 Seq Scan
Host Variables
==============
0 money $0.00 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users using money datatype through DRDA *
****************************************************************
* PROBLEM DESCRIPTION: *
* Money types are not converted properly during assignment of *
* data to host variables through DRDA *
****************************************************************
* RECOMMENDATION: *
* Upgrade to IDS 11.10.xC4 when available or IDS 11.50.xC5 and *
* above. *
**************************************************************** |
| Local Fix: |
|
| Solution |
The problem has been fixed in IDS 11.10.xC4 and IDS 11.50.xC5.
Now the fractional parts will not be lost in DRDA with money
datatypes. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.06.2009
22.01.2010
22.01.2010 |
| Problem solved at the following versions (IBM BugInfos) |
11.10.xC4,
11.50.xC5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 11.50.xC5
|
 |
