This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
programs:odxsql:intro [2009/07/16 21:24] admin |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== OdxSql ====== | ||
| - | ===== Overview ===== | ||
| - | OdxSql is an Omnidex interactive SQL utility used for testing installations, prototyping queries, and exporting data. OdxSql supports many functions designed to assist in creating fully optimized installations and queries including benchmarking and the explain plan. | ||
| - | |||
| - | OdxSql allows the interactive specification of SQL statements using supported SQL 92 syntax. OdxSql also fully supports the Omnidex Query Language as well as several additional functions exclusive to OdxSql. | ||
| - | |||
| - | Run OdxSql from the command line with the following syntax: | ||
| - | |||
| - | odxsql [environment_name] | [-use=use_file] | ||
| - | |||
| - | |||
| - | Run time arguments: | ||
| - | |||
| - | environment_name | ||
| - | The environment_name parameter is the environment catalog filespec that OdxSql will connect to. OdxSql will try to connect to the specified environment. If this filespec is not passed as a program argument, then a CONNECT statement must be performed to establish a connection to the environment catalog. | ||
| - | |||
| - | -use=use_file | ||
| - | The -use=use_file parameter instructs OdxSql to process all the commands contained within the specified use file. The right hand side of the parameter, use_file, is the filespec of the file containing the commands. | ||
| - | |||
| - | |||
| - | Example | ||
| - | |||
| - | odxsql | ||
| - | |||
| - | or | ||
| - | |||
| - | odxsql orders.env | ||
| - | |||
| - | or | ||
| - | |||
| - | odxsql -use=commands.txt | ||
| - | |||
| - | |||
| - | Getting Help | ||
| - | |||
| - | Type help at the command prompt with no arguments to see an alphabetical list of ODXSQL commands. | ||
| - | |||
| - | >help | ||
| - | ... | ||
| - | |||
| - | Type help with the argument 'syntax' at the command prompt to see a list of commands with their syntax. | ||
| - | |||
| - | >help syntax | ||
| - | ... | ||
| - | |||
| - | Type help followed by a specific command to see additional information about that command. | ||
| - | |||
| - | >help connect | ||
| - | |||
| - | CONNECT | ||
| - | Connect to an environment file | ||
| - | Syntax: | ||
| - | Connect [TO] filename [AS [user]/[password]] [WITH options] | ||
| - | |||
| - | See HELP in the ODXSQL Commands section for more information. | ||
| - | |||
| - | |||
| - | ====== Quick Links ====== | ||
| - | ^ [[:start|Quick Links]] ^^^^^ | ||
| - | ^ General ^ Programs ^ Interfaces ^ General Topics ^ Miscellaneous Items^ | ||
| - | | [[overview:intro|Omnidex Introduction]] | [[programs:odxsql:intro|OdxSQL]] |[[development:interfaces:odbc:intro|ODBC]] | [[design:grids:intro|Grids]] | [[releasenotes:intro|Release Notes]] | | ||
| - | | [[odxadmin:intro|Administrating Omnidex (OdxAdmin)]] | [[programs:odxnet:intro|OdxNet]] |[[development:interfaces:jdbc:intro|JDBC]] | [[design:unionview:intro|Union Views]]| [[osinstall:intro|Server Installs]] | | ||
| - | | [[design:intro|Data and Index Design]] | [[programs:odxaim:intro|OdxAim]] |[[development:interfaces:storedproc:intro|Stored Procedures]] | [[design:rolluptable:intro|Rollup Tables]] | [[osinstall:licensing:intro|Licensing]] | | ||
| - | | [[sql:intro|Omnidex Queries & SQL]] | [[programs:dbinstal:intro|DBInstal]] |[[development:interfaces:omniaccess:intro|OmniAccess]] | [[design:partitioning:intro|Partitioning]] | [[osinstall:settings:intro|Settings]] | | ||
| - | | [[activecounts:intro|Active Counts]] | [[programs:oaenv:intro|OaComp/decomp/helper]] |[[development:interfaces:clientoa:intro|Client OA]] | [[development:explainplan:intro|Explain Plans]]| [[glossary:intro|Glossary]] | | ||
| - | | [[powersearch:intro|PowerSearch]] | [[programs:client:intro|DSEdit/OdxQuery]] | [[rdbms:intro|RDBMS Indexing]] | [[development:debugging:intro|Debugging]] | [[appendix:intro|Appendix]] | | ||
| - | (c) Copyright Dynamic Information Systems - This document was last updated July 15, 2009. | ||
| - | |||
| - | ---- | ||