Informix - Problem description
Problem IT31106 | Status: Closed |
It should not be possible to drop a row type that is being referenced in a stored procedure. | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The database server does not check for dependent stored procedures while dropping a row type and will allow the row type to be dropped. A subsequent run of that SPL will fail with a relevant error when the row type is encountered. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC4 (when * * available). * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC4 (when * * available). * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC14 and 14.10.xC4. However, the fix is disabled by default. To enable the fix: 1) query current server SQL_DEF_CTRL value > select * from sysmaster:sysconfig where cf_name='SQL_DEF_CTRL'; cf_id 262 cf_name SQL_DEF_CTRL cf_flags 50368576 cf_original cf_effective 0x44004b0 cf_default 0x44004b0 2) turn on bit 0x8000000; in this case that would be 0xc4004b0, then set it with onmode: onmode -wm SQL_DEF_CTRL=0xc4004b0 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.11.2019 28.02.2020 28.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14, 14.10.xC4 | |
Problem solved according to the fixlist(s) of the following version(s) |