IT33524: TRUNCATED VALUES INSIDE STORED PROCEDURE USING NLV()

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 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