ODXSQL

! (Exclamation Point)

Execute a system command

. (Period)

Re-Execute the last command

;(Semi-Colon)

Comment line

ABORT

Cause software abort

ASSIGNVALUES

* Assign values for a $VALUES clause

ATTACH

* Attach an OST file as a table

BENCHMARK

Perform performance benchmarks

BIND

Bind a SELECT statement

CALC

Perform basic calculator functions

CD

Change directories

CLOSE CURSOR

* Close a cursor

COMMAND

* Execute a shell command via $COMMAND table

CONNECT

* Connect to an environment file

CONVERT

Export a file with data conversions

COPY

Copy a fileset

CREATE DIRECTORY

Create a directory

CREATE FILE

Create a file

CREATE TABLE

* Create a table

DATE

Show the current date and time

DELETE

* Issue an SQL delete statement

DELETEINDEX

* Delete values directly from Omnidex indexes

DESCRIBE

Describe a SELECT statement

DETACH

* Detach a previously attached OST file

DIR

Display a directory of files

DISCONNECT

* Disconnect from an environment file

DROP

* Drop a table

DUMP

Dump files, memory or caches

EDIT

Edit a previous command or file

ERROR

Display an error message

EVAL

Evaluate a condition

EXECDB

Execute statement through oaexecdb()

EXIT

Exit Omnidex SQL

EXPLAIN

Explain approach to retrieval

EXPORT

* Export records to a file

EXTRACT

Extract SQL statements from database

FETCH

Explicitly fetch data from a database

FETCHKEYS

Explicitly fetch keys from the indexes

FLIP

Flip data from one endian to another

FOR

Form a 'FOR n ... END' construct

FORMAT

Format a file of ODXSQL statements

GETENV

Display an environment variable

HELP

Help

HISTORY

Show history of ODXSQL commands

IF

Form an 'IF ELIF ELSE ENDIF' construct

INSERT

* Issue an SQL insert statement

INSERTINDEX

* Insert values directly into Omnidex indexes

IS

Check database conditions

JOIN

* Join tables using Omnidex

LOAD

Load indexes for TDF files

OPEN CURSOR

* Open a cursor

OXKERNEL

Execute an Omnidex kernel command

PARSE

Parse a statement

PARTITION

Partition a table

PWD

Print current working directory

QUALIFY

* Qualify rows using Omnidex

QUIT

Quit Omnidex SQL

REMOVE

Remove one or more files

RENAME

Rename a fileset

RESET HISTORY

Reset history of ODXSQL commands

RESET TIMER

Reset the cumulative timer

RESTORE SETTINGS

Restore settings, optionally from a file

SAVE HISTORY

Save commands to file

SAVE SETTINGS

Save settings, optionally to a file

SELECT

* Issue an SQL select statement

SET

Set an option

SETENV

Set an environment variable

SHOW

Describe an object

SIGNAL

Send a signal to a process

SORTMERGE

Sort/merge test system

UPDATE

* Issue an SQL UPDATE statement

UPDATE STATISTICS

Update statistics for a database or table

UPDATE TEXT

Enable misspelling searches on MDK indexed columns.

UPDATEINDEX

* Update values directly in Omnidex indexes

USE

Execute a file of ODXSQL commands

VALIDATE

Validate an environment

VERSION

* Display current software version information

VIEW

View a text file

n

Execute numbered command

n:

Send command to ODXSQL subprocess