Show pagesource

Old revisions

This is an old revision of the document!

Programs: OdxSQL

Overview | Commands | Options | Command-line | Command Files

Commands

The following commands are available in OdxSQL:

ATTACH DATABASE

Attach a database

ATTACH DATABASE database [AS alias] FROM filename [ON [INSTANCE] instance]
  [WITH options]

ATTACH SEGMENT

Attach a segment

ATTACH <INDEX | DATA> SEGMENT segment [PHYSICAL physical]
  [ON [INSTANCE] instance] [WITH options]

ATTACH TABLE

Attach a table

ATTACH TABLE table [PHYSICAL "physical"] (column [, column ...])
  [ON [INSTANCE] instance>] [WITH options]
  column: column-name datatype (length)

BENCHMARK

Perform performance benchmarks

BENCHMARK [<table | select-statement>] [WITH options]

CALC

Perform basic calculator functions

CALC expression

CD

Change directories

CD [path]

CLOSE CURSOR

Close a cursor

CLOSE CURSOR [[ON] CURSOR] cursor] [WITH options]

CONNECT

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]

CONVERT

Export a file with data conversions

CONVERT [statement TO filename [ON [CURSOR] cursor] [WITH options]

CREATE DATABASE

Create a database

CREATE DATABASE database node [node ...] IN "filename" [WITH options]

CREATE ENVIRONMENT

Create an environment file

CREATE ENVIRONMENT environment [attribute [attribute ...]]

CREATE INDEX

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 SEGMENT

Create a segment

CREATE [<TEMPORARY | PERMANENT>] <INDEX | DATA> SEGMENT segment
  [PHYSICAL physical] [AS (select)] [ON [CURSOR] cursor]
  [WITH options]

CREATE TABLE

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)

column: column-name datatype (length)

Prev | Next |