APAR status
Closed as program error.
Error description
Procedure should return same values in both arguments but it truncates the second return value: DROP PROCEDURE IF EXISTS test_pr1; CREATE PROCEDURE test_pr1 () RETURNING VARCHAR(255), VARCHAR(255); DEFINE init_str VARCHAR(255) ; DEFINE v_var CHAR(1); LET init_str = '3000.0 in int the value of my card 221) ' ; LET v_var = 'N'; RETURN 'Insufficient Balance' || trim(init_str), NVL ( DECODE (v_var, 'Y', v_var, null), 'Insufficient Balance' || trim(init_str) ); END PROCEDURE; UPDATE STATISTICS FOR PROCEDURE test_pr1; ================================================ echo "EXECUTE PROCEDURE test_pr1();"|dbaccess stores_demo Database selected. (expression) Insufficient Balance3000.0 in int the value of my card 221) (expression) Insufficient Balance3000.0 in int the va 1 row(s) retrieved. Database closed. CREATE PROCEDURE test_ffo () RETURNING VARCHAR(255), VARCHAR(255); DEFINE init_str VARCHAR(255) ; DEFINE v_var CHAR(1); LET init_str = 'NVL TEST OUT OF THE PROCEDURE' ; LET v_var = 'N'; RETURN 'Address unknown' || trim(init_str), NVL (DECODE (v_var, 'Y', v_var, null), 'Address unknown' || trim(init_str)); END PROCEDURE; UPDATE STATISTICS FOR PROCEDURE test_ffo; (expression) Address unknownNVL TEST INSIDE THE PROCEDURE (expression) Address unknownNVL TEST INSIDE THE PROCE
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC5. * ****************************************************************
Problem conclusion
Fixed in Informix Server 12.10.xC15 and 14.10.xC5.
Temporary fix
Comments
APAR Information
APAR number
IT33524
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
E10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-07-13
Closed date
2020-12-07
Last modified date
2020-12-07
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10"}]
Document Information
Modified date:
08 December 2020