Show page
Old revisions

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
programs:odxsql:commands:home [2009/12/02 17:15]
tdo 		programs:odxsql:commands:home [2016/06/28 22:38] (current)
Line 3: Line 3:
 ~~NOTOC~~ ~~NOTOC~~
 ====== OdxSQL Commands and Omnidex SQL Statements ====== ====== OdxSQL Commands and Omnidex SQL Statements ======
-^[[programs:odxsql:​overview|OdxSQL Overview]]^ [[programs:​odxsql:​commands:​home|OdxSQL Commands]] ^OdxSQL Settings^OdxSQL Scripts^SQL SELECT^ Omnidex SQL ^ +{{page>:odxsql_bar&​nofooter&​noeditbtn}}
-===== Overview =====+
  
-OdxSQL ​is used to process a wide range of Omnidex SQL Statements ​and OdxSQL specific commands.+OdxSQL ​processes ​Omnidex SQL statements ​and OdxSQL specific commands ​either interactively or in batch oriented script files via the USE command. 
  
-The OdxSQL Commands and Omnidex SQL Statements ​are organized ​for quick review as follows:+The following is a list of Omnidex SQL Statements ​and OdxSQL commands ​organized ​by type with a complete alphabetic list shown below.
  
-  * [[#Connecting and Disconnecting ​| Connecting and Disconnecting ]] +===== Connecting and Disconnecting ​=====
-  * [[#Omnidex SQL Data Definition Language (DDL) Statements | Omnidex SQL Data Definition Language (DDL) Statements ]] +
-  * [[#Omnidex SQL Data Manipulation Language (DML) Statements | Omnidex SQL Data Manipulation Language (DML) Statements | +
-  * [[#Omnidex Environment Operation Commands | Omnidex Environment Operation Commands | +
-  * [[#OdxSQl and Omnidex SQL Data Export and Manipulation | OdxSQl and Omnidex SQL Data Export and Manipulation | +
-  * [[#OdxSQL Program Operation Commands | OdxSQL Program Operation Commands ]] +
-  * [[#OdxSQL Testing and Performance Commands | OdxSQL Testing and Performance Commands | +
-  * [[#OdxSQL Operating System Commands | OdxSQL Operating System Commands | +
-  * [[#Omnidex Index Direct Maintenance Routines | Omnidex Index Direct Maintenance Routines | +
-  * [[#​Alphabetical List of OdxSQL Commands and Omnidex SQL Statements | Alphabetical List of OdxSQL Commands and Omnidex SQL Statements |+
  
-OdxSQL ​Commands and Omnidex ​SQL Statements can be entered into OdxSQL in ether upper or lower case. +OdxSQL ​works by first connecting to an Omnidex ​Environment ​or an ODBC or JDBC DataSource (DSN) that references an Omnidex ​Environment on a remote server.  ​Although ​ODBC and JDBC applications use a connection call or object, OdxSQL uses Connect and Disconnect commands.
- +
-  > connect myenv +
- +
-  > CONNECT myenv +
- +
-The syntax for Omnidex SQL Statements entered into OdxSQL or processed in a script file is typically the exact same syntax and returns the exact same results. +
- +
-There are a few exceptions such as CONNECT and VERSION. +
- +
-In OdxSQL, CONNECT has the additional options of ON host:port and USING api that would not make sense in an ODBC or JDBC application. ​  +
- +
-In OdxSQL, the VERSION command displays the OdxSQL header and multiple lines of version information where the Omnidex ​SQL VERSION statement returns ​a single line. +
- +
-The OdxSQL EXECSQL command can be used to verify if an Omnidex SQL Statement is processed exactly the same by OdxSQL as the Omnidex SQL parser. +
- +
-<​code>​ +
-> VERSION +
-ODXSQL - Omnidex SQL                                   Wed Dec 02 09:20:41 200 +
-... +
-Omnidex Version ​                 5.0 Build 2B +
-Compilation Timestamp ​           Oct 13 2009  08:57:09 +
-Earliest Compatible ​ODBC Client ​ 4.3 Build 4B +
-Earliest Compatible ​JDBC Client ​ 4.3 Build 4B +
-Earliest Compatible Odx Kernel ​  5.0 Build 1B +
- +
-> EXECSQL VERSION +
-OmniAccess version 50002 +
->  +
-</​code>​ +
- +
-===== Connecting and Disconnecting =====+
  
 +^ Statement ^  Description ​ ^
 | [[programs:​odxsql:​commands:​connect|CONNECT]] | Connect to an Omnidex Environment or ODBC/JDBC Datasource File (DSN). | | [[programs:​odxsql:​commands:​connect|CONNECT]] | Connect to an Omnidex Environment or ODBC/JDBC Datasource File (DSN). |
 | [[programs:​odxsql:​commands:​disconnect|DISCONNECT]] | Disconnect from a previously Connected Omnidex Environment or ODBC or JDBC Datasource (DSN). | | [[programs:​odxsql:​commands:​disconnect|DISCONNECT]] | Disconnect from a previously Connected Omnidex Environment or ODBC or JDBC Datasource (DSN). |
Line 59: Line 19:
 | [[programs:​odxsql:​commands:​detach|DETACH]] | Detach a previously attached Omnidex Standalone Table (OST) file. | | [[programs:​odxsql:​commands:​detach|DETACH]] | Detach a previously attached Omnidex Standalone Table (OST) file. |
  
 +===== Omnidex SQL Data Manipulation Language (DML) Statements =====
 +
 +OdxSQL can process all Omnidex SQL Data Manipulation Statements (SELECT, INSERT, UPDATE, and DELETE) as well as lower level Omnidex SQL routines.
 +
 +^ DML Statement ^  Description ​ ^
 +| [[dev:​sql:​statements:​select:​home |SELECT]] | Issue an Omnidex SQL SELECT Statement. |
 +| [[dev:​sql:​statements:​insert:​home |INSERT]] | Issue an Omnidex SQL INSERT Statement. |
 +| [[dev:​sql:​statements:​update:​home |UPDATE]] | Issue an Omnidex SQL UPDATE Statement. |
 +| [[dev:​sql:​statements:​delete:​home | DELETE]] | Issue the SQL DELETE Statement. |
 ===== Omnidex SQL Data Definition Language (DDL) Statements ===== ===== Omnidex SQL Data Definition Language (DDL) Statements =====
 ^ DDL Statement ^  Description ​ ^ ^ DDL Statement ^  Description ​ ^
Line 65: Line 34:
 | [[programs:​odxsql:​commands:​create_table|CREATE TABLE]] | Create a Table. | | [[programs:​odxsql:​commands:​create_table|CREATE TABLE]] | Create a Table. |
 | [[programs:​odxsql:​commands:​create_index|CREATE INDEX]] | Create Index | | [[programs:​odxsql:​commands:​create_index|CREATE INDEX]] | Create Index |
 +| [[programs:​odxsql:​commands:​create_index|CREATE INDEX GROUP ]] | Create Index Group |
 | [[programs:​odxsql:​commands:​create_indexes|CREATE INDEXES]] | Create Omnidex Indexes. | | [[programs:​odxsql:​commands:​create_indexes|CREATE INDEXES]] | Create Omnidex Indexes. |
 | [[programs:​odxsql:​commands:​drop_environment|DROP ENVIRONMENT]] | Drop Environment. | | [[programs:​odxsql:​commands:​drop_environment|DROP ENVIRONMENT]] | Drop Environment. |
Line 71: Line 41:
 | [[programs:​odxsql:​commands:​drop_index|DROP INDEX]] | Drop Index. | | [[programs:​odxsql:​commands:​drop_index|DROP INDEX]] | Drop Index. |
 | [[programs:​odxsql:​commands:​drop_indexes|DROP INDEXES]] | Drop Indexes. | | [[programs:​odxsql:​commands:​drop_indexes|DROP INDEXES]] | Drop Indexes. |
 +| [[programs:​odxsql:​commands:​show_ddl|SHOW DDL]] | Show Data Definition Statements. |
  
-===== Omnidex SQL Data Manipulation Language (DML) Statements =====+===== Additional ​Omnidex SQL DML Statements =====
  
-| [[programs:​odxsql:​commands:​select|SELECT]] | Issue an Omnidex SQL SELECT ​Statement. | +^ DML Statement ​^  Description ​ ^
-| [[programs:​odxsql:​commands:​insert|INSERT]] | Issue an Omnidex SQL INSERT Statement. | +
-| [[programs:​odxsql:​commands:​update|UPDATE]] | Issue an Omnidex SQL UPDATE Statement. | +
-| [[programs:​odxsql:​commands:​delete|DELETE]] | Issue the SQL DELETE Statement. | +
-| [[programs:​odxsql:​commands:​open_cursor|OPEN CURSOR]] | Open a Cursor. | +
-| [[dev:​sql:​assignvalues | ASSIGNVALUES]] | Assign values for a $VALUES clause to be used in a subsequent SELECT. |+
 | [[programs:​odxsql:​commands:​join|JOIN]] | Join tables using Omnidex Indexes. | | [[programs:​odxsql:​commands:​join|JOIN]] | Join tables using Omnidex Indexes. |
 | [[programs:​odxsql:​commands:​qualify|QUALIFY]] | Qualify rows using Omnidex criteria. | | [[programs:​odxsql:​commands:​qualify|QUALIFY]] | Qualify rows using Omnidex criteria. |
-| [[programs:​odxsql:​commands:​describe|DESCRIBE]] | Describe a SELECT Statement. | 
-| [[programs:​odxsql:​commands:​bind|BIND]] | Bind a SELECT Statement. | 
 | [[programs:​odxsql:​commands:​fetch|FETCH]] | Explicitly fetch data from the database. | | [[programs:​odxsql:​commands:​fetch|FETCH]] | Explicitly fetch data from the database. |
 | [[programs:​odxsql:​commands:​fetchkeys|FETCHKEYS]] | Explicitly fetch keys from the Omnidex Indexes. | | [[programs:​odxsql:​commands:​fetchkeys|FETCHKEYS]] | Explicitly fetch keys from the Omnidex Indexes. |
 +| [[programs:​odxsql:​commands:​open_cursor|OPEN CURSOR]] | Open a Cursor. |
 | [[programs:​odxsql:​commands:​close_cursor|CLOSE CURSOR]] | Close a previously opened cursor. | | [[programs:​odxsql:​commands:​close_cursor|CLOSE CURSOR]] | Close a previously opened cursor. |
-===== Omnidex Environment Operation Commands ===== 
  
 +===== Omnidex SQL Operational Statements =====
  
-| [[programs:​odxsql:​commands:​show|SHOW]] | Show Omnidex Environment ​information including Databases, Tables, Column layouts, Query Statistics, etc. | +OdxSQL has commands ​that operate and update information for an Omnidex Environment ​and the individual databases contained in the Omnidex Environment. 
-| [[programs:​odxsql:​commands:​validate|VALIDATE]] | Validate ​the Omnidex Environment's view of the underlying data. |+ 
 +^ Statement ^  Description ​ ^
 | [[programs:​odxsql:​commands:​partition|PARTITION]] | Partition a table into smaller sub tables based on criteria. | | [[programs:​odxsql:​commands:​partition|PARTITION]] | Partition a table into smaller sub tables based on criteria. |
 | [[programs:​odxsql:​commands:​update_rollup|UPDATE ROLLUP]] | Update Rollup Table with summarized information. | | [[programs:​odxsql:​commands:​update_rollup|UPDATE ROLLUP]] | Update Rollup Table with summarized information. |
Line 97: Line 63:
 | [[programs:​odxsql:​commands:​update_statistics|UPDATE STATISTICS]] | Update Statistics Information. | | [[programs:​odxsql:​commands:​update_statistics|UPDATE STATISTICS]] | Update Statistics Information. |
 | [[programs:​odxsql:​commands:​update_text|UPDATE TEXT]] | Update Textual Statistics. | | [[programs:​odxsql:​commands:​update_text|UPDATE TEXT]] | Update Textual Statistics. |
-| [[programs:​odxsql:​commands:​lookup|LOOKUP]] | Lookup Text Metadata and display it. | 
 | [[programs:​odxsql:​commands:​load ofx|LOAD OFX]] | Load Indexes for a table. |  | [[programs:​odxsql:​commands:​load ofx|LOAD OFX]] | Load Indexes for a table. | 
-| [[programs:odxsql:commands:helper|HELPER]] | Access OAHELPER functions for generating Environment Catalogs. |  +| [[dev:sql:statements:sql | SET ]] | Set Omnidex ​SQL Conditions. | 
-| [[programs:​odxsql:​commands:​version|VERSION]] | Display current ​Omnidex ​Software versions. | +===== OdxSQL ​Environment Related Commands ​=====
-===== OdxSQL ​and Omnidex SQL Data Export and Manipulation ​=====+
  
-| [[programs:​odxsql:​commands:partition|PARTITION]] | Partition a table into smaller sub tables based on criteria. |+OdxSQL has commands ​that can be used to export and partition ​data.  These can be used to easily pull data from RDBMS data stores ​into Omnidex Snapshots. 
 + 
 +^ Command ^  Description ​ ^
 | [[programs:​odxsql:​commands:​convert|CONVERT]] | Export a file with data conversion. | | [[programs:​odxsql:​commands:​convert|CONVERT]] | Export a file with data conversion. |
-| [[programs:​odxsql:​commands:​export|EXPORT]] | Export rows to a file. | +| [[programs:​odxsql:​commands:​extract|EXTRACT]] | Extracts SQL Statements from a table and writes them to a file. Removed in 5.1 | 
-| [[programs:​odxsql:​commands:​extract|EXTRACT]] | Extracts SQL Statements from a table and writes them to a file. |+| [[programs:​odxsql:​commands:​show|SHOW]] | Show Omnidex Environment information including Databases, Tables, Column layouts, Query Statistics, etc. | 
 +| [[programs:​odxsql:​commands:​validate|VALIDATE]] | Validate the Omnidex Environment'​s view of the underlying data. Removed in 5.1 | 
 +===== OdxSQL Program Operation Commands =====
  
 +OdxSQL has several commands that facilitate the processing, editing, re-issue of previous commands and processing multiple command blocks.
  
- +^ Command ^  Description ​ ^
-===== OdxSQL Program Operation Commands ===== +
 | [[programs:​odxsql:​commands:​use|USE]] | Read and process a file of OdxSQL Commands and Omnidex SQL Statements, optionally with WHERE criteria. | | [[programs:​odxsql:​commands:​use|USE]] | Read and process a file of OdxSQL Commands and Omnidex SQL Statements, optionally with WHERE criteria. |
 | [[programs:​odxsql:​commands:​period|Redo Command ( . )]] | Execute the last command. | | [[programs:​odxsql:​commands:​period|Redo Command ( . )]] | Execute the last command. |
Line 126: Line 93:
 | [[programs:​odxsql:​commands:​help|HELP]] | Show a list of commands help on individual commands, COMMANDS, SYNTAX and API. | | [[programs:​odxsql:​commands:​help|HELP]] | Show a list of commands help on individual commands, COMMANDS, SYNTAX and API. |
 | [[programs:​odxsql:​commands:​is|IS]] | Check Table Conditions. | | [[programs:​odxsql:​commands:​is|IS]] | Check Table Conditions. |
-| [[programs:​odxsql:​commands:​eval|EVAL]] | Evaluate a condition. | 
 | [[programs:​odxsql:​commands:​date|DATE]] | Show the current Date and Time. | | [[programs:​odxsql:​commands:​date|DATE]] | Show the current Date and Time. |
 | [[programs:​odxsql:​commands:​calc|CALC]] |Perform basic calculator functions. | | [[programs:​odxsql:​commands:​calc|CALC]] |Perform basic calculator functions. |
Line 132: Line 98:
 | [[programs:​odxsql:​commands:​quit|QUIT]] | Quit the OdxSQL program. ​ Same as Exit. | | [[programs:​odxsql:​commands:​quit|QUIT]] | Quit the OdxSQL program. ​ Same as Exit. |
 | Comment ( ; ) | Use a semicolon as the first character of a line for a comment line. | | Comment ( ; ) | Use a semicolon as the first character of a line for a comment line. |
 +| [[programs:​odxsql:​commands:​version|VERSION]] | Display current Omnidex Software versions. |
 ===== OdxSQL Testing and Performance Commands ===== ===== OdxSQL Testing and Performance Commands =====
 +
 +OdxSQL contains several commands that facilitate the testing and optimization of an Omnidex Environment.
 +
 +^ Command ^  Description ​ ^
 | [[programs:​odxsql:​commands:​explain|EXPLAIN]] | Explain the optimization approach to a previous retrieval. | | [[programs:​odxsql:​commands:​explain|EXPLAIN]] | Explain the optimization approach to a previous retrieval. |
-| [[programs:​odxsql:​commands:​validate|VALIDATE]] | Validate the Omnidex Environment'​s view of the underlying data. | 
 | [[programs:​odxsql:​commands:​reset_timer|RESET TIMER]] | Reset the OdxSQL Cummulative Timer. | | [[programs:​odxsql:​commands:​reset_timer|RESET TIMER]] | Reset the OdxSQL Cummulative Timer. |
 |[[programs:​odxsql:​commands:​benchmark|BENCHMARK]] | Execute Benchmarks to analyze performance. | |[[programs:​odxsql:​commands:​benchmark|BENCHMARK]] | Execute Benchmarks to analyze performance. |
-| [[programs:​odxsql:​commands:​extract|EXTRACT]] | Extracts SQL Statements from a table and writes them to a file. | 
 | [[programs:​odxsql:​commands:​format|FORMAT]] | Format a file of Omnidex SQL Statements. | | [[programs:​odxsql:​commands:​format|FORMAT]] | Format a file of Omnidex SQL Statements. |
-| [[programs:​odxsql:​commands:​n_colon | n:]] | Send the numbered OdxSQL History Command to a son process. | 
 | [[programs:​odxsql:​commands:​error|ERROR]] | Display the text of an error message from the Omnidex Error Message file. | | [[programs:​odxsql:​commands:​error|ERROR]] | Display the text of an error message from the Omnidex Error Message file. |
-| [[programs:​odxsql:​commands:​message|MESSAGE]] | Display an Omnidex Environment Message. | +| [[programs:​odxsql:​commands:​execsql|EXECSQL]] | Execute an Omnidex SQL Statement directly with the oaexecsql routine without OdxSQL doing any processing. | 
-| [[programs:​odxsql:​commands:​execsql|EXECSQL]] | Execute an Omnidex SQL Statement directly with the oaexecsql routine without OdxSQL doing any processing.  +
-| [[programs:​odxsql:​commands:​networkaccess|NETWORKACCESS]] | Execute an Omndiex Network Access Command. | +
-| [[programs:​odxsql:​commands:​sleep|SLEEP]] | Sleep for a specified number of seconds. | +
-| [[programs:​odxsql:​commands:​abort|ABORT]] | Issues an Operating System Abort - used to test abnormal conditions. | +
-| [[programs:​odxsql:​commands:​signal|SIGNAL]] | Sends a Signal to a process. | +
-| [[programs:​odxsql:​commands:​sleep|SLEEP]] | Sleep for a specified number of seconds. | +
-| [[programs:​odxsql:​commands:​dump|DUMP]] | Dump files, memory or caches. | +
-| [[programs:​odxsql:​commands:​oxkernel|OXKERNEL]] | Execute an Omnidex Kernel Command. ​ Should be used for Debugging with DISC Personnel. | +
-| [[programs:​odxsql:​commands:​parse|PARSE]] | Parse an Omnidex SQL Statement to a file.  This would only be used by DISC Personnel. | +
-| [[programs:​odxsql:​commands:​sortmerge|SORTMERGE]] | Internal: Activates the Sort/Merge Test System. |+
 ===== OdxSQL Operating System Commands ===== ===== OdxSQL Operating System Commands =====
  
 +OdxSQL contains several commands that access the underlying operating to facilitate the Omnidex Administrator or Developer staying inside of OdxSQL for many tasks.
 +
 +^ Command ^  Description ​ ^
 | [[programs:​odxsql:​commands:​exclamationpoint|! <shell command> ]] |Run an OS command in the OS Shell and return or just an ( ! ) for an interactive shell. | | [[programs:​odxsql:​commands:​exclamationpoint|! <shell command> ]] |Run an OS command in the OS Shell and return or just an ( ! ) for an interactive shell. |
 | [[programs:​odxsql:​commands:​command|COMMAND]] | Execute a shell command via the $COMMAND table. | | [[programs:​odxsql:​commands:​command|COMMAND]] | Execute a shell command via the $COMMAND table. |
Line 166: Line 128:
 | [[programs:​odxsql:​commands:​rename|RENAME]] | Rename a file or fileset in the underlying Operating System. | | [[programs:​odxsql:​commands:​rename|RENAME]] | Rename a file or fileset in the underlying Operating System. |
 | [[programs:​odxsql:​commands:​view |VIEW]] | View a text file. | | [[programs:​odxsql:​commands:​view |VIEW]] | View a text file. |
-| [[programs:​odxsql:​commands:​setenv|SETENV ]] | Set an Operating System Environment Variable. | +===== Alphabetical List of OdxSQL Commands and Omnidex SQL Statements =====
-| [[programs:​odxsql:​commands:​getenv|GETENV]] | Display an Operating System Environment Variable. | +
-| [[programs:​odxsql:​commands:​abort|ABORT]] | Issues an Operating System Abort - used to test abnormal conditions. |+
  
-===== Omnidex Index Direct Maintenance Routines =====+The following is a complete list of all OdxSQL Commands and all Omnidex ​SQL Statements that can be entered through OdxSQL. 
 + 
 +^ Command ^ Type ^Description ^ 
 +| [[programs:​odxsql:​commands:​exclamationpoint|! <shell command> ]] | Command | Run the command in the OS Shell and return or ! for interactive shell | 
 +| [[programs:​odxsql:​commands:​period|. Redo Command]] | Command | Execute the last command. | 
 +| [[programs:​odxsql:​commands:​n | n]] | Command | Execute the numbered OdxSQL History Command or Statement. |  
 +| [[programs:​odxsql:​commands:​attach|ATTACH]] | Statement | Attach an OST file as a table to the currently connected Omnidex Environment. | 
 +|[[programs:​odxsql:​commands:​benchmark|BENCHMARK]] | Command | Execute Benchmarks to analyze performance. | 
 +| [[programs:​odxsql:​commands:​calc|CALC]] | Command |Perform basic calculator functions. | 
 +| [[programs:​odxsql:​commands:​cd|CD]] | Command | Change Directories in the underlying Operating System. | 
 +| [[programs:​odxsql:​commands:​close_cursor|CLOSE CURSOR]] | Statement | Close a previously opened cursor. | 
 +| [[programs:​odxsql:​commands:​connect|CONNECT]] | Both | Connect to an Omnidex Environment or ODBC/JDBC Datasource File (DSN). | 
 +| [[programs:​odxsql:​commands:​convert|CONVERT]] | Command | Export a file with data conversion. | 
 +| Comment ( ; ) | Command | Use a semicolon as the first character of a line for a comment line. | 
 +| [[programs:​odxsql:​commands:​copy|COPY]] | Command | Copy a fileset. | 
 +| [[programs:​odxsql:​commands:​create_database|CREATE DATABASE]] | Statement | (V5.1) Create ad Database within an Omnidex Environment. | 
 +| [[programs:​odxsql:​commands:​create_directory|CREATE DIRECTORY]] | Statement | Create a directory in the underlying Operating System. | 
 +| [[programs:​odxsql:​commands:​create_environment|CREATE ENVIRONMENT]] | Statement | (V5.1) Create an Omnidex Environment. | 
 +| [[programs:​odxsql:​commands:​create_file|CREATE FILE]] | Command | Create a File in the underlying Operating System. | 
 +| [[programs:​odxsql:​commands:​create_index|CREATE INDEX]] | Statement | (V5.1 Create ​Index | 
 +| [[programs:​odxsql:​commands:​create_indexes|CREATE INDEXES]] | Statement | Create Omnidex Indexes. | 
 +| [[programs:​odxsql:​commands:​create_table|CREATE TABLE]] | Statement | (V5.1) Create a Table. | 
 +| [[programs:​odxsql:​commands:​date|DATE]] | Command | Show the current Date and Time. | 
 +| [[programs:​odxsql:​commands:​delete|DELETE]] | Statement | Issue the SQL DELETE Statement. | 
 +| [[programs:​odxsql:​commands:​detach|DETACH]] | Statement | Detach a previously attached Omnidex Standalone Table (OST) file. | 
 +| [[programs:​odxsql:​commands:​dir|DIR]] | Command | Display a directory of files from the current directory in the underlying Operating System. | 
 +| [[programs:​odxsql:​commands:​disconnect|DISCONNECT]] | Statement | Disconnect from a previously Connected Omnidex Environment or ODBC or JDBC Datasource (DSN). | 
 +| [[programs:​odxsql:​commands:​drop_database|DROP DATABASE]] | Statement | Drop Database(V5.1) | 
 +| [[programs:​odxsql:​commands:​drop_environment|DROP ENVIRONMENT]] | Statement | Drop Environment. (V5.1) | 
 +| [[programs:​odxsql:​commands:​drop_index|DROP INDEX]] | Statement | Drop Index. (V5.1) | 
 +| [[programs:​odxsql:​commands:​drop_indexes|DROP INDEXES]] | Statement | Drop Indexes. | 
 +| [[programs:​odxsql:​commands:​drop_table|DROP TABLE]] | Statement | Drop a previously created temporary table. Expaned in (V5.1) | 
 +| [[programs:​odxsql:​commands:​edit|EDIT]] | Command | Edit a previous command or file. | 
 +| [[programs:​odxsql:​commands:​error|ERROR]] | Command | Display the text of an error message from the Omnidex Error Message file. | 
 +| [[programs:​odxsql:​commands:​execsql|EXECSQL]] | Command | Execute an Omnidex SQL Statement directly with the oaexecsql routine without OdxSQL doing any processing. | 
 +| [[programs:​odxsql:​commands:​exit|EXIT]] | Command | Exit the OdxSQL program.| 
 +| [[programs:​odxsql:​commands:​explain|EXPLAIN]] | Command | Explain the optimization approach to a previous retrieval. | 
 +| [[programs:​odxsql:​commands:​export|EXPORT]] | Statement | Export rows to a file. | 
 +| [[programs:​odxsql:​commands:​extract|EXTRACT]] | Command | Extracts SQL Statements from a table and writes them to a file. To be removed in 5.1 | 
 +| [[programs:​odxsql:​commands:​fetch|FETCH]] | Command | Explicitly fetch data from the database. | 
 +| [[programs:​odxsql:​commands:​fetchkeys|FETCHKEYS]] |Command | Explicitly fetch keys from the Omnidex Indexes. | 
 +| [[programs:​odxsql:​commands:​for|FOR]] | Command | Execute the next one or more commands the specified number of times. | 
 +| [[programs:​odxsql:​commands:​format|FORMAT]] | Command | Format a file of Omnidex SQL Statements. | 
 +| [[programs:​odxsql:​commands:​help|HELP]] | Command | Help on COMMANDS, SYNTAX and API. | 
 +| [[programs:​odxsql:​commands:​history|HISTORY]] | Command | Show the history of OdxSQL Commands and Statements. | 
 +| [[programs:​odxsql:​commands:​if|IF]] | Command | Form an IF ELIF ELSE ENDIF Construct. | 
 +| [[programs:​odxsql:​commands:​insert|INSERT]] | Statement | Issue an Omnidex SQL INSERT Statement. | 
 +| [[programs:​odxsql:​commands:​join|JOIN]] |Statement | Join tables using Omnidex Indexes. | 
 +| [[programs:​odxsql:​commands:​load ofx|LOAD OFX]] |Statement | Load Indexes for a table. | 
 +| [[programs:​odxsql:​commands:​open_cursor|OPEN CURSOR]] |Statement | Open a Cursor. | 
 +| [[programs:​odxsql:​commands:​partition|PARTITION]] | Statement | Partition a table into smaller sub tables based on criteria. | 
 +| [[programs:​odxsql:​commands:​pwd|PWD]] | Command | Print (display) the current working directory from the underlying Operating System. | 
 +| [[programs:​odxsql:​commands:​qualify|QUALIFY]] |Statement | Qualify rows using Omnidex criteria. | 
 +| [[programs:​odxsql:​commands:​quit|QUIT]] | Command | Quit the OdxSQL program. ​ Same as Exit. | 
 +| [[programs:​odxsql:​commands:​remove|REMOVE]] | Command | Remove (delete or purge) one or more files or directories from the underlying Operating System. | 
 +| [[programs:​odxsql:​commands:​rename|RENAME]] | Command | Rename a file or fileset in the underlying Operating System. | 
 +| [[programs:​odxsql:​commands:​reset_history|RESET HISTORY]] | Command | Resets the OdxSQL History of Commands and Statements. | 
 +| [[programs:​odxsql:​commands:​reset_timer|RESET TIMER]] | Command | Reset the OdxSQL Cummulative Timer. | 
 +| [[programs:​odxsql:​commands:​restore_settings|RESTORE SETTINGS]] | Command | Restore Settings, optionally from a file that was created with a previous SAVE SETTINGS command. | 
 +| [[programs:​odxsql:​commands:​save_history|SAVE HISTORY]] | Command | Save the OdxSQL Command History to a file. | 
 +| [[programs:​odxsql:​commands:​save_settings|SAVE SETTINGS]] | Command | Save OdxSQL Settings to a file for use with a later RESTORE SETTINGS Command. | 
 +| [[programs:​odxsql:​commands:​select|SELECT]] |Statement | Issue an Omnidex SQL SELECT Statement. | 
 +| [[programs:​odxsql:​commands:​set|SET]] | Both | Set an OdxSQL setting. | 
 +| [[programs:​odxsql:​commands:​show|SHOW]] | Command |Show Omnidex Environment information including Databases, Tables, Column layouts, Query Statistics, etc. | 
 +| [[programs:​odxsql:​commands:​show_ddl|SHOW DDL]] | Show Data Definition Statements. | 
 +| [[programs:​odxsql:​commands:​signal|SIGNAL]] | Command | Sends a Signal to a process. | 
 +| [[programs:​odxsql:​commands:​update|UPDATE]] | Statement | Issue an Omnidex SQL UPDATE Statement. | 
 +| [[programs:​odxsql:​commands:​update_indexes|UPDATE INDEXES]] |Statement | Update Omnidex Indexes | 
 +| [[programs:​odxsql:​commands:​update_rollup|UPDATE ROLLUP]] |Statement | Update Rollup Table with summarized information. | 
 +| [[programs:​odxsql:​commands:​update_rollups|UPDATE ROLLUPS]] |Statement | Update all Rollup Tables for an Omnidex Database. |  
 +| [[programs:​odxsql:​commands:​update_statistics|UPDATE STATISTICS]] |Statement | Update Statistics Information. | 
 +| [[programs:​odxsql:​commands:​update_text|UPDATE TEXT]] |Statement | Update Textual Statistics. | 
 +| [[programs:​odxsql:​commands:​use|USE]] | Command | Read and process a file of OdxSQL Commands and Omnidex SQL Statements, optionally with WHERE criteria. | 
 +| [[programs:​odxsql:​commands:​validate|VALIDATE]] | Command | Validate the Omnidex Environment'​s view of the underlying data. To be removed in 5.1 | 
 +| [[programs:​odxsql:​commands:​version|VERSION]] | Command | Display current Omnidex Software versions. | 
 +| [[programs:​odxsql:​commands:​view | VIEW]] | Command | View a text file. |
  
-| [[programs:​odxsql:​commands:​insertindex|INSERTINDEX]] | Insert values directly into the Omnidex Indexes. | 
-| [[programs:​odxsql:​commands:​updateindex|UPDATEINDEX]] | Update values directly in the Omnidex Indexes. | 
-| [[programs:​odxsql:​commands:​deleteindex|DELETEINDEX]] | Delete values directly from the Omnidex Indexes. | 
-===== Alphabetical List of OdxSQL Commands and Omnidex SQL Statements ===== 
  
-^ Command ^ Description ^ 
-| [[programs:​odxsql:​commands:​exclamationpoint|! <shell command> ]] |Run the command in the OS Shell and return or ! for interactive shell | 
-| [[programs:​odxsql:​commands:​period|. Redo Command]] | Execute the last command. | 
-| [[programs:​odxsql:​commands:​abort|ABORT]] | Issues an Operating System Abort - used to test abnormal conditions. | 
-| [[dev:​sql:​assignvalues | ASSIGNVALUES]] | Assign values for a $VALUES clause to be used in a subsequent SELECT. | 
-| [[programs:​odxsql:​commands:​attach|ATTACH]] | Attach an OST file as a table to the currently connected Omnidex Environment. | 
-|[[programs:​odxsql:​commands:​benchmark|BENCHMARK]] | Execute Benchmarks to analyze performance. | 
-| [[programs:​odxsql:​commands:​bind|BIND]] | Bind a SELECT Statement. | 
-| [[programs:​odxsql:​commands:​calc|CALC]] |Perform basic calculator functions. | 
-| [[programs:​odxsql:​commands:​cd|CD]] | Change Directories in the underlying Operating System. | 
-| [[programs:​odxsql:​commands:​close_cursor|CLOSE CURSOR]] | Close a previously opened cursor. | 
-| [[programs:​odxsql:​commands:​command|COMMAND]] | Execute a shell command via the $COMMAND table. | 
-| Comment ( ; ) | Use a semicolon as the first character of a line for a comment line. | 
-| [[programs:​odxsql:​commands:​connect|CONNECT]] | Connect to an Omnidex Environment or ODBC/JDBC Datasource File (DSN). | 
-| [[programs:​odxsql:​commands:​convert|CONVERT]] | Export a file with data conversion. | 
-| [[programs:​odxsql:​commands:​copy|COPY]] | Copy a fileset. | 
-| [[programs:​odxsql:​commands:​create_database|CREATE DATABASE]] | (V5.1) Create ad Database within an Omnidex Environment. | 
-| [[programs:​odxsql:​commands:​create_directory|CREATE DIRECTORY]] | Create a directory in the underlying Operating System. | 
-| [[programs:​odxsql:​commands:​create_environment|CREATE ENVIRONMENT]] | (V5.1) Create an Omnidex Environment. | 
-| [[programs:​odxsql:​commands:​create_file|CREATE FILE]] | Create a File in the underlying Operating System. | 
-| [[programs:​odxsql:​commands:​create_index|CREATE INDEX]] | (V5.1 Create Index | 
-| [[programs:​odxsql:​commands:​create_indexes|CREATE INDEXES]] | Create Omnidex Indexes. | 
-| [[programs:​odxsql:​commands:​create_table|CREATE TABLE]] | (V5.1) Create a Table. | 
-| [[programs:​odxsql:​commands:​date|DATE]] | Show the current Date and Time. | 
-| [[programs:​odxsql:​commands:​delete|DELETE]] | Issue the SQL DELETE Statement. | 
-| [[programs:​odxsql:​commands:​deleteindex|DELETEINDEX]] | Delete values directly from the Omnidex Indexes. | 
-| [[programs:​odxsql:​commands:​describe|DESCRIBE]] | Describe a SELECT Statement. | 
-| [[programs:​odxsql:​commands:​detach|DETACH]] | Detach a previously attached Omnidex Standalone Table (OST) file. | 
-| [[programs:​odxsql:​commands:​dir|DIR]] | Display a directory of files from the current directory in the underlying Operating System. | 
-| [[programs:​odxsql:​commands:​disconnect|DISCONNECT]] | Disconnect from a previously Connected Omnidex Environment or ODBC or JDBC Datasource (DSN). | 
-| [[programs:​odxsql:​commands:​drop_database|DROP DATABASE]] | Drop Database(V5.1) | 
-| [[programs:​odxsql:​commands:​drop_environment|DROP ENVIRONMENT]] | Drop Environment. (V5.1) | 
-| [[programs:​odxsql:​commands:​drop_index|DROP INDEX]] | Drop Index. (V5.1) | 
-| [[programs:​odxsql:​commands:​drop_indexes|DROP INDEXES]] | Drop Indexes. | 
-| [[programs:​odxsql:​commands:​drop_table|DROP TABLE]] | Drop a previously created temporary table. Expaned in (V5.1) | 
-| [[programs:​odxsql:​commands:​dump|DUMP]] | Dump files, memory or caches. | 
-| [[programs:​odxsql:​commands:​edit|EDIT]] | Edit a previous command or file. | 
-| [[programs:​odxsql:​commands:​error|ERROR]] | Display the text of an error message from the Omnidex Error Message file. | 
-| [[programs:​odxsql:​commands:​eval|EVAL]] | Evaluate a condition. | 
-| [[programs:​odxsql:​commands:​execsql|EXECSQL]] | Execute an Omnidex SQL Statement directly with the oaexecsql routine without OdxSQL doing any processing. | 
-| [[programs:​odxsql:​commands:​exit|EXIT]] | Exit the OdxSQL program.| 
-| [[programs:​odxsql:​commands:​explain|EXPLAIN]] | Explain the optimization approach to a previous retrieval. | 
-| [[programs:​odxsql:​commands:​export|EXPORT]] | Export rows to a file. | 
-| [[programs:​odxsql:​commands:​extract|EXTRACT]] | Extracts SQL Statements from a table and writes them to a file. | 
-| [[programs:​odxsql:​commands:​fetch|FETCH]] | Explicitly fetch data from the database. | 
-| [[programs:​odxsql:​commands:​fetchkeys|FETCHKEYS]] | Explicitly fetch keys from the Omnidex Indexes. | 
-| [[programs:​odxsql:​commands:​flip|FLIP]] | Change the endian byte order from one endian to the other. | 
-| [[programs:​odxsql:​commands:​for|FOR]] | Execute the next one or more commands the specified number of times. | 
-| [[programs:​odxsql:​commands:​format|FORMAT]] | Format a file of Omnidex SQL Statements. | 
-| [[programs:​odxsql:​commands:​getenv|GETENV]] | Display an Operating System Environment Variable. | 
-| [[programs:​odxsql:​commands:​help|HELP]] | Help on COMMANDS, SYNTAX and API. | 
-| [[programs:​odxsql:​commands:​helper|HELPER]] | Access OAHELPER functions for generating Environment Catalogs. |  
-| [[programs:​odxsql:​commands:​history|HISTORY]] | Show the history of OdxSQL Commands and Statements. | 
-| [[programs:​odxsql:​commands:​if|IF]] | Form an IF ELIF ELSE ENDIF Construct. | 
-| [[programs:​odxsql:​commands:​insert|INSERT]] | Issue an Omnidex SQL INSERT Statement. | 
-| [[programs:​odxsql:​commands:​insertindex|INSERTINDEX]] | Insert values directly into the Omnidex Indexes. | 
-| [[programs:​odxsql:​commands:​is|IS]] | Check Table Conditions. | 
-| [[programs:​odxsql:​commands:​join|JOIN]] | Join tables using Omnidex Indexes. | 
-| [[programs:​odxsql:​commands:​load ofx|LOAD OFX]] | Load Indexes for a table. | 
-| [[programs:​odxsql:​commands:​lookup|LOOKUP]] | Lookup Text M etadata and display it. | 
-| [[programs:​odxsql:​commands:​message|MESSAGE]] | Display an Omnidex Environment Message. | 
-| [[programs:​odxsql:​commands:​networkaccess|NETWORKACCESS]] | Execute an Omndiex Network Access Command. | 
-| [[programs:​odxsql:​commands:​open_cursor|OPEN CURSOR]] | Open a Cursor. | 
-| [[programs:​odxsql:​commands:​oxkernel|OXKERNEL]] | Execute an Omnidex Kernel Command. ​ Should be used for Debugging with DISC Personnel. | 
-| [[programs:​odxsql:​commands:​parse|PARSE]] | Parse an Omnidex SQL Statement to a file.  This would only be used by DISC Personnel. | 
-| [[programs:​odxsql:​commands:​partition|PARTITION]] | Partition a table into smaller sub tables based on criteria. | 
-| [[programs:​odxsql:​commands:​pwd|PWD]] | Print (display) the current working directory from the underlying Operating System. | 
-| [[programs:​odxsql:​commands:​qualify|QUALIFY]] | Qualify rows using Omnidex criteria. | 
-| [[programs:​odxsql:​commands:​quit|QUIT]] | Quit the OdxSQL program. ​ Same as Exit. | 
-| [[programs:​odxsql:​commands:​remove|REMOVE]] | Remove (delete or purge) one or more files or directories from the underlying Operating System. | 
-| [[programs:​odxsql:​commands:​rename|RENAME]] | Rename a file or fileset in the underlying Operating System. | 
-| [[programs:​odxsql:​commands:​reset_history|RESET HISTORY]] | Resets the OdxSQL History of Commands and Statements. | 
-| [[programs:​odxsql:​commands:​reset_timer|RESET TIMER]] | Reset the OdxSQL Cummulative Timer. | 
-| [[programs:​odxsql:​commands:​restore_settings|RESTORE SETTINGS]] | Restore Settings, optionally from a file that was created with a previous SAVE SETTINGS command. | 
-| [[programs:​odxsql:​commands:​save_history|SAVE HISTORY]] | Save the OdxSQL Command History to a file. | 
-| [[programs:​odxsql:​commands:​save_settings|SAVE SETTINGS]] | Save OdxSQL Settings to a file for use with a later RESTORE SETTINGS Command. | 
-| [[programs:​odxsql:​commands:​select|SELECT]] | Issue an Omnidex SQL SELECT Statement. | 
-| [[programs:​odxsql:​commands:​set|SET]] | Set an OdxSQL setting. | 
-| [[programs:​odxsql:​commands:​setenv|SETENV ]] | Set an Operating System Environment Variable. | 
-| [[programs:​odxsql:​commands:​show|SHOW]] | Show Omnidex Environment information including Databases, Tables, Column layouts, Query Statistics, etc. | 
-| [[programs:​odxsql:​commands:​signal|SIGNAL]] | Sends a Signal to a process. | 
-| [[programs:​odxsql:​commands:​sleep|SLEEP]] | Sleep for a specified number of seconds. | 
-| [[programs:​odxsql:​commands:​sortmerge|SORTMERGE]] | Internal: Activates the Sort/Merge Test System. | 
-| [[programs:​odxsql:​commands:​update|UPDATE]] | Issue an Omnidex SQL UPDATE Statement. | 
-| [[programs:​odxsql:​commands:​update_indexes|UPDATE INDEXES]] | Update Omnidex Indexes | 
-| [[programs:​odxsql:​commands:​update_rollup|UPDATE ROLLUP]] | Update Rollup Table with summarized information. | 
-| [[programs:​odxsql:​commands:​update_rollups|UPDATE ROLLUPS]] | Update all Rollup Tables for an Omnidex Database. |  
-| [[programs:​odxsql:​commands:​update_statistics|UPDATE STATISTICS]] | Update Statistics Information. | 
-| [[programs:​odxsql:​commands:​update_text|UPDATE TEXT]] | Update Textual Statistics. | 
-| [[programs:​odxsql:​commands:​updateindex|UPDATEINDEX]] | Update values directly in the Omnidex Indexes. | 
-| [[programs:​odxsql:​commands:​use|USE]] | Read and process a file of OdxSQL Commands and Omnidex SQL Statements, optionally with WHERE criteria. | 
-| [[programs:​odxsql:​commands:​validate|VALIDATE]] | Validate the Omnidex Environment'​s view of the underlying data. | 
-| [[programs:​odxsql:​commands:​version|VERSION]] | Display current Omnidex Software versions. | 
-| [[programs:​odxsql:​commands:​view | VIEW]] | View a text file. | 
-| [[programs:​odxsql:​commands:​n | n]] | Execute the numbered OdxSQL History Command or Statement. |  
-| [[programs:​odxsql:​commands:​n_colon | n:]] | Send the numbered OdxSQL History Command to the a son process. | 
  
  
 
Back to top
programs/odxsql/commands/home.1259774116.txt.gz · Last modified: 2016/06/28 22:38 (external edit)
Sitemap Recent Changes