Contents
Home
Quick Links
What's New
Appendix
 Cardinality
Date
Formats
Environment
Variables
File
Name Handling
Glossary
- A B
C D
E F
G H
I J
K L
M N
O P
Q R
S T
U V
W X
Y Z
Null
Operating
Limits
Reserved
Words
Supported
Data types
Database
Platforms
Relational
Databases
ODBC
Gateway
Multiple
Databases
DB2
Flat
Files
Omnidex
Stand-Alone Tables
Tab-Delimited
Files
Environment
File
Oracle
SQLNET
SQL
Server
Environment
Catalog
Index
Design & Installation
Development
Debugging
- OMNIDEX_DEBUG
JDBC
Minimum
Retrieval Example
ODBC
OmniAccess
API
Programming
Basics
Managing
Data
Functions
OAASSIGNVALUES
OABEGIN
OABIND
OACLOSECURSOR
OACOMMAND
OACOMMIT
OACONNECT
OADEBUG
OADELETE
OADELETEINDEX
OADELETEWHERE
OADESCRIBE
OADISCONNECT
OAERROR
OAEXECSQL
OAEXPLAINPLAN
OAEXPORT
OAEXTERNAL
OAFETCH
OAFETCHKEYS
OAINDEXINFO
OAINSERT
OAINSERTINDEX
OAJOIN
OAMESSAGE
OAOPENCURSOR
OAQUALIFY
OAROLLBACK
OASAVEPOINT
OASELECT
OASTATEMENTINFO
OAUPDATE
OAUPDATEINDEX
OAUPDATEWHERE
OAVERSION
Third
Party Applications
MS
Access
MS
Excel
Environment
Catalog
Column
Statement
Database
Statement
Environment
Statement
Index
Statement
Message
Statement
Rule
Statement
Table
Statement
Getting Started
Step
1 - Software Installation and Setup
Step
2 - Account Verification
Step
3 - Index Design
Step
4 - Environment Catalog
Step
5 - Index Installation
Step
6 - Index Maintenance
Step
7 - Test the Installation
Step
8 - Application Development
Step
9 - Debugging
HPUX
Server Setup Guide
Step
1 - Create the Software Environment
Step
2 - Restore the Software
Step
3 - Build the Omnidex Executables
Step
4 - License the Software
IBM
AIX Server Setup Guide
Step
1 - Create the Software Environment
Step
2 - Restore the Software
Step
3 - Build the Omnidex Executables
Step
4 - License the Software
Linux
Server Setup Guide
Step
1 - Create the Software Environment
Step
2 - Restore the Software
Step
3 - Build the Omnidex Executables
Step
4 - License the Software
Sun
Solaris Server Setup Guide
Step
1 - Create the Software Environment
Step
2 - Restore the Software
Step
3 - Build the Omnidex Executables
Step
4 - License the Software
Tru64
(OSF) Server Setup Guide
Step
1 - Create the Software Environment
Step
2 - Restore the Software
Step
3 - Build the Omnidex Executables
Step
4 - License the Software
Windows
Server Setup Guide
Windows
Client Setup
Non-Windows
Client Setup (Unix, IBM AIX, Linux, Sun Solaris, Tru64 (OSF) )
Omnidex Concepts
Features
$VALUES
AUTOPSEUDOCOLUMNS
Exporting
Data
FOR
UPDATE
Keyword
Searches
Omnidex
Sentinel Character
Proximity
Searches
Pseudocolumns
Redefined
Rowids
Software
Interrupts
Software
Timeouts
Synonym
Searches
Index
Maintenance
Installing
the Indexes
Building
the Indexes
Updating
the Indexes
Indexing
Options
ASK
Indexes
Bitmap
Indexes
Composite
Indexes
Excluded
Words
MDK
Indexes
Special
Characters
Translation
Table
Proximity
Indexes
Indexing
Strategies
Domains
DR
Domain
Omnidex
IDs by Domain
Sorted
Multi-Find
Optimization
Explain
Plan
Nested
Queries
Partitioning
Step
1 - Analysis
Step
2 - Partition the Table
Step
3 - Environment File Entry
Step
4 - Indexing
Examples
- Partitioning
Examples
- Partitioning
Examples
- Environment File
Examples
- Indexing
Omnidex
Text
External
Documents
$RETRIEVE_FILE
SQL Reference
Joins
Nested
Queries
SET
Operations
WITH
Options
ON
CURSOR | ON INSTANCE
SELECT
Statement
SELECT
List
FROM
Clause
WHERE
Clause
GROUP
BY Clause
ORDER
BY Clause
Criteria
Conditioning
Examples
Commands
ASSIGNVALUES
ATTACH
CLOSE
CURSOR
CONNECT
CREATE
TABLE
DELETE
DELETEINDEX
DETACH
DISCONNECT
DROP
TABLE
EXPORT
INSERT
INSERTINDEX
JOIN
OPEN
CURSOR
QUALIFY
SELECT
UPDATE
UPDATEINDEX
VERSION
Functions
CASE
CAST
CHAR_LENGTH
| CHARACTER_LENGTH
||
(Concatenation)
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
EXTRACT
LOWER
POSITION
SUBSTRING
SESSION_USER
SYSTEM_USER
TRIM
UPPER
USER
$COL_LEN
| $COLUMN_LENGTH
$CONVERT
$CURRENT_ROW
$EXTERNAL
$IFNULL
$LJ
$LPAD
$MOD
$PROPER
$RANDOM
$RJ
$ROUND
$RPAD
$SOUNDEX
$TRUNC
Utilities
DBINSTAL
Program
Operation
Commands
Indexing
Options
DSEDIT
Create a Data Source
Edit a Data Source
Test a Connection
Check the Server
Data Source Type
Data Souce Name
Environment Info
Server / Host
ODBC Options
Sample Data Source
NSADMIN
Client
Details
OACOMP
Phases
OADECOMP
OAHELPER
Generate
an Environment Source File
Generate
an Installation Script
Generate
a Migration Script
ODXAIM
Syntax
Setup
AIM
Table (ODXTRANS)
Configuration
File
Sample
Script File
ODXMAKE
ODXNET
Syntax
Interactive
Process
Windows
Service
Configuration
File
ODXQUERY
ODXSQL
USE
Files
Commands
ABORT
BIND
CD
COPY
CREATE
FILE
DATE
DESCRIBE
DIR
EDIT
EXPLAIN
EXTRACT
FETCH
FETCHKEYS
FLIP
GETENV
HELP
HISTORY
PARTITION
PWD
SAVE
HISTORY
SAVE
SETTINGS
SET
AUTODISPLAY
AUTOEXPLAIN
AUTOFETCH
AUTOPSEUDOCOLUMNS
CHAR
CURSOR
CURSORDISPLAY
DEFAULTS
EDITOR
ENDIAN
ERRORDISPLAY
ERRORS
EXPLAIN
HEX
HISTORY
INSTANCE
INTERRUPTS
NULL_INDICATORS
OMNIDEX_DEBUG
OPTIMIZATION
PAGELENGTH
PAGEWIDTH
PREPROCESSOR
PROMPT
QUALIFY_COUNTS
TIMER
SETENV
UPDATE
STATISTICS
USE
VIEW
REGMAINT
REGTEST
SNOWGEN
SYSINFO
VERSIONS
VIEWGEN
Top
|
