[top]
[prev]
[next]
Documentation Top

= Tuning Cloudscape
= Developer's Guide
= Reference Manual
= Tutorial
= Tools Guide
= Server Guide
= Synchronization Guide
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Z
Symbols
Numerics
|
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Z
Symbols
Numerics
- Sample applications and databases
- description
- Sample database
- accessing GS
- Sample database library GS
- Sargable
- definition
- Scalar subquery expression
- ScalarSubquery
- Scale
- for decimal arithmetic
- of decimal arithmetic expressions
- SchemaName identifier
- Schemas
- and users
- APP as default
- changing default for session
- creating
- dropping
- glossary definition
- Scripts
- running in ij
- Scroll insensitive cursors (JDBC)
- Scrolling insensitive cursors
,
- Second-chance type conversion
- Secure Socket Layer (SSL)
- database connection URL for
- definition
- setting Cloudconnector properties for
- Security
- configuring
- for synchronization systems
- Security features
- limitations of
- seg0 directory
- Select expression
- SELECT statement
- Selectivity assumptions of optimizer
- Sequence-number column
- Sequence-number columns
- Serializable
- working with types that are not
- Serializable
- use of compared to Externalizable
- Serialization
- description
- glossary definition
- implications of
- incompatibility for pre-1.1.6 and post-1.2 databases
- requirements for
, ,
- serialVersionUID
- serialVersionUID
- use of
- Server frameworks
- Servers
- embedding
- glossary definition
- setting properties for
- setting system properties for
- shutting down
- starting
- service.properties file
- service.properties file
- setting logDevice in
- Servlet API
- Servlets
- configuring
- examples
- SESSION_USER
- SESSION_USER (function)
- Set Connection (ij command)
- 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
,
- setDatabaseProperty
- sets
- setUnicodeStream
- setXXXStream requests
- Shared locks
- definition
- glossary definition
- Shell scripts
- Show Connections (ij command)
- Shutdown
- automatic with ij Exit command in embedded system
- description
- function
- performance benefits of
- shutdown=true (database connection URL attribute)
- Shutting down a single database
,
- Shutting down Cloudscape
- from an application
- using database connection URL attribute
- Shutting down JBMS (embedded, from ij)
- Signed jar files
,
- Simple column reference
- definition
- SimpleColumnName identifier
- Size limitations of Cloudscape objects and databases
- SkipTransactionSQLException
- Small devices
- SMALL INT data type
- Sort avoidance
,
- sort buffer
- Sorting results
- ORDER BY
- Sorts
- case-insensitive
- locale-sensitive
- Source databases
- creating from non-synchronization-enabled databases
- definition of
- Sources
- glossary definition
- Space
- reclaiming
- SpaceTable class alias
- Special characters
- escaping in SQL-J statements
- Specifying ij properties
- SQL
- case-insensitivity of
- definition
- uses
- SQLExceptions
- chaining
, - chaining of
- glossary definition
- handling
- importance of not catching within database-side methods
, - user-defined (38001-38999)
- working with
- SQL-J identifiers
- definition
- SQLState values
- SQLState XJZZZ
- meaning of
- SQLState 40XU1
- meaning of
- SQLWarnings
- SQL-92
- definition
- features not supported by Cloudscape
- features supported by Cloudscape
- SQL-92 data types
- supported by Cloudscape
- SQL92Identifiers
- definition
- rules for
- SSL
,
- database connection URL for
- definition
- setting Cloudconnector properties for
- Stale statements
- definition
- Start scripts
- startCS script
- for RmiJdbc
- with Cloudconnector
- Starting Cloudscape
- embedded mode
- from an application
- Starting ij with a properties file
- Starting JBMS
- Start-up
- description
- State information
- saving across a refresh
- Statement cache
- performance benefits of
,
- Statement execution
- analyzing
- debugging
- Statement execution plan
,
- Statement plans
- automatic invalidation of
- StatementListVTI class alias
- StatementName identifier
- Statements
- and stale statement execution plans
- caching
- debugging
- using
- when they are optimizable
,
- Statements shared by threads
- dangers of
- Static fields
- not serialized
- Static IN transformations
- Static methods
- executing
- glossary definition
- invoking
- Static properties
- unable to set through SQL-J statement
- Statistics timing attribute
- use of
- Stop scripts
- stopCS script
- stopCS script
- for RmiJdbc
- StopRefreshSQLException
- Storage properties
,
- for indexes backing constraints
- Stored prepared statement cache
- Stored prepared statements
,
- altering
- caching of across multiple connections
- creating
- differences from views
- glossary definition
- need for recompiling before transferring to read-only media
- need to recompile
, - performance benefits of
, - performance hit caused by recompilation
- recompiling invalid statements
- sample values for parameters for optimization
- staleness of requiring recompilation
- what makes them invalid
- Stored procedures
- glossary definition
- invoking
- replaced by Java methods
- using method invocation to emulate
- Storing classes in the database
,
- Stream
- length specification not necessary
- Streaming columns
- as IN parameters to prepared statement
- glossary definition
- retrieving from ResultSets using getXXXStream methods
- String expressions
- with wildcards
- String functions
- locale-sensitive
- Strings
- delimited by single quotation marks in SQL-J
- delimited by single quotation marks within SQL-J statements
- Strings in ij
- Subclasses
- accessing methods of
- storing
- Subprotocol
- part of database connection URL syntax
,
- Subqueries
- elimination of DISTINCT in IN, ANY, and EXISTS subqueries
- flattening of
- flattening of to an EXISTS join
- materialization of
- processing and transformations of
- SUBSTR (function)
- SUBSTRING (function)
- Subsubprotocol
- part of database connection URL syntax
, ,
- SUM aggregate function
- swingall.jar GS
- Synchronization
- glossary definition
- Synchronized system
- creating
- Synchronizing databases
,
- SYSALIASES system table
- SYSCHECKS system table
- SYSCOLUMNS system table
- SYSCONGLOMERATES system table
- SYSCONSTRAINTS system table
- SYSDEPENDS system table
- SYSERRORS system table
, ,
- SYSERRORS system table
- extracting information from
- removing records from
- SYSFILES system table
- SYSFOREIGNKEYS system table
- sysinfo
- description
- using
- sysinfo.publicationID
- sysinfo.publicationName
- sysinfo.sourceDatabaseID
- sysinfo.sourceDatabaseName
- sysinfo.sourceServerAddress
- SYSJDBCTYPEINFO system table
- SYSKEYS system table
- SYSPUBITEMS system table
- SYSPUBS system table
- SYSSCHEMAS system table
- SYSSTATEMENTS system table
- SYSSYNCINSTANTS system table
- SYSTABLES system table
- System
- description
- glossary definition
- System directory
, ,
- creating and naming directory for
- default
- specifying
- System properties
- accessing from within SQL-J
- for servers
- setting in a Properties object
- setting on command line
- System tables
- querying
- System-wide properties
- setting
- SYSTRIGGERS system table
- SYSVIEWS system table
- SYSVISUAL schema
- schema for Cloudview's stored prepared statements
- SysVisual.LOG
- SysVisual.properties
|