home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IC61334 Status: Closed

LITERAL NUMBERS FOR MONEY TYPES ARE CONVERTED TO QUOTED STRINGS IN VIEW
DEFINITIONS

product:
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50
Problem description:
Literal numbers for MONEY types are converted to quoted strings 
in view definitions dependent on the DBMONEY settings. 
 
This means such a view can only be used with the same DBMONEY 
setting as during creation. 
 
Literal numbers and quoted strings used with DECIMAL types are 
always converted to decimal values. MONEY types should be 
handled the same way.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* IDS.11.10.xC3 / IDS.11.50.xC4 and below versions of the      * 
* product                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Definitions in the catalogs (eg. View definitions) for the   * 
* money data type store values as strings, incorporating the   * 
* DBMONEY (locale) setting at the time of creation.            * 
* Consequently, only DBMONEY settings matching that at the     * 
* time of view creation can correctly execute the view.        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to IDS version 11.10.xC4 and above.                  * 
* Upgrade to IDS version 11.50.xC5 and above.                  * 
****************************************************************
Local Fix:
Solution
Problem first fixed in IDS 11.10.xC4 and IDS 11.50.xC5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
02.06.2009
19.01.2010
19.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.xC4.W1 FixList
11.50.xC5 FixList