Index

O

object-oriented programming : Java Object oriented and procedural languages
object-oriented programming : style Public fields
objects : class versions Java objects and class versions
objects : inserting Inserting and retrieving objects
objects : Java Java classes and objects
objects : qualified names Database object names and prefixes
objects : querying Creating distributed applications
objects : replication Java objects and class versions
objects : retrieving Inserting and retrieving objects
objects : storage format Updating classes and Jars
objects : storage of Java How Java objects are stored
objects : types Java classes and objects
objects : unloading and reloading Java objects and class versions
occasionally connected users : replicating data and concurrency Replication and concurrency
ODBC : Administrator Creating an ODBC data source
ODBC : applications Setting the isolation level from an ODBC-enabled application
ODBC : applications, and locking Setting the isolation level from an ODBC-enabled application
ODBC : connections Introduction to connections
ODBC : cursor types Availability of cursors
ODBC : data sources Working with ODBC data sources
Deploying connection information
ODBC : deploying Deploying ODBC clients
ODBC : driver deployment ODBC driver required files
ODBC : driver location Locating the interface library
ODBC : external servers Defining ODBC external servers
ODBC : initialization file for UNIX Using ODBC data sources on UNIX
ODBC : registry entries Deploying connection information
ODBC : SQL statements Executing SQL statements in applications
ODBC : translation driver ODBC code page translation
ODBC : UNIX support Using ODBC data sources on UNIX
ODBC : Windows CE Using ODBC data sources on Windows CE
ODBC data sources : UNIX Using ODBC data sources on UNIX
odbc server class Server class odbc
ODBC server classes ODBC-based server classes
ODBC settings : deploying Deploying ODBC clients
Deploying connection information
ODI : compatibility Working with multiple protocol stacks
ODI : drivers Ensure that you have current drivers
ODI : network communication The data link layer
ODI drivers Ensure that you have current drivers
ODI2NDI translation driver Working with multiple protocol stacks
ODIHLP translation driver Working with multiple protocol stacks
ODINSUP translation driver Working with multiple protocol stacks
OEM code pages : about Code pages in Windows and Windows NT
OEM code pages : choosing ANSI or OEM?
offline backups : defined Backing up your database
OmniConnect : support Sybase applications and Adaptive Server Anywhere
ON EXCEPTION RESUME clause : about Error handling with ON EXCEPTION RESUME
ON EXCEPTION RESUME clause : not with exception handling Using exception handlers in procedures and triggers
ON EXCEPTION RESUME clause : Transact-SQL Transact-SQL-like error handling in the Watcom-SQL dialect
ON phrase : joining tables Joins using comparisons
one-to-many relationships : definition of Relationships
one-to-many relationships : resolving Step 4: Resolve the relationships
one-to-one relationships : definition of Relationships
one-to-one relationships : resolving Step 4: Resolve the relationships
online backups : defined Backing up your database
Open Client : configuring Configuring Open Servers with DSEDIT
Open Client : cursor types Availability of cursors
Open Client : deploying Deploying Open Client applications
Open Client : interface Open Clients, Open Servers, and TDS
Open Client : SQL statements Executing SQL statements in applications
Open Server : address Adding or changing the server address
Open Server : architecture Open Clients, Open Servers, and TDS
Open Server : starting Starting the database server as an Open Server
Open Server : system requirements System requirements
Open Servers : adding Configuring Open Servers with DSEDIT
Set up the Open Servers in your system
Open Servers : connecting to Confirm the Open Servers are configured properly
OPEN statement : procedures Cursor management overview
operating system : file names File naming conventions
operators : arithmetic Computing values in the select list
operators : NOT keyword Using comparison operators in the WHERE clause
operators : precedence Computing values in the select list
optimization of queries : about CHAPTER 25. Query Optimization
optimization of queries : assumptions Underlying assumptions
optimization of queries : reading access plans Reading access plans
optimization of queries : rewriting sub-queries as EXISTS predicates Rewriting sub-queries as exists predicates
optimization of queries : steps in Steps in optimization
optimizations : using indexes Special optimizations
optimizer : about How the optimizer works
CHAPTER 25. Query Optimization
optimizer : assumptions Underlying assumptions
optimizer : predicate analysies Predicate analysis
optimizer : role of The role of the optimizer
optimizer : selectivity estimation Selectivity estimation
optimizer : semantic subquery transformations Semantic query transformations
optional foreign keys Enforcing referential integrity
optional relationships Relationships
options : BLOCKING The BLOCKING option
options : ISOLATION_LEVEL Setting the isolation level
options : Open Client Characteristics of Open Client and jConnect connections
options : startup settings Characteristics of Open Client and jConnect connections
or (|) bitwise operator : using Connecting conditions with logical operators
Oracle : remote data access Server class oraodbc
oraodbc server class Server class oraodbc
ORDER BY clause : GROUP BY ORDER BY and GROUP BY
ORDER BY clause : Java columns Comparing Java objects
ORDER BY clause : limiting results Retrieving the first few rows of a query
ORDER BY clause : performance Sorting query results
ordering : Java objects Comparing Java fields and objects
ordering of transactions Correctness
ordering query results : in a cursor Cursor stability
organization : of data, physical Physical data organization and access
orphan and referential integrity Locking during inserts
OS/2 : database server Platform-specific instructions
OSI Reference Model : protocol stacks The protocol stack
out of memory error : database server cache Starting the server for a Java-enabled database
outer join operators : Transact-SQL Compatibility of joins
outer joins : FROM clause Inner, left-outer, and right-outer joins
outer joins : join conditions Outer joins and join conditions
outer joins : restrictions Transact-SQL outer join restrictions
outer joins : Transact-SQL Transact-SQL outer joins
Compatibility of joins
Compatibility of joins
outer joins : Transact-SQL, restrictions on Transact-SQL outer join restrictions
outer joins : Transact-SQL, views and Views used with Transact-SQL outer joins
output redirection Using output redirection
OUTPUT statement : about Exporting query results using Interactive SQL
owners : about Ownership permissions overview