|
n: |
Send command to ODXSQL subprocess |
|
ABORT |
Terminate ODXSQL with an error condition. |
|
ASSIGNVALUES |
* Assign buffer values as select criteria in a $VALUES
clause |
|
ATTACH |
* Attach an OST file. |
|
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
TABLE |
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 ODXSQL |
|
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 |
Get 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 table using Omnidex |
|
LOAD |
Load inexes 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 ODXSQL |
|
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 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 |
|
UPDATEINDEX |
* Update values directly in Omnidex indexes |
|
USE |
Execute a file of ODXSQL commands |
|
VALIDATE |
Validate an environment |
|
VERSION |
* Display current software versions |
|
VIEW |
View a text file |
