[top]
[prev]
[next]

Documentation Top
Global Index
Reference Manual
TOC Index
Grammar Index
Developer’s Guide
TOC Index
Tuning Cloudscape
TOC Index
|
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
- % 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)
- 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
- 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)
- 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 (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
- 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
- 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
- getAsciiStream
- getBinaryStream
- GETCURRENTCONNECTION() function
- getUnicodeStream
- getXXXStream requests
- GROUP BY clause
- HAVING clause
- 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
- 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
- KeyGen class alias
- Keywords
- case insensitivity of
- 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)
- 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
- 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
- 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
- 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
- Quantified comparison boolean operator
- 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
- 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 (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
- 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
- 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
- WHERE clause
- SQL-J extensions to
- WHERE CURRENT OF clause
- Wildcards in SQL-J
- Work units
- invoking
,
- XA
|