IT17535: INSERT OF BSON DATA INTO EXTERNAL TABLE DOES NOT WORK

APAR status

• Closed as program error.

Error description

• If you try to unload BSON data with the help of an external
  table, the file created won't contain the BSON data.
  
  Example:
  
  CREATE COLLECTION TABLE tab
    (
      aty_no      SERIAL NOT NULL PRIMARY KEY,
      data        BSON
    );
  
  INSERT INTO tab  VALUES (1,
  '{ "id":1,"value":"unknown","de":{"name":"unbekannt",
  "short_name":"unb"},"en":{"name":"unknown", "short_name":"unk"}
  }'
  ::JSON);
  
  CREATE EXTERNAL TABLE tab_ext (
      aty_no      SERIAL,
      data        BSON
  ) USING ( FORMAT 'DELIMITED',  DATAFILES ("DISK:<file>") );
  INSERT INTO tab_ext SELECT * FROM tab;
  
  <file> contains
  
  1|0x80|
  
  but not the BSON data.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Informix user with BSON in external table                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC8                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC8
  

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

• RA10 PSY

     UP