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

Issue an SQL delete statement

DELETE FROM table [WHERE < predicate-list | CURRENT>
  [<ON | OF> [CURSOR] cursor]] [WITH options]

Detach a previously attached database

DETACH DATABASE database [ON [INSTANCE] instance] [WITH options]

Detach a previously attached segment

DETACH SEGMENT segment [ON [INSTANCE] instance] [WITH options]

Detach a previously attached table

DETACH TABLE table [ON [INSTANCE] instance] [WITH options]

Display a directory of files

DIR fileset [WITH options]

Disconnect from an environment file

DISCONNECT [ALL] [[ON [INSTANCE]] instance] [WITH options]

Drop a database

DROP DATABASE [IF EXISTS] database IN "filename" [WITH options]

Drop an environment

DROP ENVIRONMENT [IF EXISTS] [environment] IN "filename" [WITH options]

Drop an index or index group

DROP [<OMNIDEX | NATIVE>] INDEX [IF EXISTS] [[(owner)]table.]index [ON table]
  IN "filename" [WITH options]

DROP INDEX GROUP [IF EXISTS] [(owner)]group IN "filename" [WITH options]

Drop a segment

DROP SEGMENT [IF EXISTS] segment [ON [INSTANCE] instance>] [WITH options]

Drop a table

DROP [<TEMPORARY | PERMANENT>] TABLE [IF EXISTS] table 
  [<IN "filename" | ON [INSTANCE] instance>] [WITH options]

Prev | Next |

See also: