This is an old revision of the document!
Overview | Commands | Options | Command-line | Command Files
The following commands are available in OdxSQL:
Attach a database
ATTACH DATABASE database [AS alias] FROM filename [ON [INSTANCE] instance] [WITH options]
Attach a segment
ATTACH <INDEX | DATA> SEGMENT segment [PHYSICAL physical] [ON [INSTANCE] instance] [WITH options]
Attach a table
ATTACH TABLE table [PHYSICAL "physical"] (column [, column ...]) [ON [INSTANCE] instance>] [WITH options] column: column-name datatype (length)
Perform performance benchmarks
BENCHMARK [<table | select-statement>] [WITH options]
Perform basic calculator functions
CALC expression
Change directories
CD [path]
Close a cursor
CLOSE CURSOR [[ON] CURSOR] cursor] [WITH options]
Connect to an environment file
CONNECT [TO] connection_string [USING api] [WITH options] Connection string syntax: [ host:port:pool ] filename [ node ] &options Examples: CONNECT example.xml CONNECT [server1:7555]example.xml CONNECT [server1:7555:pool1]
Export a file with data conversions
CONVERT [statement TO filename [ON [CURSOR] cursor] [WITH options]
Create a database
CREATE DATABASE database node [node ...] IN "filename" [WITH options]
Create an environment file
CREATE ENVIRONMENT environment [attribute [attribute ...]]
Create an index or index group
CREATE <OMNIDEX | QUICKTEXT | FULLTEXT | CUSTOM | NATIVE> INDEX [[(owner)]table.]index [ON table] (<column | substring> [, <column | substring> ...])] [attribute [attribute ...]] IN "filename" [WITH options] CREATE INDEX GROUP [(owner)]group (table.index [, table.index ...])] IN "filename" [WITH options]
Create a segment
CREATE [<TEMPORARY | PERMANENT>] <INDEX | DATA> SEGMENT segment [PHYSICAL physical] [AS (select)] [ON [CURSOR] cursor] [WITH options]
Create a table
CREATE [<[<GLOBAL | LOCAL>] TEMPORARY | PERMANENT>] TABLE table [PHYSICAL "physical"] (column [, column ...]) [<IN "filename" | ON [INSTANCE] instance>] [WITH options] column: column-name datatype (length)
Show the current date and time
DATE
Show the current date and time
DATE
See also: