Index
Page 1 of 1

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 - Symbols - Numerics

Index

Symbols

% as wildcard in SQL-J
* as wildcard in SQL-J SELECT ,
+, -, *, /, unary + and - expressions
-- (comment delimiters within SQL-J)
? (dynamic parameter)
in prepared statements
used in conditional expression
?: (conditional) expression
_ as wildcard within SQL-J
{call (JDBC escape syntax)
{d (JDBC escape syntax)
{oj (JDBC escape syntax)
{t (JDBC escape syntax)
{ts (JDBC escape syntax)

A

AggregateName identifier
Aggregates
and data types
definition
requirements for
AliasInfo class alias
ALTER STATEMENT statement
ALTER TABLE statement
AND boolean operator
ASC
implied in ORDER BY clause
AT ISOLATION clause
Attributes to database connection URL ,
AuthorizationIdentifierName identifier
autocommit=false (database connection URL attribute)
Autoincrement
Autoincrement defaults
and bulk insert ,
and connection pooling
and import/export
and synchronization
and triggers
retrieving value of most recent insert into
AVG aggregate function

B

Backing indexes
created automatically to enforce primary key, unique, and foreign key constraints ,
specifying storage properties for
Batch processing (JDBC) , ,
BETWEEN boolean operator
Bit strings
variable-length
BIT VARYING data type
BIT_LENGTH function ,
BitUtil class alias
BLOBS
BOOLEAN data type
Boolean expression
Boolean operators
part of WHERE clause
Booleans
assigning and comparing to numeric types
bootPassword=true (database connection URL attribute)

C

call (JDBC escape keyword)
CALL statement
and return values
used to invoke work units
Case sensitivity of keywords and identifiers
CAST expression
CAST function
CHAR data type
CHAR_LENGTH function ,
Character expressions
CHARACTER_LENGTH function ,
Check constraints
use of IN expression within
Class aliases
ambiguity with column names
built-in
creating
default
dropping
Class path
accessing read-only databases from
ClassAlias identifier
CLOBS
Column constraints
used in CREATE TABLE statement
Column defaults
Column reference expression
Column widths
increasing
Column-level constraints
ColumnName identifier
Columns
adding
modifying
COM.cloudscape.authentication.Interface.AuthenticationException
COM.cloudscape.authentication.Interface.AuthenticationSceme
COM.cloudscape.core.AbstractDataSource
COM.cloudscape.core.BasicDataSource
COM.cloudscape.core.DataSourceFactory
COM.cloudscape.core.JDBCDriver
COM.cloudscape.core.LocalConnectionPoolDataSource
COM.cloudscape.core.RemoteXaDataSource
COM.cloudscape.core.ServletHandler
COM.cloudscape.core.WebLogicDriver
COM.cloudscape.core.XaDataSource
COM.cloudscape.database.AggregateDefinition
COM.cloudscape.database.Aggregator
COM.cloudscape.database.ConsistencyChecker
COM.cloudscape.database.Database
COM.cloudscape.database.Factory
COM.cloudscape.database.JavaSQLException
COM.cloudscape.database.JBMSException
COM.cloudscape.database.PropertyInfo
COM.cloudscape.database.UserUtility
COM.cloudscape.synchronization.RowListVTI
COM.cloudscape.synchronization.SkipTransactionSQLException
COM.cloudscape.synchronization.StatementListVTI
COM.cloudscape.synchronization.StopRefreshSQLException
COM.cloudscape.synchronization.TransactiontListVTI
COM.cloudscape.system.System
COM.cloudscape.system.UUIDFactory
COM.cloudscape.tools.CloudscapeServer
COM.cloudscape.tools.cview
COM.cloudscape.tools.databasePreloader
COM.cloudscape.tools.dbclasses
COM.cloudscape.tools.DBClassLoad
COM.cloudscape.tools.FileExport
COM.cloudscape.tools.FileImport
COM.cloudscape.tools.ImportExportSQLException
COM.cloudscape.tools.sysinfo
COM.cloudscape.TriggerExecutionContext
COM.cloudscape.types.DatabaseInstant
COM.cloudscape.types.Dependable
COM.cloudscape.types.DependableFinder
COM.cloudscape.types.ErrorInfor
COM.cloudscape.types.IndexDescriptor
COM.cloudscape.types.JBMSExceptionSeverity
COM.cloudscape.types.ReferencedColumnDescriptor
COM.cloudscape.types.RunTimeStatistics
COM.cloudscape.types.RunTimeStatistics interface
COM.cloudscape.types.SyncErrorInfo
COM.cloudscape.types.TypeDescriptor
COM.cloudscape.types.UUID
COM.cloudscape.util.BitUtil
COM.cloudscape.util.DriverUtil
COM.cloudscape.util.JDBCDisplayUtil
COM.cloudscape.util.KeyGen
COM.cloudscape.vti.ErrorMessages ,
COM.cloudscape.vti.ExternalQuery
COM.cloudscape.vti.LockTable ,
COM.cloudscape.vti.SpaceTable
COM.cloudscape.vti.TransactionTable
COM.cloudscape.vti.TriggerNewTransitionRows
COM.cloudscape.vti.TriggerOldTransitionRows
COM.cloudscape.vti.UpdatableVTITemplate
COM.cloudscape.vti.VTICosting
COM.cloudscape.vti.VTIEnvironment
COM.cloudscape.vti.VTIMetaDataTemplate
COM.cloudscape.vti.VTITemplate
Comment delimiters within SQL-J
Comparison boolean operators
Compilation
stages of
Compressing tables
Concatenation function
as expression
Conditional expression ,
Connecting to a database (using databaseName attribute)
Connection pooling ,
ConnectionInfo class alias
Connections
garbage collection of
nested
session-severity exceptions closing
system-severity exceptions closing
ConsistencyChecker class alias
CONSTRAINT clause
ConstraintName identifier
Constraints
adding
column-level
compressing
differences between column-level and table-level
disabling ,
dropping
enabling
getting information about key columns
recommendation to name
table-level
Conversions
implicit (to and from strings)
of Java data types using CAST
of SQL-92 data types using CAST
using CAST function (explicit)
CorrelationName identifier
COUNT aggregate function
COUNT(*) aggregate function
CREATE AGGREGATE statement
CREATE CLASS ALIAS statement
CREATE INDEX statement
CREATE METHOD ALIAS statement
CREATE SCHEMA statement
CREATE STATEMENT statement
CREATE TABLE statement
CREATE TRIGGER statement
CREATE VIEW statement
create=true (database connection URL attribute)
CROSS JOIN expression
current=true (database connection URL attribute)
CURRENT_DATE function
as expression
CURRENT_TIME function
as expression
CURRENT_TIMESTAMP function
expression
CURRENT_USER (function)
CursorName identifier
Cursors
pre-fetching affecting
scrolling insensitive

D

d (JDBC escape keyword)
Data encryption
algorithms
providers
Data sources
creating a database for
setting the correct protocol for RmiJdbc client/server
shutting down a database for
Data types
modifying ,
Database connection URL
attributes
for Cloudconnector clients
settable through Properties in connection call
syntax in client/server environments ,
syntax in embedded mode
DatabaseMetaData.getProcedureColumns
databaseName=nameOfDatabase (database connection URL attribute)
Databases
encrypting ,
locale ,
dataEncryption=true (database connection URL attribute)
DATE data type
Date formats
JDBC escape syntax for
Date/time expressions
dbclasses class alias
DECIMAL data type
DefaultInfo class alias
Defaults
adding ,
adding or dropping
autoincrement
dropping ,
DELETE statement
Delimited identifiers
definition
DependableFinder class alias
Dependencies
internal tracking of
not tracked for Java data types
DESC
optional element of ORDER BY clause
Dictionary objects
definition
DISTINCT
qualifier in AVG function
qualifier in COUNT aggregate function
DISTINCT clause
part of SelectExpression
Distributed transaction management
DOUBLE PRECISION data type
Driver
for Cloudconnector clients
for RmiJdbc clients
DROP AGGREGATE statement
DROP CLASS ALIAS statement
DROP INDEX statement ,
DROP METHOD ALIAS statement
DROP SCHEMA statement
DROP STATEMENT statement
DROP TABLE statement
DROP TRIGGER statement
DROP VIEW statement
Dynamic parameter expression
Dynamic parameters
need to cast data type of within method invocation

E

Encrypting databases ,
Encryption
algorithms
providers
encryptionAlgorithm=algorithm (database connection URL attribute)
encryptionProvider=providerName (database connection URL attribute)
Entity-relationship diagram for system tables
Error messages
getting a complete list
ErrorInfo class alias
ErrorMessages class alias
ErrorTransactionVTI class alias
Escape character
for single-quotation mark
Escape syntax (JDBC)
EXECUTE STATEMENT statement
EXISTS boolean operator
Expression subquery
Expressions
hierarchy of
in SQL-J language
precedence of
External virtual tables
ExternalQuery class alias
EXTRACT function
as expression

F

Factory class alias
Field access
Field access expression
FileExport class alias
FileImport class alias
FLOAT data type
as alias for REAL or DOUBLE PRECISION
java.sql type converted to DOUBLE PRECISION when retrieved
FOR UPDATE clause
Foreign keys
FROM clause
Functions, built-in

G

getAsciiStream
getBinaryStream
GETCURRENTCONNECTION() function
getUnicodeStream
getXXXStream requests
GROUP BY clause

H

HAVING clause

I

Identifiers
definition
IN (? or dynamic) parameters
IN boolean operator
Index class alias
IndexDescriptor class alias
Indexes
and Java data types
automatic creation of for primary key, unique, and foreign key constraints ,
getting information about key columns
specifying page size for
IndexName identifier
INNER JOIN expression
In-place updates
INSERT statement
INSTANCEOF boolean operator
INSTANCEOF expressions
INTEGER data type
Integer literals
using parentheses to avoid interpretation as DOUBLE PRECISION
International string data types
Internationalization features
allowing unicode escapes
locale
IS boolean operator
IS NOT NULL boolean operator
IS NULL boolean operator
Isolation levels
changing for a single statement
changing for a transaction
setting via JDBC

J

J2EE
JarName identifier
Java data types
and equality comparisons
assignability of
built-in
metadata for
ordering by
used in method invocation
Java expressions ,
Java identifiers
case sensitivity of within SQL-J
java.sql.Blob
java.sql.CallableStatement
java.sql.CallableStatement
and INOUT parameters
and OUT parameters
java.sql.Clob
java.sql.Connection
java.sql.Connection.isReadOnly
java.sql.Connection.setReadOnly
java.sql.Connection.setTransactionIsolation
java.sql.DatabaseMetaData
java.sql.Driver
java.sql.Driver.getPropertyInfo
java.sql.DriverManager.getConnection
java.sql.PreparedStatement
java.sql.ResultSet
java.sql.ResultSetMetaData
java.sql.SQLException
java.sql.SQLWarning
java.sql.Statement
java.sql.Types
mapped to SQL-J types
java.transaction.xa package
JavaClassName identifier
JavaFieldName identifier
JavaIdentifiers
definition
rules for
JavaMethodName identifier
javax.sql package
javax.sql.ConnectionPoolDataSource ,
javax.sql.DataSource ,
javax.sql.PooledConnect
javax.sql.PooledConnection
javax.sql.XAConnection
javax.sql.XADataSource
javax.sql.XAxxx interfaces
javax.transaction.xa.XAException
javax.transaction.xa.XAResource
javax.transaction.xa.Xid
JDBC 2.0
Cloudscape's support for
standard extensions
JDBC API
Cloudscape implementation of
JDBC driver
for Cloudconnector client
for RmiJdbc clients
loading
JDBC escape syntax
JDBC types
mapped to SQL-J types
jdbc.drivers system property
using to load driver
JNDI
JOIN operation
JTA API

K

KeyGen class alias
Keywords
case insensitivity of

L

LEFT OUTER JOIN expression
LIKE boolean operator
Literal expression
Locale
and ORDER BY clause
database ,
locale=ll_CC (database connection URL attribute)
Lock escalation
by user
Lock granularity
specifying when you create a table
LOCK TABLE statement
LockTable class alias
logDevice=logDirectoryPath (database connection URL attribute)
LONG BINARY data type
LONG BIT VARYING data type
LONG NVARCHAR data type
LONG VARBINARY data type
LONG VARCHAR data type
LONGINT data type
LONGVARBINARY
LONGVARCHAR
LOWER (function)
LTRIM (function)

M

Mapping
of Java to SQL-J types
of SQL-J data types to Java data types
of SQL-J types to java.sql.Types
Matching index scans
MAX aggregate function
Method aliases
dropping
Method invocation
and dynamic parameters
as expression
runtime exceptions generating statement exceptions
type conversion during
Method receiver
definition
Method resolution
and type correspondence
MethodAliasName identifier
Methods returning void types
executable only within CALL statements
MIN aggregate function

N

NCHAR data type
NEW expression
Non-matching index scans
Non-serializable objects
NOT boolean operator
NULL
not a data type
within method invocations
NULL expression
NUMERIC data type
Numeric data types
implicit conversion
promotion of in expressions
Numeric expressions
Numeric types
assigning and comparing to booleans
NVARCHAR data type

O

Objects
non-serializable
OCTET_LENGTH expression
OCTET_LENGTH function
oj (JDBC escape keyword)
ON
differences from USING in join expressions
ON clause
part of INNER JOIN expression
OR boolean operator
ORDER BY clause
affecting cursors
and database locale
and Java data types
needed to guarantee order of results
Orderable Java data types
and indexes ,
Ordering
not typically permitted with Java data types
Ordering Java data types
Outer joins
JDBC escape syntax for

P

password=userPassword (database connection URL attribute)
Precision
of decimal arithmetic expressions
Prepared statements
tracking of dependencies
use of dynamic parameters in
Primary key constraints
Primary keys
adding ,
creating ,
PROPERTIES clause
part of CREATE TABLE and CREATE INDEX statements
PropertyInfo class alias

Q

Quantified comparison boolean operator

R

Read-only VTIs
Read-write VTIs
and DELETES
and INSERTs
REAL data type
ReferencedColumnsDescriptor class alias
Referential integrity
via foreign keys
Reserved words
Resource manager
Cloudscape as in J2EE system
Result set node
part of statement execution plan
ResultSets
errors in statement affecting creation of
RIGHT OUTER JOIN expression
RowListVTI class alias
RTRIM (function)
RUNTIMESTATISTICS() function
accessing information from
and multi-threaded applications

S

Scalar subquery expression
ScalarSubquery
Scale
for decimal arithmetic
of decimal arithmetic expressions
SchemaName identifier
Schemas
APP as default
changing default for session
creating
dropping
Scroll insensitive cursors (JDBC)
Scrolling insensitive cursors
Second-chance type conversion
Select expression
SELECT statement
Sequence-number columns
Serialization
implications of
requirements for ,
SESSION_USER (function)
SET CONSTRAINTS statement
Set functions
SET LOCKING clause
SET RUNTIMESTATISTICS statement
SET SCHEMA statement
SET STATISTICS TIMING statement
SET TRANSACTION ISOLATION LEVEL statement
SET TRIGGERS statement
setAsciiStream
setBinaryStream
setUnicodeStream
setXXXStream requests
shutdown=true (database connection URL attribute)
SimpleColumnName identifier
SMALL INT data type
Sorts
locale-sensitive
SpaceTable class alias
Special characters
escaping in SQL-J statements
SQL-92
features not supported by Cloudscape
features supported by Cloudscape
SQL-92 data types
supported by Cloudscape
SQL92Identifiers
definition
rules for
SQLExceptions
chaining ,
importance of not catching within database-side methods
SQL-J identifiers
definition
SQLState values
SQLState XJZZZ
meaning of
Statement execution plan
StatementListVTI class alias
StatementName identifier
Storage properties
for indexes backing constraints
Stored prepared statements
altering
creating
recompiling invalid statements
Stream
length specification not necessary
Streaming columns
as IN parameters to prepared statement
retrieving from ResultSets using getXXXStream methods
String expressions
with wildcards
String functions
locale-sensitive
Strings
delimited by single quotation marks within SQL-J statements
SUBSTR (function)
SUBSTRING (function)
Subsubprotocol
part of database connection URL syntax
SUM aggregate function
SYSALIASES system table
SYSCHECKS system table
SYSCOLUMNS system table
SYSCONGLOMERATES system table
SYSCONSTRAINTS system table
SYSDEPENDS system table
SYSERRORS system table
SYSFILES system table
SYSFOREIGNKEYS system table
SYSJDBCTYPEINFO system table
SYSKEYS system table
SYSSCHEMAS system table
SYSSTATEMENTS system table
SYSTABLES system table
SYSTRIGGERS system table
SYSVIEWS system table

T

t (JDBC escape keyword)
Table constraints
used in CREATE TABLE statement
Table subquery expression
TableExpression
Table-level constraints
TableName identifier
Tables
altering
changing lock granularity for
compressing
dropping
locking
specifying page size for
specifying properties for
TableSubquery
TIME data type
Time formats
JDBC escape syntax for
TIMESTAMP data type
Timestamp formats
JDBC escape syntax for
TINYINT data type
TransactionListVTI class alias
TransactionTable class alias
TriggerName identifier
TriggerNewTransitionRows class alias
TriggerOldTransitionRows class alias
Triggers
and database events
and recursion
and the referencing clause
creating
defining when they fire
disabling and reenabling
dropping
order of execution
referencing old and new values
statement vs. row triggers
the trigger action
transition row VTIs
trigger execution context
TRIM function
ts (JDBC escape keyword)
Type conversion of String types
implicit
Type correspondence
between SQL-J and Java types ,
for JDBC and SQL-J types
TypeDescriptor class alias

U

Unicode
setUnicodeStream
vs. ASCII with unicode escapes
Unicode escapes
support for in SQL-J statements
Unicode escapes in SQL-J text
unicode=false (database connection URL attribute)
UNION
UNION ALL
Unique constraints
UPDATE statement
upgrade=true (database connection URL attribute)
UPPER function
USER function
user=userName (database connection URL attribute)
User-defined aggregates
dropping
User-defined data types
UserUtility class alias
USING
differences from ON in join expressions
performance implications of in join expressions
USING clause
part of INNER JOIN expression

V

VALUES clause
used to invoke work units
VALUES expression
Varbinary data types
VARCHAR data type
ViewName identifier
Views
creating
dropping
Virtual Table Interface (VTI)
VTIs
lack of transaction support for

W

WHERE clause
SQL-J extensions to
WHERE CURRENT OF clause
Wildcards in SQL-J
Work units
invoking ,

X

XA