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
appendix:docmap [2009/11/13 21:59]
admin
appendix:docmap [2012/10/26 14:46] (current)
Line 1: Line 1:
-====== Omnidex Version 5.0 ======+====== Omnidex Version 5.1 Table of Contents ​======
  
-=== Table of Contents ​=== +===== Overview ===== 
-  ​- Overview +  - [[overview:​omnidex|What is Omnidex?​]] 
-    ​- [[overview:​omnidex|What is Omnidex?​]] +  - Using Omnidex 
-    - [[overview:​architecture|Omnidex ​Architecture]] +    ​* [[overview:lists|Using Omnidex: Database Marketing and Customer Lists]] 
-    ​- [[overview:quickstart|Quick Start Guide]] +    ​* [[overview:analytics|Using Omnidex: ​Business Analytics and Data Warehouses]] 
-    ​- [[overview:lists|Using Omnidex: ​Customer Lists]] +    ​* [[overview:onlinedb|Using Omnidex: ​Online, Searchable Databases]] 
-    ​- [[overview:analytics|Using Omnidex: ​Business Analytics]] +    ​* [[overview:flatfiles|Using Omnidex: Transaction Logs and Raw Data Files]] 
-    ​- [[overview:transactions|Using Omnidex: Transaction Logs]] +    ​* [[overview:largedb|Using Omnidex: ​Billion-record ​Databases]] 
-    ​- [[overview:flatfiles|Using Omnidex: ​Flat File Databases]] +    ​* [[overview:​text|Using Omnidex: ​Knowledgebases and Text Databases]] 
-    ​- [[overview:​text|Using Omnidex: Text Databases]] +  - [[overview:architecture|Omnidex ​Architecture]] 
-    - [[overview:knowledgebases|Using Omnidex: Knowledgebases]] +  - [[overview:quickstart|Quick Start Guide]] 
-  ​- Topics + 
-    ​- [[admin:counts:​overview|Fast Counts]] +===== Administration ===== 
-    - [[admin:aggregations:​overview|Fast Aggregations]] +  ​- [[admin:home|Omnidex Administration]]  
-    - [[admin:text:​overview|Textual Searches]] +  - [[admin:topics|General Topics]] 
-    ​- [[admin:snapshots:overview|Portable Snapshots]] +    ​* [[admin:applications:home|Building Omnidex Applications]] 
-    ​- [[admin:grid:overview|Scalable Grids]] +    ​* [[admin:architecture:home|Omnidex Architecture]] 
-    ​- [[admin:​environments:​overview|Environment Files]] +    ​* [[admin:​environments:​home|Connecting Omnidex to your Data]] 
-  - Adminstrators +    ​* [[admin:indexing:home|Omnidex Indexing Features]] 
-    ​- [[admin:lifecycle:overview|The Omnnidex Development and Deployment Lifecycle]] +    * [[admin:snapshots:home|Omnidex Snapshots]] 
-      * [[admin:lifecycle:design|Design]] +    * [[admin:grids:home|Omnidex Grids]] 
-      * [[admin:lifecycle:development|Development]] +    * [[admin:optimization:home|Optimizing Queries]] 
-      * [[admin:lifecycle:testing|Testing]] +    * [[admin:monitoring:home|Monitoring Omnidex Applications]] 
-      * [[admin:lifecycle:staging|Staging]] +    * [[admin:updates:home|Updating your Omnidex Database]] 
-      * [[admin:lifecycle:deployment|Deployment]] +    * [[admin:rdbms:home|Integrating with Relational Databases]] 
-      * [[admin:lifecycle:optimization|Optimization]] +  - [[admin:​environments:​home|Environment Files]] 
-    - Environment Files +    * [[admin:​environments:​overview|Overview]]
-      * [[admin:​environments:​overview|Overview]]+
       * [[admin:​environments:​create:​overview]Creating Environment Files       * [[admin:​environments:​create:​overview]Creating Environment Files
-        * [[admin:​environments:​create:​odxadmin|Using Omnidex Administrator to create an Environment File]] 
-        * [[admin:​environments:​create:​sql|Using SQL Statements to create an Environment File]] 
-        * [[admin:​environments:​create:​rdbms|Creating an Environment File from an existing RDBMS]] 
-        * [[admin:​environments:​create:​flatfiles|Creating an Environment File from existing flat files]] 
-        * [[admin:​environments:​create:​oacomp|Creating an Environment File using OACOMP]] 
-          * [[admin:​environments:​create:​oacomp:​syntax|Environment File Syntax]] 
-        * [[admin:​environments:​create:​oahelper|Creating an Environment File using OAHELPER]] 
       * [[admin:​environments.datatypes|Datatypes]]       * [[admin:​environments.datatypes|Datatypes]]
       * [[admin:​environments.constraints|Constraints]]       * [[admin:​environments.constraints|Constraints]]
-      * [[admin:​environments.names|Naming Conventions]] +  ​- [[admin:​criteria:​home|Omnidex Criteria]] 
-    ​- [[admin:​criteria:​overview|Omnidex Criteria]] +    * [[admin:​criteria:​wildcards|Wildcards and Pattern Matching]] 
-      * [[admin:​criteria:​wildcards|Wildcards and Pattern Matching]] +    * [[admin:​criteria:​case|Case Sensitivity]] 
-      * [[admin:​criteria:​case|Case Sensitivity]] +    * [[admin:​criteria:​booleans|Boolean Operators]] 
-      * [[admin:​criteria:​booleans|Boolean Operators]] +    * [[admin:​criteria:​ranges|Range Operators]] 
-      * [[admin:​criteria:​ranges|Range Operators]] +    * [[admin:​criteria:​files|Files Containing Criteria Values]] 
-      * [[admin:​criteria:​files|Files Containing Criteria Values]] +    * [[admin:​criteria:​synonyms|Synonym Searches]] 
-      * [[admin:​criteria:​synonyms|Synonym Searches]] +    * [[admin:​criteria:​thesaurus|Thesaurus Searches]] 
-      * [[admin:​criteria:​thesaurus|Thesaurus Searches]] +    * [[admin:​criteria:​forms|Word Form Searches]] 
-      * [[admin:​criteria:​forms|Word Form Searches]] +    * [[admin:​criteria:​spelling|Spellchecked and Misspelling Searches]] 
-      * [[admin:​criteria:​spelling|Spellchecked and Misspelling Searches]] +    * [[admin:​criteria:​transposition|Number Transposition Searches]] 
-      * [[admin:​criteria:​transposition|Number Transposition Searches]] +    * [[admin:​criteria:​phonetic|Phonetic Searches]] 
-      * [[admin:​criteria:​phonetic|Phonetic Searches]] +    * [[admin:​criteria:​savesearch|Saved Searches]] 
-      * [[admin:​criteria:​savesearch|Saved Searches]] +    * [[admin:​criteria:​multicolumn|Multi-Column Index Searches]] 
-      * [[admin:​criteria:​multicolumn|Multi-Column Index Searches]] +    * [[admin:​criteria:​unicode|Unicode Datatypes]] 
-      * [[admin:​criteria:​unicode|Unicode Datatypes]] +  - [[admin:​text:​home|Textual Searches]] 
-    - [[admin:​text:​overview|Textual Searches]] +    * [[admin:​text:​quicktext:​overview|QuickText Indexes and Options]] 
-      * [[admin:​text:​quicktext:​overview|QuickText Indexes and Options]] +      * [[admin:​text:​quicktext:​boolean|Effect of Boolean Operators]] 
-        * [[admin:​text:​quicktext:​boolean|Effect of Boolean Operators]] +      * [[admin:​text:​quicktext:​wildcards|Effect of Wildcards and Pattern Matching]] 
-        * [[admin:​text:​quicktext:​wildcards|Effect of Wildcards and Pattern Matching]] +    * [[admin:​text:​fulltext:​home|FullText Indexes and Options]] 
-      * [[admin:​text:​fulltext:​overview|FullText Indexes and Options]] +      * [[admin:​text:​fulltext:​proximity|Proximity Operators]] 
-        * [[admin:​text:​fulltext:​proximity|Proximity Operators]] +      * [[admin:​text:​fulltext:​boolean|Effect of Boolean Operators]] 
-        * [[admin:​text:​fulltext:​boolean|Effect of Boolean Operators]] +      * [[admin:​text:​fulltext:​wildcards|Effect of Wildcards and Pattern Matching]] 
-        * [[admin:​text:​fulltext:​wildcards|Effect of Wildcards and Pattern Matching]] +      * [[admin:​text:​fulltext:​relevancy|Relevancy Scoring]] 
-        * [[admin:​text:​fulltext:​relevancy|Relevancy Scoring]] +      * [[admin:​text:​fulltext:​excerpts|Retrieval Excerpts]] 
-        * [[admin:​text:​fulltext:​excerpts|Retrieval Excerpts]] +      * [[admin:​text:​fulltext:​external|Indexing External Text Files]] 
-        * [[admin:​text:​fulltext:​external|Indexing External Text Files]] +  - [[admin:​indexing:​home|Indexing Strategies]] 
-    - Omnidex Indexing Strategies +    * [[admin:​indexing:​strategies:​home|Basic ​Indexing ​Strategies]] 
-      * [[nopage|Basic Indexing Strategies]] +      * [[admin:​indexing:​strategies:​criteria|Optimizing Criteria]] 
-      * [[nopage|Basic Strategies ​for Optimizing Criteria]] +      * [[admin:​indexing:​strategies:​aggregations|Optimizing Aggregations]] 
-        * [[nopage|Omnidex Indexes]] +      * [[admin:​indexing:​strategies:​nested|Optimizing Nested Queries]] 
-      * [[nopage|Basic Strategies for Optimizing Aggregations]] +      * [[admin:​indexing:​strategies:​joins|Optimizing Table Joins]] 
-        * [[nopage|Indexing for Aggregations]] +    * [[admin:​indexing:​advanced:​overview|Advanced ​Indexing ​Strategies]] 
-        * [[nopage|Rollup Tables]] +      * [[admin:​indexing:​advanced:​criteria|Optimizing Complex Criteria]] 
-      * [[nopage|Basic Strategies for Optimizing Nested Queries]] +      * [[admin:​indexing:​advanced:​joins|Optimizing Complex Table Relationships]] 
-        * [[nopage|Indexing Criteria Columns]] +      * [[admin:​indexing:​advanced:​distinct|Optimizing Distinct Counts]] 
-        * [[nopage|Indexing ​Select Items]] +      * [[admin:​indexing:​advanced:​geosearch|Optimizing Latitude/​Longitude Searches]] 
-    - Advanced Indexing Strategies +      * [[admin:​indexing:​advanced:​grouping|Indexing Multiple Columns as a Single Column]] 
-      * [[nopage|Strategies for Optimizing Complex Criteria]] +    * [[admin:​indexing:​explain|Analyzing the Query Plan]] 
-        * [[nopage|Multi-component Indexes]] +  - [[admin:​updates:​home|Database Update Strategies]] 
-        * [[nopage|Indexing Expression-based Columns]] +    * [[admin:​updates:​batch|Batch Indexing]] 
-      * [[nopage|Strategies for Optimizing Complex Table Relationships]] +    * [[admin:​updates:​incremental|Incremental Indexing]] 
-        * [[nopage|Prejoined Indexes]] +    * [[admin:​updates:​online|Online Updates]] 
-        * [[nopage|Multiple-Level Hierarchical ​Relationships]] +    * [[admin:​updates:​triggers|Triggered Updates]] 
-      * [[nopage|Strategies for Optimizing Distinct Counts]] +    * [[admin:​updates:​scalability|Scalability Strategies]] 
-        * [[nopage|Distinct Counts on Primary or Foreign Keys]] +  ​- ​[[admin:​rdbms:​overview|RDBMS Topics]] 
-        * [[nopage|Distinct Counts on Other Columns]] +    * [[admin:​rdbms:​oracle:​overview|Oracle]] 
-        * [[nopage|Distinct Counts in Omnidex Grids]] +    * [[admin:​rdbms:​sqlserver:​overview|SQL Server]] 
-      * [[nopage|Strategies for Optimizing Latitude/​Longitude Searches]] +    * [[admin:​rdbms:​mysql|MySQL]] 
-        * [[nopage|Radius Searches from One Set of Coordinates]] +    * [[admin:​rdbms:​odbc|Generic ​ODBC]] 
-        * [[nopage|Radius Searches from Multiple Sets of Coordinates]] +    * [[dev:​procedures:​overview|Stored Procedures]] 
-      * [[nopage|Strategies for Indexing Multiple Columns as a Single Column]] +    * [[admin:updates:triggers|Triggered Updates]] 
-        * [[nopage|Grouping Columns within One Table]] +  - [[admin:faq|Administrator FAQ]]
-        * [[nopage|Grouping Columns within Multiple Tables]] +
-  - Developers +
-    - Omnidex SQL Reference +
-      * [[nopage|ASSIGNVALUES]]<​tab><​tab> ​      ​Assign values for a $VALUES clause +
-      * [[nopage|ATTACH]]<​tab><​tab><​tab> ​       Attach an OST file as a table +
-      * [[nopage|CLOSE CURSOR]]<​tab><​tab> ​      Close a cursor +
-      * [[nopage|COMMAND]]<​tab><​tab><​tab> ​      ​Execute a shell command via $COMMAND table +
-      * [[nopage|CONNECT]]<​tab><​tab><​tab> ​      ​Connect to an environment file +
-      * [[nopage|CREATE DATABASE]]<​tab><​tab> ​   Create an Omnidex database +
-      ​* [[nopage|CREATE DIRECTORY]]<​tab><​tab> ​  ​Create a directory +
-      ​* ​[[nopage|CREATE ENVIRONMENT]]<​tab><​tab>​ 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]] +
- +
- +
-<​code>​  +
-Documentation Map for Omnidex 5.n +
- +
-The following is a draft documentation map for the Omnidex 5.n documentation. ​  +
- +
-Table of Contents +
- +
-Overview +
-  What is Omnidex? +
-  Omnidex Architecture +
-  Quick Start Guide +
-  Using Omnidex: Customer Lists +
-  Using Omnidex: Business Analytics +
-  Using Omnidex: Transaction Logs +
-  Using Omnidex: Flat File Databases +
-  Using Omnidex: Text Databases +
-  Using Omnidex: Knowledgebases +
- +
-Topics +
-  Fast Counts +
-  Fast Aggregations +
-  Textual Searches +
-  Portable Snapshots +
-  Scalable Grids +
-  Environment Files +
- +
-Administrators +
-  The Omnidex Development and Deployment Lifecycle +
-    Development +
-    Testing +
-    Staging +
-    Deployment +
- +
-  Environment Files +
-    Overview +
-    Using Omnidex Administrator to create an Environment File +
-    Creating an Environment File from an existing RDBMS +
-    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 +===== Development ===== 
-    ​Oracle +==== Omnidex SQL Reference ==== 
-    SQL Server+=== Overview === 
 +    ​- [[dev:​sql:​overview|Omnidex SQL Reference]] 
 +=== SQL Statements === 
 +    ​- [[dev:​sql:​statements:​home | Omnidex ​SQL Statements ]] 
 +=== SQL Functions === 
 +      * [[dev:​sql:​functions:​home | Omnidex SQL Function List ]] 
 +=== SQL Examples === 
 +      * [[dev:​sql:​examples:​home | Omnidex SQL Examples ]] 
 +==== 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 ]] 
 +==== JDBC Interface ==== 
 +    - [[dev:​jdbc:​home|JDBC Interface]] 
 +      * [[dev:​jdbc:​setup|Setting up the JDBC Interface]] 
 +      * [[dev:​jdbc:​usage|Using the JDBC Interface]] 
 +      * [[dev:​jdbc:​examples:​home|Examples]] 
 +        * [[dev:​jdbc:​examples:​odxtestconnection | Omnidex JDBC Test Connection ]] 
 +        * [[dev:​jdbc:​examples:​simpleselect| Omnidex Simple Select]] 
 +      * [[dev:​jdbc:​router|The JDBC Intelligent Router]]
  
-  Legacy API's +==== Stored Procedures ==== 
-    ​OmniAccess +    ​- [[dev:​dbprocs:​home|Stored Procedures]] 
-      ​(insert legacy documentation here)+      ​* [[dev:​dbprocs:​oracle:​home | Oracle ]] 
 +      * [[dev:​dbprocs:​sqlserver:​home | SQL Server ]]
  
-  ​Client OmniAccess +==== APIs ==== 
-    ​(insert legacy documentation here)+    - [[dev:​api:​overview|API'​s]] 
 +      * [[dev:​api:​oa:​overview|OmniAccess]] 
 +      * [[dev:​api:​cloa:​overview|Client OmniAccess]] 
 +==== Developer FAQ ==== 
 +    ​- [[dev:​faq|Developer FAQ]]
  
-  ImagePlus +===== Programs ===== 
-    ​(insert legacy documentation here)+==== Omnidex Administrator ==== 
 +    ​- [[programs:​odxadmin:​home|Omnidex Administrator]]
  
-  Developer FAQ+==== OdxSQL Interactive Omnidex SQL ====
  
 +=== Overview ===
 +    - [[programs:​odxsql:​overview|Overview]]
 +=== Command Line Options ===
 +      * [[programs:​odxsql:​commandline|Command-line options]]
 +=== Commands ===
 +    - [[programs:​odxsql:​commands:​home | Commands ]]
 +      ​
 +==== OdxNet - Network Services ====
 +    - [[programs:​odxnet:​home|Omnidex Network Services]]
 +      * [[programs:​odxnet:​commandline|Command-line options]]
 +      * [[programs:​odxnet:​config|Configuration file]]
  
-General +==== OdxAim - RDBMS Automatic Index Maintenance ==== 
-  ​Software Installation +    - [[programs:​odxaim:​home | Omnidex RDBMS Automatic Index Maintenance ]] 
-  ​Platform Support +==== Utilities and Legacy Tools ==== 
-  ​Release Notes +    - [[programs:​home | Utilities and Legacy Tools]] 
-  ​Migration From Earlier Versions +      * [[oaenv:​home | Environment Catalog Syntax ]] 
-  ​Glossary +      * [[programs:​oacomp:​home|OACOMP]] 
-  ​Documentation Map +      * [[programs:​oadecomp:​home|OADECOMP]] 
-  ​Installation FAQ +      * [[programs:​dbinstal:​home|DBINSTAL]] 
-</​code>​+      * [[programs:​oahelper|OAHELPER]] 
 +      * [[programs:​dsedit:​home|DSEdit]] 
 +      * [[programs:​nsadmin|NSAdmin]] 
 +      * [[programs:​versions:​home|VERSIONS]] 
 +      * [[programs:​sysinfo|SYSINFO]] 
 +      * [[programs:​regmaint|REGMAINT]]
  
 +===== Application Integration =====
 +    - [[integration:​generalodbc | General ODBC Integration]] ​
 +    - [[integration:​excel] ​
 +    - [[integration:​business_objects|Business Objects]]
 +    - [[integration:​microstrategy|Microstrategy DSS Agent]]
  
-====== Quick Links ======  +===== Appendixes ​===== 
-{{page>:quicklinks&​nofooter&​noeditbtn}}+    - [[appendix:​install:​overview|Software Installation]] 
 +    - [[appendix:​platform|Platform Support]] 
 +    - [[appendix:​releasenotes | Release Notes]] 
 +    - [[appendix:​migration|Migration From Earlier Versions]] 
 +    - [[glossary:​home | Glossary]] 
 +    - [[appendix:​docmap|Documentation Map]] 
 +    - [[appendix:|Installation FAQ]]
 
Back to top
appendix/docmap.1258149592.txt.gz · Last modified: 2012/10/26 14:40 (external edit)