https://www.omnidex.com/docs/v54/ 2026-08-09T09:37:47+0000 https://www.omnidex.com/docs/v54/ https://www.omnidex.com/docs/v54/lib/tpl/simple/images/favicon.ico text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=programs:odxsql:cmdline&rev=1467153531&do=diff Programs: OdxSQL Overview | Commands | Options | Command-line | Command Files ---------- Command line OdxSQL can be run with command-line options that determine how OdxSQL is to be run. Combinations of these options can also be used to instruct OdxSQL to execute one or more commands and then exit, making it possible to embed all instructions in a shell script. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=programs:odxsql:commandline&rev=1467153531&do=diff OdxSQL Command Line Options OdxSQL: Overview Commands Settings Command Line Quick Ref OdxSQL can accept the Omnidex Environment as well as several other options. If the Omnidex Environment is specified, OdxSQL will automatically attempt to connect to the specified Environment. Syntax text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=programs:odxsql:commands&rev=1467153531&do=diff Programs: OdxSQL Overview | Commands | Options | Command-line | Command Files ---------- Commands The following commands are available in OdxSQL: ATTACH DATABASE The ATTACH DATABASE command attaches a database from one environment into the currently connected environment, thereby allowing SQL statements to access both databases. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=programs:odxsql:files&rev=1467153531&do=diff Programs: OdxSQL Overview | Commands | Options | Command-line | Command Files ---------- Command Files OdxSQL can execute a file of commands using the USE command. This is useful to run a batch of commands in succession. A common use of this approach are the CREATE ENVIRONMENT, CREATE DATABASE and CREATE TABLE statements that are used to create an Omnidex environment file. A command file is often used to process the commands to update the rollup tables, indexes and text dictionaries for a… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=programs:odxsql:home&rev=1467153531&do=diff Programs: OdxSQL Overview | Commands | Options | Command-line | Command Files ---------- Overview The OdxSQL program is a console-based utility for issuing Omnidex statements and viewing their results. OdxSQL allows customers to test or execute nearly every capability in Omnidex. Furthermore, OdxSQL can be easily integrated into shell scripts for use in automated batch operations. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=programs:odxsql:options&rev=1467153531&do=diff Programs: OdxSQL Overview | Commands | Options | Command-line | Command Files ---------- Options There are many options that can be set in OdxSQL. They are described below. SET API The SET command by itself shows the values for all of the settings in OdxSQL. SET SET API The SET API text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=programs:odxsql:overview&rev=1467153531&do=diff OdxSQL Overview OdxSQL: Overview Commands Settings Command Line Quick Ref OdxSQL is a console program used for creating and maintaining Omnidex environments, testing installations, prototyping queries, and exporting data. OdxSQL supports many functions designed to assist in creating fully optimized installations and queries including benchmarking and for executing explain plans to determine query performance.