IC79050: INCORRECT BEHAVIOR WITH EXTERNAL TABLE WHEN STRING CANNOT BE FULLY CONVERTED INTO AN INTEGER, ERROR 1213 SHOULD BE THROWN

APAR status

• Closed as program error.

Error description

• The following incorrect behavior has been observed:
  
  CREATE EXTERNAL TABLE EXT_INT_TEST
  (col1 int)
  USING ( DATAFILES ('DISK:./ext_int.txt'),
  DBDATE 'DMY4.', DBMONEY '.',
  FORMAT 'delimited', DELUXE, DELIMITER '|');
  
  File "./ext_int.txt" contains:
  212ggg|
  
  
  $ echo 'select * from ext_int_test;' | dbaccess test
  
  Database selected.
  
         col1
  
          212
  
  1 row(s) retrieved.
  
  Database closed.
  
  The string value from the file simply truncated instead of error
  1213.
  Loading the same data into a normal table returns error 1213 as
  expected.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IDS 11.70xC1 and later on all platforms                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * IDS would incorrectly convert an invalid string in an        *
  * External Table into an integer without throwing out an       *
  * error.                                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to product JDBC Version 3.50JC10                     *
  *                                                              *
  * For download information, go to:                             *
  * http://www.ibm.com/support/fixcentral                        *
  ****************************************************************
  

Problem conclusion

• With the fix in 11.70xC5, conversion to an integer value from an
  external Table would behave as expected as per IDS docs.
  

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

• RB70 PSN

     UP