https://www.omnidex.com/docs/v54/ 2026-06-17T03:33:28+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:commands:calc&rev=1467153531&do=diff OdxSQL CALC Operators: + \ / * ^ ( ) % is modulus calc 14 % 10 = is for assignment calc A = 1 calc B = 2 calc A + B KB is a constant for 2^10 MB is a constant for 2^20 GB is a constant for 2^30 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:connect&rev=1467153531&do=diff OdxSQL Connect Environment Description CONNECT establishes a connection to an Omnidex Environment and opens a cursor. CONNECT is followed by either an Omnidex Environment filespec or a File DSN for ODBC, JDBC or CLOA connections. Syntax CONNECT [TO] Omnidex_Environment [ON host[:port]] [AS [user]/[password]] [USING api] [WITH options] 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:home&rev=1467153531&do=diff OdxSQL Commands and Omnidex SQL Statements OdxSQL: Overview Commands Settings Command Line Quick Ref OdxSQL processes Omnidex SQL statements and OdxSQL specific commands either interactively or in batch oriented script files via the USE command. The following is a list of Omnidex SQL Statements and OdxSQL commands organized by type with a complete alphabetic list shown below.