Output from the dbschema Utility

The dbschema utility of Extended Parallel Server can display the SQL statements that are necessary to replicate a specified table, view, or database. It also can also display the distributions that the UPDATE STATISTICS statement creates for tables.

The version of dbschema that is provided with XPS 8.51 supports in its output the new 'DB2' data format and long record delimiters of the CREATE EXTERNAL TABLE statement. The following example shows output from dbschema for a table that stores records in DB2 format and that uses 13-byte record delimiters:

DBSCHEMA Schema Utility       IBM INFORMIX-SQL Version 8.51.FC1
(C) Copyright IBM Corp. 1984, 2006
Software Serial Number RDS#N000000
create external table "informix".ext4 
  (
    col1 integer,
    col2 char(1),
    col3 integer,
    col4 char(10)
  ) 
using 
  (
    datafiles 
      (
        "disk:1:/usr2/xps/dev/8.51.N665/ext4.tab"
),
    format "db2",
    recordend "does this work",
    DELIMITER ","
  );
revoke all on "informix".ext4 from "public";

For information about additional changes that Version 8.51 of Extended Parallel Server introduces to the syntax of SQL statements and to the syntax or to the output displays of administrative utilities, see Summary of User Interface Enhancements.