Download IBM Informix Migration Guide
Transcript
and when it reproduces any unique, referential, or check constraint. As a result, if you use the dbschema output to create a new object (table, index, view, procedure, constraint, sequence, or synonym), the owner of the original object owns the new object. If you want to change the owner of the new object, you must edit the dbschema output before you run it as an SQL script. You can use the output of dbschema to create a new function if you also specify the path name to a file in which compile-time warnings are stored. This path name is displayed in the dbschema output. For more information about the CREATE TABLE, CREATE INDEX, CREATE SYNONYM, CREATE VIEW, CREATE SEQUENCE, CREATE PROCEDURE, CREATE FUNCTION, and GRANT statements, see the IBM Informix Guide to SQL: Syntax. dbschema server-specific information The dbschema -ss option generates server-specific information. In all Informix database servers except SE, the -ss option always generates the lock mode, extent sizes, and the dbspace name if the dbspace name is different from the database dbspace. In addition, if tables are fragmented, the -ss option displays information about the fragmentation strategy. When you specify the dbschema -ss option, the output also displays any GRANT FRAGMENT statements that are issued for a particular user or in the entire schema. The -si option, which is available only with the -ss option, excludes the generation of index storage clauses for non-fragmented tables. If the dbspace contains multiple partitions, dbspace partition names appear in the output. For information about fragment-level authority, see the GRANT FRAGMENT and REVOKE FRAGMENT statements in the IBM Informix Guide to SQL: Syntax. User-defined and complex data types The dbschema -u option displays the definitions of any user-defined and complex data types that the database contains. The suboption i adds the type inheritance to the information that the dbschema -u option displays. The following command displays all the user-defined and complex data types for the stork database: dbschema -d stork -u all Output from dbschema that ran with the specified option -u all might appear as the following example shows: create row type ’informix’.person_t ( name varchar(30, 10) not null, address varchar(20, 10), city varchar(20, 10), state char(2), zip integer, bdate date ); create row type ’informix’.employee_t 11-6 IBM Informix Migration Guide