Previous Topic Next topic Print topic


SQL_OPTS

Restriction: This topic applies to Windows environments only.

Used to specify which SQL statements should be generated when the SQL export type is chosen. The syntax is:

SQL_OPTS = statement-type [, statement-type, ...];

where statement-type is one of the types shown in the table below.

Statement type SQL Statement
CREATE CREATE TABLE and CREATE VIEW commands
INSERT INSERT INTO commands
INDEX CREATE INDEX commands
SYNONYM CREATE SYNONYM commands
CHECK ALTER TABLE ... CHECK commands
COMMENT COMMENT ON commands

For example:

SQL_OPTS = CREATE, INDEX;

selects CREATE TABLE, CREATE VIEW, and CREATE INDEX SQL commands for use in the target file.

Previous Topic Next topic Print topic