IT32397: DBSCHEMA DOES NOT OUTPUT NOT NULL PHRASE ON EXTERNAL TABLES.

APAR status

• Closed as program error.

Error description

• Consider the dbschema output for the external table below:
  
  create table test(i integer not null,j integer);
  insert into test values(1,1);
  insert into test values(2,2);
  insert into test values(3,3);
  CREATE EXTERNAL TABLE ec_test (i integer not null,j integer)
  using ( datafiles ("DISK:/tmp/ec_test.unl")) ;
  insert into ec_test select * from test;
  
  The dbaccess tool indicates the column is not null:
  
  Column name         Type                                   Nulls
  i                   integer                                no
  j                   integer                                yes
  
  
  But dbschema does not:
  
  dbschema -d TS003496979 -t ec_test
  DBSCHEMA Schema Utility      INFORMIX-SQL Version 14.10.FC3
  { TABLE "informix".ec_test row size = 8 number of columns = 2
  create external table "informix".ec_test
   (
     i integer,
     j integer
   )
  using
   (
     datafiles
       (
         "DISK:/tmp/ec_test.unl"
       ),
     format "delimited",
     escape on
   );
  revoke all on "informix".ec_test from "public" as "informix";
  
  Even though "not null" was used while creating the external
  table, the dbschema output above omits it.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 11.70.xC9W2, 12.10.xC15    *
  * and 14.10.xC5.                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 11.70.xC9W2, 12.10.xC15 (when     *
  * available) or 14.10.xC5.                                     *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 11.70.xC9W2, 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