Master Index to the Cloudscape Documentation
Page 20 of 28

S

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