This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
appendix:docmap [2009/11/12 22:06] els |
appendix:docmap [2012/10/26 14:24] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Omnidex Version 5.0 ====== | + | ====== Omnidex Version 5.0 Table of Contents ====== |
| + | ===== Overview ===== | ||
| + | - [[overview:omnidex|What is Omnidex?]] | ||
| + | - Using Omnidex | ||
| + | * [[overview:lists|Using Omnidex: Database Marketing and Customer Lists]] | ||
| + | * [[overview:analytics|Using Omnidex: Business Analytics and Data Warehouses]] | ||
| + | * [[overview:onlinedb|Using Omnidex: Online, Searchable Databases]] | ||
| + | * [[overview:flatfiles|Using Omnidex: Transaction Logs and Raw Data Files]] | ||
| + | * [[overview:largedb|Using Omnidex: Billion-record Databases]] | ||
| + | * [[overview:text|Using Omnidex: Knowledgebases and Text Databases]] | ||
| + | |||
| + | ===== The Environment Catalog ===== | ||
| + | * [[oaenv:home | Omnidex Environment Syntax ]] | ||
| + | * [[oaenv:examples:c_oa_wine | C Example using OmniAccess API ]] | ||
| + | ===== Indexing with DBINSTAL ===== | ||
| - | === Table of Contents === | + | * [[programs:dbinstal:home|Overview]] |
| - | - Overview | + | * [[programs:dbinstal:commandline|Command-line options]] |
| - | - [[nopage|What is Omnidex?]] | + | * [[programs:dbinstal:commands | Commands ]] |
| - | - [[nopage|Omnidex Architecture]] | + | * [[programs:dbinstal:field_options | Options ]] |
| - | - [[nopage|Quick Start Guide]] | + | |
| - | - [[nopage|Using Omnidex: Customer Lists]] | + | |
| - | - [[nopage|Using Omnidex: Business Analytics]] | + | |
| - | - [[nopage|Using Omnidex: Transaction Logs]] | + | |
| - | - [[nopage|Using Omnidex: Flat File Databases]] | + | |
| - | - [[nopage|Using Omnidex: Text Databases]] | + | |
| - | - [[nopage|Using Omnidex: Knowledgebases]] | + | |
| - | - Topics | + | |
| - | - [[nopage|Fast Counts]] | + | |
| - | - [[nopage|Fast Aggregations]] | + | |
| - | - [[nopage|Textual Searches]] | + | |
| - | - [[Topics:Snapshots|Portable Snapshots]] | + | |
| - | - [[Topics:Grids|Scalable Grids]] | + | |
| - | - [[nopage|Environment Files]] | + | |
| - | - Adminstrators | + | |
| - | - The Omnnidex Development and Deployment Lifecycle | + | |
| - | * [[nopage|Development]] | + | |
| - | * [[nopage|Testing]] | + | |
| - | * [[nopage|Staging]] | + | |
| - | * [[nopage|Deployment]] | + | |
| - | - Environment Files | + | |
| - | * [[nopage|Overview]] | + | |
| - | * [[nopage|Using Omnidex Administrator to create an Environment File]] | + | |
| - | * [[nopage|Creating an Environment File from an existing RDBMS]] | + | |
| - | * [[nopage|Creating an Environment File from existing flat files]] | + | |
| - | * [[nopage|Creating an Environment File from scratch]] | + | |
| - | * [[nopage|Using DDL to create an Environment File]] | + | |
| - | * [[nopage|Legacy: using OACOMP to create and Environment File]] | + | |
| - | * [[nopage|Legacy: Using OAHELPER to create an Environment File]] | + | |
| - | - Omnidex Criteria | + | |
| - | * [[nopage|Wildcards and Pattern matching]] | + | |
| - | * [[nopage|Boolean Operators]] | + | |
| - | * [[nopage|Range Operators]] | + | |
| - | * [[nopage|Files Containg Criteria Values]] | + | |
| - | * [[nopage|Synonym Searches]] | + | |
| - | * [[nopage|Thesaurus Searches]] | + | |
| - | * [[nopage|Word Form Searches]] | + | |
| - | * [[nopage|Spellchecked and Misspelling Searches]] | + | |
| - | * [[nopage|Number Transposition Searches]] | + | |
| - | * [[nopage|Phonetic Searches]] | + | |
| - | * [[nopage|Saved Searches]] | + | |
| - | * [[nopage|Multi-Column Index Searches]] | + | |
| - | * [[nopage|Case Sensitivity]] | + | |
| - | * [[nopage|Unicode Datatypes]] | + | |
| - | - Textual Searches | + | |
| - | * [[nopage|QuickText Indexes and Options]] | + | |
| - | * [[nopage|Effect of Boolean Operators]] | + | |
| - | * [[nopage|Effect of Wildcards and Pattern Matching]] | + | |
| - | * [[nopage|FullText Indexes and Options]] | + | |
| - | - Omnidex Indexing Strategies | + | |
| - | * [[nopage|Basic Indexing Strategies]] | + | |
| - | * [[nopage|Basic Strategies for Optimizing Criteria]] | + | |
| - | * [[nopage|Omnidex Indexes]] | + | |
| - | * [[nopage|Basic Strategies for Optimizing Aggregations]] | + | |
| - | * [[nopage|Indexing for Aggregations]] | + | |
| - | * [[nopage|Rollup Tables]] | + | |
| - | * [[nopage|Basic Strategies for Optimizing Nested Queries]] | + | |
| - | * [[nopage|Indexing Criteria Columns]] | + | |
| - | * [[nopage|Indexing Select Items]] | + | |
| - | - Advanced Indexing Strategies | + | |
| - | * [[nopage|Strategies for Optimizing Complex Criteria]] | + | |
| - | * [[nopage|Multi-component Indexes]] | + | |
| - | * [[nopage|Indexing Expression-based Columns]] | + | |
| - | * [[nopage|Strategies for Optimizing Complex Table Relationships]] | + | |
| - | * [[nopage|Prejoined Indexes]] | + | |
| - | * [[nopage|Multiple-Level Hierarchical Relationships]] | + | |
| - | * [[nopage|Strategies for Optimizing Distinct Counts]] | + | |
| - | * [[nopage|Distinct Counts on Primary or Foreign Keys]] | + | |
| - | * [[nopage|Distinct Counts on Other Columns]] | + | |
| - | * [[nopage|Distinct Counts in Omnidex Grids]] | + | |
| - | * [[nopage|Strategies for Optimizing Latitude/Longitude Searches]] | + | |
| - | * [[nopage|Radius Searches from One Set of Coordinates]] | + | |
| - | * [[nopage|Radius Searches from Multiple Sets of Coordinates]] | + | |
| - | * [[nopage|Strategies for Indexing Multiple Columns as a Single Column]] | + | |
| - | * [[nopage|Grouping Columns within One Table]] | + | |
| - | * [[nopage|Grouping Columns within Multiple Tables]] | + | |
| - | - Developers | + | |
| - | - Omnidex SQL Reference | + | |
| - | * [[nopage|ASSIGNVALUES]] %% Assign values for a $VALUES clause %% | + | |
| - | * [[nopage|ATTACH]] Attach an OST file as a table]] | + | |
| - | * [[nopage|CLOSE CURSOR]] Close a cursor]] | + | |
| - | * [[nopage|COMMAND]] Execute a shell command via $COMMAND table]] | + | |
| - | * [[nopage|CONNECT]] Connect to an environment file]] | + | |
| - | * [[nopage|CREATE DATABASE]] Create an Omnidex database]] | + | |
| - | * [[nopage|CREATE DIRECTORY]] Create a directory]] | + | |
| - | * [[nopage|CREATE ENVIRONMENT]] Create an Omnidex environment]] | + | |
| - | * [[nopage|CREATE FILE Create a file]] | + | |
| - | * [[nopage|CREATE INDEX Create an Omnidex index]] | + | |
| - | * [[nopage|CREATE INDEXES Create Omnidex indexes for a database]] | + | |
| - | * [[nopage|CREATE TABLE Create a table]] | + | |
| - | * [[nopage|DELETE Issue an SQL delete statement]] | + | |
| - | * [[nopage|DELETEINDEX Delete values directly from Omnidex indexes]] | + | |
| - | * [[nopage|DETACH Detach a previously attached OST file]] | + | |
| - | * [[nopage|DISCONNECT Disconnect from an environment file]] | + | |
| - | * [[nopage|DROP DATABASE Drop an Omnidex database]] | + | |
| - | * [[nopage|DROP ENVIRONMENT Drop an Omnidex environment]] | + | |
| - | * [[nopage|DROP INDEX Drop an Omnidex index]] | + | |
| - | * [[nopage|DROP INDEXES Drop Omnidex indexes for a database]] | + | |
| - | * [[nopage|DROP TABLE Drop a table]] | + | |
| - | * [[nopage|EXPORT Export records to a file]] | + | |
| - | * [[nopage|HELPER Access oahelper utilities]] | + | |
| - | * [[nopage|INSERT Issue an SQL insert statement]] | + | |
| - | * [[nopage|INSERTINDEX Insert values directly into Omnidex indexes]] | + | |
| - | * [[nopage|JOIN Join tables using Omnidex]] | + | |
| - | * [[nopage|LOAD OFX Load indexes for a table]] | + | |
| - | * [[nopage|OPEN CURSOR Open a cursor]] | + | |
| - | * [[nopage|PARTITION Partition a table]] | + | |
| - | * [[nopage|QUALIFY Qualify rows using Omnidex]] | + | |
| - | * [[nopage|SELECT Issue an SQL select statement]] | + | |
| - | * [[nopage|SET Set an option]] | + | |
| - | * [[nopage|UPDATE Issue an SQL update statement]] | + | |
| - | * [[nopage|UPDATE INDEXES Update Omnidex indexes]] | + | |
| - | * [[nopage|UPDATE ROLLUP Update rollup table]] | + | |
| - | * [[nopage|UPDATE ROLLUPS Update rollup tables]] | + | |
| - | * [[nopage|UPDATE STATISTICS Update statistical information]] | + | |
| - | * [[nopage|UPDATE TEXT Update textual statistics]] | + | |
| - | * [[nopage|UPDATEINDEX Update values directly in Omnidex indexes]] | + | |
| - | * [[nopage|VERSION Display current software versions]] | + | |
| - | - ODBC Interface | + | |
| - | * [[nopage|Setting up the ODBC Interface]] | + | |
| - | * [[nopage|Using the ODBC Interface]] | + | |
| - | * (details needed) | + | |
| - | * [[nopage|Examples]] | + | |
| - | - JDBC Interface | + | |
| - | * [[nopage|Setting up the JDBC Interface]] | + | |
| - | * [[nopage|Using the JDBC Interface]] | + | |
| - | * (details needed) | + | |
| - | * [[nopage|Examples]] | + | |
| - | * [[nopage|The JDBC Intelligent Router]] | + | |
| - | * (insert technote here) | + | |
| - | - Stored Procedures | + | |
| - | * [[nopage|Oracle]] | + | |
| - | * [[nopage|SQL Server]] | + | |
| - | - Legacy API's | + | |
| - | * [[nopage|OmniAccess]] | + | |
| - | * (insert legacy documentation here) | + | |
| - | * [[nopage|Client OmniAccess]] | + | |
| - | *(insert legacy documentation here) | + | |
| - | * [[nopage|ImagePlus]] | + | |
| - | * (insert legacy documentation here) | + | |
| - | - Developer FAQ | + | |
| - | - General | + | |
| - | - [[nopage|Software Installation]] | + | |
| - | - [[nopage|Platform Support]] | + | |
| - | - [[nopage|Release Notes]] | + | |
| - | - [[nopage|Migration From Earlier Versions]] | + | |
| - | - [[nopage|Glossary]] | + | |
| - | - [[nopage|Documentation Map]] | + | |
| - | - [[nopage|Installation FAQ]] | + | |
| + | ===== Omnidex SQL Reference ===== | ||
| - | <code> | + | * [[dev:sql:home | Omnidex SQL Quick Reference ]] |
| - | Documentation Map for Omnidex 5.n | + | * [[dev:sql:overview|Omnidex SQL Reference]] |
| + | * [[dev:sql:statements:home | Omnidex SQL Statements ]] | ||
| + | * [[dev:sql:functions:home | Omnidex SQL Function List ]] | ||
| + | * [[dev:sql:examples:home | Omnidex SQL Examples ]] | ||
| - | The following is a draft documentation map for the Omnidex 5.n documentation. | + | ===== Setting up Network Services (OdxNet ===== |
| + | * [[programs:odxnet:home|Omnidex Network Services]] | ||
| + | * [[programs:odxnet:commandline|Command-line options]] | ||
| + | * [[programs:odxnet:config|Configuration file]] | ||
| - | Table of Contents | + | ===== ODBC Interface ===== |
| + | * [[dev:odbc:home|ODBC Interface]] | ||
| + | * [[dev:odbc:setup|Setting up the ODBC Interface]] | ||
| + | * [[dev:odbc:usage|Using the ODBC Interface]] | ||
| + | * [[dev:odbc:examples:home|Examples]] | ||
| + | * [[dev:odbc:examples:csharp_simple_select | Windows C# Connection and Select ]] | ||
| + | * [[dev:odbc:examples:simpleselect | Windows C++ Simple Connection and Select ]] | ||
| + | * [[dev:odbc:examples:php_select | PHP Simple Connection and Select ]] | ||
| - | Overview | + | ===== JDBC Interface ===== |
| - | What is Omnidex? | + | * [[dev:jdbc:home|JDBC Interface]] |
| - | Omnidex Architecture | + | * [[dev:jdbc:setup|Setting up the JDBC Interface]] |
| - | Quick Start Guide | + | * [[dev:jdbc:usage|Using the JDBC Interface]] |
| - | Using Omnidex: Customer Lists | + | * [[dev:jdbc:examples:home|Examples]] |
| - | Using Omnidex: Business Analytics | + | * [[dev:jdbc:examples:odxtestconnection | Omnidex JDBC Test Connection ]] |
| - | Using Omnidex: Transaction Logs | + | * [[dev:jdbc:examples:simpleselect| Omnidex Simple Select]] |
| - | Using Omnidex: Flat File Databases | + | * [[dev:jdbc:router|The JDBC Intelligent Router]] |
| - | Using Omnidex: Text Databases | + | |
| - | Using Omnidex: Knowledgebases | + | |
| - | Topics | + | ===== RDBMS Integration Stored Procedures ===== |
| - | Fast Counts | + | *[[programs:odxaim:home | Omnidex RDBMS Automatic Index Maintenance ]] |
| - | Fast Aggregations | + | * [[dev:dbprocs:home|Stored Procedures]] |
| - | Textual Searches | + | * [[dev:dbprocs:oracle:home | Oracle ]] |
| - | Portable Snapshots | + | * [[dev:dbprocs:sqlserver:home | SQL Server ]] |
| - | Scalable Grids | + | |
| - | Environment Files | + | |
| - | Administrators | + | ===== Programs and Utilities ===== |
| - | The Omnidex Development and Deployment Lifecycle | + | * [[programs:home | Utilities and Legacy Tools]] |
| - | Development | + | * [[oaenv:home | Environment Catalog Syntax ]] |
| - | Testing | + | * [[programs:oacomp:home|OACOMP]] |
| - | Staging | + | * [[programs:oadecomp:home|OADECOMP]] |
| - | Deployment | + | * [[programs:dbinstal:home|DBINSTAL]] |
| + | * [[programs:oahelper|OAHELPER]] | ||
| + | * [[programs:dsedit:home|DSEdit]] | ||
| + | * [[programs:nsadmin|NSAdmin]] | ||
| + | * [[programs:versions:home|VERSIONS]] | ||
| + | * [[programs:sysinfo|SYSINFO]] | ||
| + | * [[programs:regmaint|REGMAINT]] | ||
| - | Environment Files | + | ===== Appendixes ===== |
| - | Overview | + | * [[appendix:releasenotes | Release Notes]] |
| - | Using Omnidex Administrator to create an Environment File | + | * [[glossary:home | Glossary]] |
| - | Creating an Environment File from an existing RDBMS | + | * [[appendix:docmap|Documentation Map]] |
| - | Creating an Environment File from existing flat files | + | |
| - | Creating an Environment File from scratch | + | |
| - | Using DDL to create an Environment File | + | |
| - | Legacy: Using OACOMP to create an Environment File | + | |
| - | Legacy: Using OAHELPER to create an Environment File | + | |
| - | + | ||
| - | Omnidex Criteria | + | |
| - | Wildcards and Pattern Matching | + | |
| - | Boolean Operators | + | |
| - | Range Operators | + | |
| - | Files Containing Criteria Values | + | |
| - | Synonym Searches | + | |
| - | Thesaurus Searches | + | |
| - | Word Form Searches | + | |
| - | Spellchecked and Misspelling Searches | + | |
| - | Number Transposition Searches | + | |
| - | Phonetic Searches | + | |
| - | Saved Searches | + | |
| - | Multi-Column Index Searches | + | |
| - | Case Sensitivity | + | |
| - | Unicode Datatypes | + | |
| - | + | ||
| - | Textual Searches | + | |
| - | QuickText Indexes and Options | + | |
| - | Effect of Boolean Operators | + | |
| - | Effect of Wildcards and Pattern Matching | + | |
| - | FullText Indexes and Options | + | |
| - | Proximity Operators | + | |
| - | Effect of Boolean Operators | + | |
| - | Effect of Wildcards and Pattern Matching | + | |
| - | Relevancy Scoring | + | |
| - | Retrieval Excerpts | + | |
| - | Indexing External Text Files | + | |
| - | + | ||
| - | Omnidex Indexing Strategies | + | |
| - | Basic Indexing Strategies | + | |
| - | Basic Strategies for Optimizing Criteria | + | |
| - | Omnidex Indexes | + | |
| - | Basic Strategies for Optimizing Aggregations | + | |
| - | Indexing for Aggregations | + | |
| - | Rollup Tables | + | |
| - | Basic Strategies for Optimizing Nested Queries | + | |
| - | Indexing Criteria Columns | + | |
| - | Indexing Select Items | + | |
| - | Basic Strategies for Optimizing Table Joins | + | |
| - | Indexing Primary and Foreign Keys | + | |
| - | + | ||
| - | Advanced Indexing Strategies | + | |
| - | Strategies for Optimizing Complex Criteria | + | |
| - | Multi-component Indexes | + | |
| - | Indexing Expression-based Columns | + | |
| - | Strategies for Optimizing Complex Table Relationships | + | |
| - | Prejoined Indexes | + | |
| - | Multiple-Level Hierarchical Relationships | + | |
| - | Strategies for Optimizing Distinct Count | + | |
| - | Distinct Counts on Primary or Foreign Keys | + | |
| - | Distinct Counts on Other Columns | + | |
| - | Distinct Counts in Omnidex Grids | + | |
| - | Strategies for Optimizing Latitude/Longitude Searches | + | |
| - | Radius Searches from One Set of Coordinates | + | |
| - | Radius Searches from Multiple Sets of Coordinates | + | |
| - | Strategies for Indexing Multiple Columns as a Single Column | + | |
| - | Grouping Columns within One Table | + | |
| - | Grouping Columns within Multiple Tables | + | |
| - | + | ||
| - | Optimizing Query Performance | + | |
| - | Analyzing Query Performance | + | |
| - | Explain Plans | + | |
| - | Options | + | |
| - | [NO]COUNTS | + | |
| - | [NO]SUMMARY | + | |
| - | [NO]DETAILS | + | |
| - | [NO]ADDIN | + | |
| - | [NO]TEXT | + | |
| - | $OX (internal use) | + | |
| - | Summary Section | + | |
| - | Details Section | + | |
| - | Addin Section | + | |
| - | + | ||
| - | Estimating Omnidex Performance | + | |
| - | Estimating Indexing Performance | + | |
| - | Estimating Query Performance | + | |
| - | Estimating Processing of Criteria | + | |
| - | Estimating Processing of Table Joins | + | |
| - | Estimating Process of Nested Queries | + | |
| - | Nested Queries in the Criteria | + | |
| - | Nested Queries in the Table List | + | |
| - | Estimating Processing of Aggregations | + | |
| - | Estimating Processing of Order By | + | |
| - | + | ||
| - | Database Update Strategies | + | |
| - | Batch Indexing | + | |
| - | Incremental Indexing | + | |
| - | Online Updates | + | |
| - | OdxAIM | + | |
| - | Scalability Strategies | + | |
| - | + | ||
| - | RDBMS Topics | + | |
| - | Oracle Topics | + | |
| - | SQL Server Topics | + | |
| - | MySQL Topics | + | |
| - | Generic ODBC Topics | + | |
| - | Stored Procedures (link) | + | |
| - | Triggered Updates (link) | + | |
| - | + | ||
| - | Omnidex Administrator | + | |
| - | [details needed] | + | |
| - | | + | |
| - | OdxSQL | + | |
| - | Overview | + | |
| - | Command-line options | + | |
| - | -help Help | + | |
| - | -version Display the OdxSQL version | + | |
| - | -use=filename Execute statements in named file | + | |
| - | -cmd='cmd1;cmd2' Execute specified statements | + | |
| - | -where='criteria' Apply criteria against directives in use file | + | |
| - | -exit Exit after completion of use file | + | |
| - | -exit_on_error Exit if an error occurs | + | |
| - | -nobanner Do not print the banner | + | |
| - | -cloa Run OdxSQL using the CLOA client interface | + | |
| - | -jdbc Run OdxSQL using the JDBC client interface | + | |
| - | -odbc Run OdxSQL using the ODBC client interface | + | |
| - | -odxnet[=port] Launch an Omnidex Network Services for this session | + | |
| - | + | ||
| - | Commands | + | |
| - | ! Execute a shell command | + | |
| - | . Execute last command | + | |
| - | ; Comment line | + | |
| - | ABORT Cause software abort | + | |
| - | ASSIGNVALUES * Assign values for a $VALUES clause | + | |
| - | ATTACH * Attach an OST file as a table | + | |
| - | 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 DATABASE Create an Omnidex database | + | |
| - | CREATE DIRECTORY Create a directory | + | |
| - | CREATE ENVIRONMENT Create an Omnidex environment | + | |
| - | CREATE FILE Create a file | + | |
| - | CREATE INDEX * Create an Omnidex index | + | |
| - | CREATE INDEXES * Create Omnidex indexes for a database | + | |
| - | 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 DATABASE Drop an Omnidex database | + | |
| - | DROP ENVIRONMENT Drop an Omnidex environment | + | |
| - | DROP INDEX Drop an Omnidex index | + | |
| - | DROP INDEXES * Drop Omnidex indexes for a database | + | |
| - | 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 | + | |
| - | EXECSQL Execute statement through oaexecsql | + | |
| - | EXIT Exit Omnidex SQL | + | |
| - | 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 Help | + | |
| - | HELPER * Access oahelper utilities | + | |
| - | 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 tables using Omnidex | + | |
| - | LOAD OFX * Load indexes for a table | + | |
| - | LOOKUP Look up text metadata | + | |
| - | MESSAGE Display an environment catalog message | + | |
| - | NETWORKACCESS Execute an Omnidex network access command | + | |
| - | 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 Omnidex SQL | + | |
| - | 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 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 | + | |
| - | SLEEP Sleep for a specified number of seconds | + | |
| - | SORTMERGE Sort/merge test system | + | |
| - | UPDATE * Issue an SQL update statement | + | |
| - | UPDATE INDEXES * Update Omnidex indexes | + | |
| - | UPDATE ROLLUP * Update rollup table | + | |
| - | UPDATE ROLLUPS * Update rollup tables | + | |
| - | UPDATE STATISTICS * Update statistical information | + | |
| - | UPDATE TEXT * Update textual statistics | + | |
| - | 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 | + | |
| - | n Execute numbered command | + | |
| - | n: Send command to ODXSQL subprocess | + | |
| - | + | ||
| - | Omnidex Network Services | + | |
| - | Overview | + | |
| - | Command-line options | + | |
| - | [details needed] | + | |
| - | Configuration file | + | |
| - | [details needed] | + | |
| - | + | ||
| - | Utilities (later renamed to Legacy Tools) | + | |
| - | OACOMP/OADECOMP | + | |
| - | Environment File Syntax | + | |
| - | DBINSTAL | + | |
| - | OAHELPER | + | |
| - | DSEdit | + | |
| - | OdxQuery | + | |
| - | NSAdmin | + | |
| - | VERSIONS | + | |
| - | SYSINFO | + | |
| - | REGMAINT | + | |
| - | + | ||
| - | Administrator FAQ | + | |
| - | + | ||
| - | Developers | + | |
| - | Omnidex SQL Reference | + | |
| - | ASSIGNVALUES Assign values for a $VALUES clause | + | |
| - | ATTACH Attach an OST file as a table | + | |
| - | CLOSE CURSOR Close a cursor | + | |
| - | COMMAND Execute a shell command via $COMMAND table | + | |
| - | CONNECT Connect to an environment file | + | |
| - | CREATE DATABASE Create an Omnidex database | + | |
| - | CREATE DIRECTORY Create a directory | + | |
| - | CREATE ENVIRONMENT Create an Omnidex environment | + | |
| - | CREATE FILE Create a file | + | |
| - | CREATE INDEX Create an Omnidex index | + | |
| - | CREATE INDEXES Create Omnidex indexes for a database | + | |
| - | CREATE TABLE Create a table | + | |
| - | DELETE Issue an SQL delete statement | + | |
| - | DELETEINDEX Delete values directly from Omnidex indexes | + | |
| - | DETACH Detach a previously attached OST file | + | |
| - | DISCONNECT Disconnect from an environment file | + | |
| - | DROP DATABASE Drop an Omnidex database | + | |
| - | DROP ENVIRONMENT Drop an Omnidex environment | + | |
| - | DROP INDEX Drop an Omnidex index | + | |
| - | DROP INDEXES Drop Omnidex indexes for a database | + | |
| - | DROP TABLE Drop a table | + | |
| - | EXPORT Export records to a file | + | |
| - | HELPER Access oahelper utilities | + | |
| - | INSERT Issue an SQL insert statement | + | |
| - | INSERTINDEX Insert values directly into Omnidex indexes | + | |
| - | JOIN Join tables using Omnidex | + | |
| - | LOAD OFX Load indexes for a table | + | |
| - | OPEN CURSOR Open a cursor | + | |
| - | PARTITION Partition a table | + | |
| - | QUALIFY Qualify rows using Omnidex | + | |
| - | SELECT Issue an SQL select statement | + | |
| - | SET Set an option | + | |
| - | UPDATE Issue an SQL update statement | + | |
| - | UPDATE INDEXES Update Omnidex indexes | + | |
| - | UPDATE ROLLUP Update rollup table | + | |
| - | UPDATE ROLLUPS Update rollup tables | + | |
| - | UPDATE STATISTICS Update statistical information | + | |
| - | UPDATE TEXT Update textual statistics | + | |
| - | UPDATEINDEX Update values directly in Omnidex indexes | + | |
| - | VERSION Display current software versions | + | |
| - | + | ||
| - | ODBC Interface | + | |
| - | Setting up the ODBC Interface | + | |
| - | Using the ODBC Interface | + | |
| - | (details needed) | + | |
| - | Examples | + | |
| - | + | ||
| - | JDBC Interface | + | |
| - | Setting up the JDBC Interface | + | |
| - | Using the JDBC Interface | + | |
| - | (details needed) | + | |
| - | Examples | + | |
| - | The JDBC Intelligent Router | + | |
| - | (insert technote here) | + | |
| - | + | ||
| - | Stored Procedures | + | |
| - | Oracle | + | |
| - | SQL Server | + | |
| - | + | ||
| - | Legacy API's | + | |
| - | OmniAccess | + | |
| - | (insert legacy documentation here) | + | |
| - | + | ||
| - | Client OmniAccess | + | |
| - | (insert legacy documentation here) | + | |
| - | + | ||
| - | ImagePlus | + | |
| - | (insert legacy documentation here) | + | |
| - | + | ||
| - | Developer FAQ | + | |
| - | + | ||
| - | + | ||
| - | General | + | |
| - | Software Installation | + | |
| - | Platform Support | + | |
| - | Release Notes | + | |
| - | Migration From Earlier Versions | + | |
| - | Glossary | + | |
| - | Documentation Map | + | |
| - | Installation FAQ | + | |
| - | </code> | + | |
| - | + | ||
| - | + | ||
| - | ====== Quick Links ====== | + | |
| - | {{page>:quicklinks&nofooter&noeditbtn}} | + | |