|
Problem IT32397
|
Status: Closed |
DBSCHEMA DOES NOT OUTPUT NOT NULL PHRASE ON EXTERNAL TABLES.
|
| product: |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 |
| Problem 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. |
| 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. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* 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. *
**************************************************************** |
| Comment |
Fixed in Informix Server 11.70.xC9W2, 12.10.xC15 and 14.10.xC5. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.04.2020
15.12.2020
15.12.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
