Master Index to the Cloudscape Documentation
Page 4 of 28

C

Caches
performance benefits of priming
Caching
turning off for server
CALL statement
and return values
and work units ,
example use of
used to invoke work units
call (JDBC escape keyword)
Case sensitivity of keywords and identifiers
Case-insensitive sorts
CAST expression
CAST function
example use of
use of
CHAR data type
Character expressions
CHARACTER_LENGTH function ,
CHAR_LENGTH function ,
Check constraints
glossary definition
use of IN expression within
checkJBMSException method
Checkpoint
Class alias
in a publication
Class aliases
ambiguity with column names
built-in
creating
default
dropping
Class compatibility
Class loading
enabling
how to minimize impact of
tuning
when it occurs in Cloudscape
Class path
accessing databases from
accessing read-only databases from
for a server framework
glossary definition
performance implications of
setting GS
setting for clients
testing GS, ,
Class versioning
Class versioning (keeping classes compatible when modifying)
Class versions, specifying
ClassAlias identifier
Classes
altering
database vs. system storage
storing in database
storing in the database ,
Classes, modifying
ClassNotFound exceptions
troubleshooting
classpath subsubprotocol
Clients
setting class paths for
client.jar GS,
client.jar file
in class path ,
when needed
Client/server environments
deploying client applications
deploying Cloudscape for
description
CLOBS
Clobs
glossary definition
Close (ij command)
Cloudconnector
and Cloudview
and ij
description
embedding
using with ij and Cloudview
Cloudscape
multiple client applications accessing
Cloudscape as server
Cloudscape base directory
Cloudscape environments GS,
Cloudscape libraries GS
version compatibility GS
Cloudscape properties
setting
Cloudscape system
cloudscape.authentication.ldap.searchAuthDN
cloudscape.authentication.ldap.searchAuthPW
cloudscape.authentication.ldap.searchbase
cloudscape.authentication.ldap.searchfilter
cloudscape.authentication.provider
cloudscape.authentication.refresh ,
cloudscape.authentication.server
cloudscape.connection.requireAuthentication , ,
cloudscape.database.classpath
cloudscape.database.defaultConnectionMode
cloudscape.database.forceDatabaseLock
cloudscape.database.fullAccessUsers
cloudscape.database.noAutoBoot ,
cloudscape.database.propertiesOnly ,
cloudscape.database.readAccessTarget
cloudscape.database.readOnlyAccessUsers
cloudscape.database.refresh
cloudscape.database.sourceUser
cloudscape.database.sourceUser property , , ,
cloudscape.database.synchronizationCleanup
cloudscape.DataComm.listenType ,
cloudscape.DataComm.port ,
cloudscape.infolog.append
cloudscape.jar GS
cloudscape.jar ,
cloudscape.jdbc.metadataStoredPreparedStatements
cloudscape.language.bulkFetchDefault
cloudscape.language.defaultIsolationLevel
cloudscape.language.logStatementText
cloudscape.language.preloadClasses
cloudscape.language.spsCacheSize
cloudscape.language.stalePlanCheckInterval
cloudscape.language.statementCacheSize ,
cloudscape.listener.synchronization.address ,
cloudscape.locks.deadlockTimeout
cloudscape.locks.deadlockTrace ,
cloudscape.locks.escalationThreshold ,
cloudscape.locks.monitor ,
cloudscape.locks.waitTimeout
cloudscape.LOG
cloudscape.properties file , , , , ,
cloudscape.refresh.guaranteedRefreshInterval
cloudscape.service
cloudscape.storage.fileCacheSize
cloudscape.storage.initialPages
cloudscape.storage.minimumRecordSize
cloudscape.storage.pageCacheSize
cloudscape.storage.pageReservedSpace
cloudscape.storage.pageSize ,
cloudscape.storage.rowLocking
cloudscape.storage.sortBufferMax
cloudscape.storage.tempDirectory
cloudscape.stream.error.field
cloudscape.stream.error.file
cloudscape.stream.error.logSeverityLevel ,
cloudscape.stream.error.method
cloudscape.synchronization.workUnitOnly
cloudscape.system.bootAll , ,
cloudscape.system.home
cloudscape.system.home ,
cloudscape.system.home
determining location of cloudscape.properties
importance of setting
used to define system directory
cloudscape.ui.codeset (tool property) ,
cloudscape.ui.locale (tool property) ,
cloudscape.user
CLOUDSCAPE_INSTALL environment variable GS, ,
cloudsync.jar GS
Cloudview
and Cloudconnector
and RmiJdbc
and server frameworks
and synchronization features
codeset
how to use
JDK requirement
language display ,
locale
log
properties
starting
using with Cloudconnector
Cloudview on-line help
specifying location of
Code generation
stage of compilation
Codeset
Cloudview
Column constraints
used in CREATE TABLE statement
Column defaults
Column reference expression
Column widths
increasing
Column-level constraints
ColumnName identifier
Columns
adding
maximum number allowed per table
modifying
Comment delimiters within SQL-J
Commit ,
glossary definition
Commit (ij command)
Comparison boolean operators
Compilation
avoiding by using PreparedStatements
avoiding by using stored prepared statements
definition
performance hit
stages of
Compilation classes
loading at boot time
Compressing tables
Compressing tables and indexes
COM.cloudscape.aggregates.AggregateDefinition
COM.cloudscape.aggregates.Aggregator
COM.cloudscape.authentication.Interface.AuthenticationException
COM.cloudscape.authentication.Interface.AuthenticationSceme
COM.cloudscape.authentication.Interface.MessageAuthenticationScheme
COM.cloudscape.core.AbstractDataSource ,
COM.cloudscape.core.BasicDataSource ,
COM.cloudscape.core.CloudscapeServer class ,
COM.cloudscape.core.DataSourceFactory ,
COM.cloudscape.core.JDBCDriver
COM.cloudscape.core.LocalConnectionPoolDataSource ,
COM.cloudscape.core.RemoteXaDataSource
COM.cloudscape.core.RemotXaDataSource
COM.cloudscape.core.ServletHandler
COM.cloudscape.core.WebLogicDriver ,
COM.cloudscape.core.XaDataSource ,
COM.cloudscape.database.AggregateDefinition
COM.cloudscape.database.Aggregator
COM.cloudscape.database.checkJBMSException method
COM.cloudscape.database.ConsistencyChecker
COM.cloudscape.database.ConsistencyChecker.checkTable
COM.cloudscape.database.Database ,
COM.cloudscape.database.Database.backup
COM.cloudscape.database.Database.freeze
COM.cloudscape.database.Database.unfreeze
COM.cloudscape.database.Factory
COM.cloudscape.database.Factory.getDatabaseOfConnection ,
COM.cloudscape.database.JavaSQLException
COM.cloudscape.database.JBMSException ,
COM.cloudscape.database.PropertyInfo ,
COM.cloudscape.database.PropertyInfo.getDatabaseProperty method
COM.cloudscape.database.TriggerExecutionContext
use of in trigger actions
COM.cloudscape.database.UserUtility ,
COM.cloudscape.synchronization.RowListVTI
COM.cloudscape.synchronization.SkipTransactionSQLException
COM.cloudscape.synchronization.StatementListVTI
COM.cloudscape.synchronization.StopRefreshSQLException
COM.cloudscape.synchronization.TargetDescription ,
COM.cloudscape.synchronization.TransactionListVTI
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.dbclasses
using
COM.cloudscape.tools.DBClassLoad
COM.cloudscape.tools.FileExport ,
COM.cloudscape.tools.FileImport ,
COM.cloudscape.tools.ImportExportSQLException
COM.cloudscape.tools.sysinfo ,
COM.cloudscape.tools.sysinfo -cp
COM.cloudscape.TriggerExecutionContext
COM.cloudscape.triggers.TriggerNewTransitionRows
COM.cloudscape.triggers.TriggerOldTransitionRows
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.DBClassLoad ,
COM.cloudscape.util.DriverUtil
COM.cloudscape.util.JDBCDisplayUtil
COM.cloudscape.util.KeyGen
COM.cloudscape.util.KeyGen.getUniversalKeyStringValue method
COM.cloudscape.util.KeyGen.getUniversalKeyValue method
COM.cloudscape.vti.ErrorMessages ,
COM.cloudscape.vti.ExternalQuery ,
COM.cloudscape.vti.LockTable , , ,
COM.cloudscape.vti.SpaceTable ,
COM.cloudscape.vti.SpaceTableVTI
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 , , ,
Concatenation function
as expression
Concurrency
glossary definition
Conditional expression , ,
Configuring Cloudscape
Conflicts
definition
framework for handling
Conglomerates
definition
Conglomerate-specific properties
setting
verifying
Connect (ij command)
Connecting to a database
Connecting to a database (using databaseName attribute)
Connecting to databases
from an application
in embedded mode
when path is ambiguous because of databases in class path
when path is ambiguous with databases in file system
Connecting to databases not directly in the system directory
Connecting to multiple databases
Connection
switching (ij)
Connection object
as parameter to JDBC method
Connection pooling ,
Connection pools
definition
reasons for using
refreshing
resetting
setting up
using a connection from
ConnectionInfo class alias
Connections
garbage collection of
getting
glossary definition
multiple
nested
session-severity exceptions closing
system-severity exceptions closing
Consistency
checking database
glossary definition
Consistency errors
ConsistencyChecker class alias
CONSTRAINT clause
constraint optimizer-override property
ConstraintName identifier
Constraints
adding
column-level ,
compressing
differences between column-level and table-level
disabling ,
dropping
enabling
getting information about key columns
glossary definition
recommendation to name
table-level ,
Constructors
use of in SQL-J
Controlling evaluation order
Conversions
implicit (to and from strings)
of Java data types using CAST
of SQL-92 data types using CAST
using CAST function (explicit)
Converting non-synchronization-enabled databases to source databases
convertToSource
Copy files
creating target databases with
COPY PUBLICATION statement
Copying databases
implications for synchronization
CorrelationName identifier
COUNT aggregate function ,
COUNT(*) aggregate function ,
Covering indexes ,
CREATE AGGREGATE statement
CREATE CLASS ALIAS statement ,
CREATE INDEX statement
CREATE METHOD ALIAS statement
CREATE PUBLICATION statement
CREATE SCHEMA statement
CREATE STATEMENT statement
CREATE TABLE statement
CREATE TRIGGER statement
CREATE VIEW statement
CREATE WORK ALIAS statement , ,
createSource
createTargetFrom
create=true (database connection URL attribute)
Creating a Cloudscape synchronization system
Creating a copy file
how to
overview
Creating a database
from an application
using database connection URL attribute
Creating a method alias for a static method
Creating a method/method alias to mimic a Sybase-style built-in function (SUBSTRING)
Creating a new database (ij)
Creating a publication
how to
overview
Creating a target
overview
Creating empty queries
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
CURRENT_USER (function)
CursorName identifier
Cursors ,
affected by indexes
all result sets as
and Cloudconnector
fetching next row (ij) , , , , , , ,
glossary definition
naming
pre-fetching affecting
requirements for being updatable
scrolling insensitive ,
updatable
using (ij)
working with
working with (ij) ,
Cursors, accessing system-generated names
Cursors, naming