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 | |
11.50.xC5 |