This is an old revision of the document!
The OdxSQL EXTRACT Command will Extract DDL statements (CREATE ENVIRONMENT, CREATE DATABASE, CREATE TABLE, CREATE INDEX and CREATE INDEX GROUP) or INSERT statements to a file. The extracted file can the be modified with an editor and used to build another Omnidex Environment.
EXTRACT DDL [FOR <ENVIRONMENT [environment] | DATABASE database>] [TO filespec] [ON [INSTANCE] instance] [WITH options] EXTRACT [CLUSTERED] <INSERTS | UPDATES | DELETE_WHERES | DELETE_EXCEPTS> FROM tables [WHERE criteria] [TO filename] [ON [INSTANCE] instance] [WITH options] (Note: CLUSTERED requires tables to be one parent and any linked children)