Master Index to the Cloudscape Documentation
Page 10 of 28

I

Identifiers
definition
IDEs
and need to use server framework
using Cloudscape with
ij
and Cloudconnector
and RmiJdbc
commands
description
JDK requirement
properties
semicolon between statements required
starting ,
using with Cloudconnector
ij properties
ij (scripting tool)
using
ij.connection (ij property)
ij.database (ij property)
ij.driver (ij property)
ij.maximumDisplayWidth (ij property)
ij.outfile (ij property)
ij.protocol (ij property)
ij.protocol.protocolName (ij property)
ij.showErrorCode (ij property)
ij.unicodeEscape (ij property)
ij.URLCheck (ij property)
Import
Importing data ,
IN boolean operator
IN (? or dynamic) parameters
Index class alias
index optimizer-override property
Index use
analyzing ,
how optimizer chooses
IndexDescriptor class alias
Indexes
and Java data types
automatic creation of for primary key, unique, and foreign key constraints ,
cost of maintaining
definition ,
finding name of with Cloudview
getting information about key columns
glossary definition
how they work
limitations of
maximum number allowed per table
not supported for long rows
not usable when query includes complex expression
performance benefits of , ,
preventing Cloudscape from using
querying system tables to get system-generated name
specifying page size for
when they are useful ,
IndexName identifier
Information log ,
description
overwriting
INNER JOIN expression
Inner tables
glossary definition
In-place updates
Input/output streams
and serializable objects
INSERT statement
Inserting a row of Nulls
insertMode (import property)
Installation directory
layout of
INSTANCEOF
example use of
use of
INSTANCEOF boolean operator
INSTANCEOF expressions
INTEGER data type
Integer literals
using parentheses to avoid interpretation as DOUBLE PRECISION
Integrating external libraries
Internal transformation of statements
BETWEEN predicates
COUNT
LIKE predicates
OR predicates
predicates
Sort avoidance
static IN predicates
transitive closure
views
International string data types ,
Internationalization
and the Cloudscape tools
Internationalization features
allowing unicode escapes
codeset
locale ,
interrupt calls
caught by Cloudscape
Invoking java.lang.String methods
Invoking methods
when method does not return a value
Invoking non-static methods on SQL-J expressions
Invoking static methods of java.langMath
IN/ANY subquery transformation
IOExceptions
indicating need to relax file descriptors limit
troubleshooting
IS boolean operator
IS NOT NULL boolean operator
IS NULL boolean operator
Isolation
glossary definition
Isolation levels ,
and work units
changing for a single statement
changing for a transaction
configuring
configuring default for system or database
for COPY PUBLICATION
setting via JDBC