Index

C

cache : Java Configuring memory for Java
cache : performance Increase the cache size
cache : server names Server name caching for faster connections
cache : size switch Controlling performance and memory from the command line
cache size : effect on access plans Join enumeration
caching : sub-queries Subquery caching
CALL statement : about Procedure and trigger overview
CALL statement : examples Calling procedures
CALL statement : parameters Passing parameters to procedures
CALL statement : syntax Control statements
Calls window : Java debugger The debugger windows
cannot find database server Locating a server
cardinality : relationships and Relationships
Cartesian product Cross joins
How joins are processed
CASCADE action : about Referential integrity actions
case sensitivity : collations The collation sequence section
case sensitivity : command line Starting the server
case sensitivity : connection parameters Connection parameters
case sensitivity : creating databases Creating a Transact-SQL-compatible database
case sensitivity : database name Naming the server and the databases
case sensitivity : databases Case-sensitivity
case sensitivity : identifiers Case-sensitivity
case sensitivity : international aspects International aspects of case sensitivity
case sensitivity : Java Java is case sensitive
case sensitivity : Java data types Creating columns with Java data types
case sensitivity : passwords Case-sensitivity
case sensitivity : remote access Case sensitivity
case sensitivity : server name Naming the server and the databases
case sensitivity : sort order The ORDER BY clause: sorting query results
case sensitivity : SQL Entering queries
Java is case sensitive
case sensitivity : Transact-SQL compatibility Case-sensitivity
case sensitivity : user-defined data types Case-sensitivity
CASE statement : syntax Control statements
case-sensitivity : data Case-sensitivity
case-sensitivity : user IDs Case-sensitivity
case-sensitivity : user-defined data types Case-sensitivity
catalog : Adaptive Server Enterprise compatibility System tables
catch block : Java Java error handling
CBSize connection parameter : about Connection parameters
CBSpace connection parameter : about Connection parameters
CD-ROM : databases Working with write files
CD-ROM : deploying Deploying databases on read-only media
chained mode : transactions Setting autocommit or manual commit mode
CHAINED option : JDBC Notes on JDBC connections
CHAINED option : Open Client Characteristics of Open Client and jConnect connections
changing isolation levels within transactions Changing the isolation level within a transaction
changing the isolation level Setting the isolation level
character data : searching for Character strings and quotation marks
character set : application Determining the locale character set
character set : determining Determining the locale character set
character set : server Determining the locale character set
character set translation : about Using character set translation
character set translation : error messages Character translation for database messages
character sets : about CHAPTER 12. Database Collations and International Languages
character sets : avoiding translation Avoiding character-set translation
character sets : choosing Choosing a database collation
character sets : displaying Displaying your current character settings
character sets : encoding Introduction
character sets : for Replication Server Character set issues
character sets : for the LTM Character set settings in the LTM configuration file
Language and character set issues
Adaptive Server Anywhere collations
Open Client/Open Server collations
character sets : Interactive SQL Sybase Central and Interactive SQL code page translation
character sets : multibyte Multibyte character sets
Using multibyte collations
character sets : overview Introduction to character sets and collations
character sets : single-byte Single-byte character sets and code pages
character sets : Sybase Central Sybase Central and Interactive SQL code page translation
character sets : translation Using character set translation
character sets : Unicode Variable length character sets
character sets : Windows Code pages in Windows and Windows NT
character strings : about Character strings and quotation marks
character strings : quotes Character strings and quotation marks
Character strings : select list using Computing values in the select list
CHECK conditions : columns Using CHECK conditions on columns
CHECK conditions : deleting Modifying and deleting CHECK conditions
CHECK conditions : modifying Modifying and deleting CHECK conditions
check conditions : previous releases Using CHECK conditions on columns
CHECK conditions : tables Using CHECK conditions on tables
CHECK conditions : Transact-SQL Defaults and rules
CHECK conditions : user-defined data types Column CHECK conditions from user-defined data types
CHECK constraint Choosing constraints
checking referential integrity at commit Locking during inserts
checkpoint log The checkpoint log
checkpoints : log The checkpoint log
checkpoints : scheduling How the database decides when to checkpoint
checkpoints : urgency Checkpoint priority
CHECKPOINT_TIME option : using Checkpoint priority
choosing isolation levels Understanding and choosing isolation levels
class methods : about Instance methods and class methods
Class.forName method : loading jConnect Loading the driver
classes : about Understanding the Java class
classes : as data types Creating columns to hold Java objects
classes : compiling Understanding the Java class
classes : constructors Class constructors
classes : creating Creating a class
classes : database types Java classes in the database
classes : example A sample class
classes : importing Importing the class on the client side
classes : installing How do I store Java instructions in the database?
Installing Java classes into a database
classes : instances Object oriented and procedural languages
classes : Java Object oriented and procedural languages
classes : supported Which Java classes are supported?
classes : Sybase runtime Sybase runtime Java classes
classes : updating Updating classes and Jars
classes : versions Updating classes and Jars
Classes window : Java debugger The debugger windows
classes.zip Deploying database servers
CLASSPATH environment variable : about Using the CLASSPATH variable
CLASSPATH environment variable : jConnect The jConnect driver files
CLASSPATH environment variable : setting Running the external connection example
clauses : about Queries are made up of clauses
Client Service for NetWare Using IPX with Windows NT
CLOSE statement : procedures Cursor management overview
code page : displaying Displaying your current character settings
code pages : ANSI Code pages in Windows and Windows NT
code pages : Interactive SQL Sybase Central and Interactive SQL code page translation
code pages : OEM Code pages in Windows and Windows NT
code pages : overview Single-byte character sets and code pages
code pages : Sybase Central Sybase Central and Interactive SQL code page translation
code pages : Windows Code pages in Windows and Windows NT
collation file : editing Editing the collation file
collations : about CHAPTER 12. Database Collations and International Languages
collations : choosing Choosing a database collation
collations : custom Creating databases with custom collations
collations : definition Sorting characters using collations
collations : file format Editing the collation file
collations : for Replication Server Character set issues
collations : for the LTM Character set settings in the LTM configuration file
Language and character set issues
Adaptive Server Anywhere collations
Open Client/Open Server collations
collations : ISO_1 Supplied ANSI collations
collations : multibyte Using multibyte collations
collations : OEM Supported OEM collations
collations : overview Introduction to character sets and collations
collations : WIN_LATIN1 Supplied ANSI collations
column attributes : AUTOINCREMENT Primary key generation
column attributes : generating default values Primary key generation
column names : international aspects International aspects of case sensitivity
column names : joining tables using Natural joins
column-statistics registry Column-statistics registry
columns : adding Altering tables
columns : allowing NULL values Choosing data types for columns
columns : changing Altering tables
columns : constraints Choosing constraints
columns : data types Choosing data types for columns
columns : defaults Using column defaults
columns : deleting Altering tables
columns : GROUP BY clause The GROUP BY clause: organizing query results into groups
columns : IDENTITY The special IDENTITY column
columns : Java data types Creating columns to hold Java objects
columns : joins and How joins are structured
Data types in join columns
columns : joins and datatypes Data types in join columns
columns : naming Creating primary and foreign keys
Choosing column names
columns : order in insert statements Inserting values into specific columns
columns : properties Designing the database table properties
columns : renaming Altering tables
columns : select list Selecting specific columns from a table
columns : SELECT statements Selecting specific columns from a table
columns : timestamp The special Transact-SQL timestamp column and data type
columns : updating Java Updating Java objects
com.sybase package : runtime classes The Sybase runtime Java classes
command delimiter : setting Check if you need to change the command delimiter
command files : Interactive SQL Using Interactive SQL to work with database objects
command line : case sensitivity Starting the server
command line : starting the server Starting the server
command line : switches Some common command-line switches
CommBufferSize connection parameter : about Connection parameters
COMMBUFFERSIZE connection parameter : TCP/IP Tuning TCP/IP performance
CommBufferSpace connection parameter : about Connection parameters
COMMENT statement : automatic commit Using transactions
comments : auditing Adding audit comments
COMMIT statement : and transactions Using transactions
COMMIT statement : compound statements Atomic compound statements
COMMIT statement : cursors Cursors and transactions
COMMIT statement : JDBC Notes on JDBC connections
COMMIT statement : LTM Enter data at the primary site for replication
COMMIT statement : procedures and triggers Transactions and savepoints in procedures and triggers
COMMIT statement : verify referential integrity Locking during inserts
committing transactions An overview of transactions
committing transactions : definition of An overview of transactions
CommLinks connection parameter : about Connection parameters
CommLinks connection parameter : switches and Selecting communications protocols
COMMMIT statement : remote data access Remote transaction management overview
communications : about CHAPTER 26. Client/Server Communications
communications : application layer The application layer
communications : compatibility Compatible protocol stacks
communications : complications Real world protocol stacks
communications : data link layer The data link layer
communications : multiple stacks Working with multiple protocol stacks
communications : network adapters Configuring your network adapter board
communications : network layer The network layer
communications : OSI Reference Model The protocol stack
communications : physical layer The physical layer
communications : stack compatibility How information is passed across a network
communications : supported Supported network protocols
communications : transport layer The transport layer
communications : troubleshooting Troubleshooting network communications
compareTo method : object comparisons Comparing Java objects
comparing values : for joins Data types in join columns
comparison operators : NULL values Testing a column for NULL
comparison operators : symbols Using comparison operators in the WHERE clause
comparisons : NULL values Testing a column for NULL
comparisons : sort orders Using comparison operators in the WHERE clause
comparisons : trailing blanks Using comparison operators in the WHERE clause
compatibility : Adaptive Server Enterprise CHAPTER 30. Transact-SQL Compatibility
completing transactions Using transactions
composite indexes Hash values
compound statements : atomic Atomic compound statements
compound statements : declarations Declarations in compound statements
compound statements : using Using compound statements
Computations. See Computed columns Computing values in the select list
COMPUTE clause : CREATE TABLE Defining computed columns
COMPUTE clause : unsupported Writing compatible queries
computed columns : creating Defining computed columns
computed columns : INSERT statements Inserting and updating computed columns
computed columns : Java Using computed columns with Java classes
computed columns : limitations Restrictions on computed columns
computed columns : triggers Inserting and updating computed columns
computed columns : UPDATE statements Inserting and updating computed columns
conceptual data modeling CHAPTER 13. Designing Your Database
conceptual database models : definition of Database design concepts
concurrency Introduction to concurrency
Using locks to ensure consistency
concurrency : about Three typical types of inconsistency
Particular concurrency issues
concurrency : and data definition statements Data definition statements and concurrency
concurrency : and locks Using locks to ensure consistency
concurrency : and performance Improving concurrency
concurrency : benefits of Introduction to concurrency
concurrency : consistency Three typical types of inconsistency
concurrency : data definition Particular concurrency issues
concurrency : how locking works How locking works
concurrency : improving Improving concurrency
concurrency : improving and indexes Special optimizations
concurrency : improving using indexes Reducing the impact of locking
concurrency : inconsistencies due to Typical inconsistencies
concurrency : inconsistency Three typical types of inconsistency
concurrency : ISO SQL/92 standard Three typical types of inconsistency
concurrency : locks How locking works
concurrency : primary keys Particular concurrency issues
concurrency : replication Replication and concurrency
concurrency : types of locks The four types of locks
concurrent transactions : blocking Transaction blocking
Locking conflicts
configuration file : creating LTM Configuring the LTM
configuration file : format for LTM Configuring the LTM
configuration file : LTM Configure and start the Adaptive Server Anywhere LTM
Configuring the LTM
configuration file : using Using configuration files
configuring : Adaptive Server Anywhere for Replication Server Configuring databases for Replication Server
Setting up the database for Replication Server
Run the setup script
configuring : LTM Configuring the LTM
conflicts : cyclical blocking Transaction blocking and deadlock
conflicts : locking Locking conflicts
conflicts : transaction blocking Transaction blocking
Locking conflicts
conflicts between locks The four types of locks
CONN connection parameter : about Connection parameters
connect : permission Creating new users
connecting : character sets Connection strings and character sets
connecting : integrated logins Controlling database access
connecting : Windows CE Using ODBC data sources on Windows CE
connection : creating Create a connection for the primary site
Create a connection for the replicate site.
connection parameters : about Connection parameters are passed as connection strings
Connection parameters
connection parameters : case sensitivity Connection parameters
connection parameters : conflicts Connection parameter priorities
connection parameters : data sources Working with ODBC data sources
connection parameters : embedded databases Connection parameter priorities
connection parameters : introduction Connection parameters specify connections
connection parameters : location of Assembling a list of connection parameters
connection parameters : priority Connection parameters
connection parameters : table of Connection parameters
connection string : about Assembling a list of connection parameters
connection strings : about Connection parameters are passed as connection strings
connection strings : character sets Connection strings and character sets
connection strings : introduction Connection parameters specify connections
connection strings : representing Connection parameters specify connections
Connection window : Java debugger The debugger windows
ConnectionName connection parameter : about Connection parameters
connections : about CHAPTER 2. Connecting to a Database
connections : default parameters Using default connection parameters
connections : definition Introduction to connections
connections : details Troubleshooting connections
connections : embedded database Connecting to an embedded database
connections : examples Simple connection examples
connections : from utilities Connecting from Adaptive Server Anywhere utilities
connections : Interactive SQL Interactive SQL connections
connections : jConnect URL Supplying a URL for the server
connections : JDBC Differences between client- and server-side JDBC
Establishing JDBC connections
connections : JDBC client applications Connecting from a JDBC client application
connections : JDBC defaults Notes on JDBC connections
connections : JDBC example Connecting from a JDBC client application
Establishing a connection from a server-side JDBC class
connections : JDBC in the server Establishing a connection from a server-side JDBC class
connections : local database Connecting to the sample database from Interactive SQL
connections : network Connecting to a server on a network
connections : overview Introduction to connections
connections : performance Server name caching for faster connections
connections : problems Troubleshooting connections
connections : programming interfaces Introduction to connections
connections : remote Remote transaction management overview
connections : simple Connecting to the sample database from Interactive SQL
connections : troubleshooting Troubleshooting connections
Testing that a server can be found
connection_property function : about Obtaining database statistics from a client application
consistency Using locks to ensure consistency
consistency : assuring using locks How locking works
consistency : correctness and scheduling Correctness
consistency : dirty reads Tutorial 1: The dirty read
Three typical types of inconsistency
Selecting at isolation level 0
Selecting at isolation level 1
consistency : during transactions Three typical types of inconsistency
consistency : effects of unserializable schedules Correctness
consistency : example of non-repeatable read Tutorial 2 - The non-repeatable read
consistency : ISO SQL/92 standard Three typical types of inconsistency
consistency : phantom rows Three typical types of inconsistency
Tutorial 3 - A phantom row
Tutorial 4 - Practical locking implications
How Adaptive Server Anywhere implements locking
Selecting at isolation level 2
Selecting at isolation level 3
consistency : repeatable reads Three typical types of inconsistency
Tutorial 2 - The non-repeatable read
Selecting at isolation level 1
Selecting at isolation level 2
consistency : two-phase locking Two-phase locking
consistency : versus isolation levels Isolation levels and consistency
Tutorial 3 - A phantom row
Tutorial 4 - Practical locking implications
How Adaptive Server Anywhere implements locking
consistency : versus typical transactions Typical transactions at various isolation levels
consistency avoiding dirty reads Using locks to ensure consistency
console : network performance Evaluating network performance
constraints : columns and tables Choosing constraints
constructors : about Class constructors
constructors : inserting data Inserting a Java object from SQL
constructors : Java A Java glossary
CONTINUE_AFTER_RAISERROR option : Open Client Characteristics of Open Client and jConnect connections
control statements : list Control statements
conventions : documentation Documentation conventions
conventions : file names File naming conventions
conversion errors : bulk loading Handling conversion errors on data import
copying : data with INSERT Adding new rows with SELECT
copying databases : replicating data and concurrency Replication and concurrency
correctness Correctness
Correlation names : self-joins Self-joins and correlation names
correlation names : table names The FROM clause: specifying tables
Self-joins and correlation names
cost estimation during optimization Cost estimation
COUNT(*) function Using count (*)
COUNT(*)function : NULL Aggregate functions and NULL
create connection statement Create a connection for the primary site
Create a connection for the replicate site.
CREATE DATABASE statement : Adaptive Server Enterprise Servers and databases
CREATE DATABASE statement : Java Ways of Java-enabling a database
New databases and Java
CREATE DATABASE statement : permissions Controlling permissions from the command line
Permission to execute file administration statements
CREATE DATABASE statement : using Initializing a database
CREATE DATABASE statement : utility database Using the utility database
CREATE DBSPACE statement : about Using additional dbspaces
CREATE DEFAULT statement : unsupported Defaults and rules
CREATE DOMAIN statement : Transact-SQL compatibility Defaults and rules
CREATE EXISTING TABLE statement : using Using the CREATE EXISTING TABLE statement
CREATE FUNCTION statement : about Creating user-defined functions
CREATE INDEX statement : and concurrency Data definition statements and concurrency
CREATE INDEX statement : example Using indexes to improve query performance
CREATE PROCEDURE statement : examples Creating procedures
CREATE PROCEDURE statement : parameters Declaring parameters for procedures
create replication definition statement Create a replication definition
CREATE RULE statement : unsupported Defaults and rules
CREATE statement : automatic commit Using transactions
create subscription statement Create a subscription for your replication
CREATE TABLE : example Creating tables
CREATE TABLE statement : and concurrency Data definition statements and concurrency
CREATE TABLE statement : command files Using Interactive SQL to work with database objects
CREATE TABLE statement : primary and foreign keys Creating primary and foreign keys
CREATE TABLE statement : proxy tables Using the CREATE TABLE statement
CREATE TABLE statement : temporary tables Loading data that does not match the table structure
CREATE TABLE statement : Transact-SQL Creating compatible tables
CREATE TRIGGER statement : about Creating triggers
CREATE VIEW statement : WITH CHECK OPTION clause Using the WITH CHECK OPTION clause
creating : a replication definition Create a replication definition
creating : a Replication Server connection Create a connection for the primary site
Create a connection for the replicate site.
creating : a subscription Create a subscription for your replication
creating : indexes Working with indexes
creating : tables Creating tables
creating : user IDs Creating new users
creating : views Creating views
cross joins Cross joins
cross joins : and self-joins Self-joins and cross joins
CT-library : about Open Clients, Open Servers, and TDS
current date and time : defaults Current date and time defaults
cursor positioning : troubleshooting Cursor management overview
cursor stability : avoiding lost updates Cursor stability
cursor stability : definition of Cursor stability
cursors : about Introduction to cursors
cursors : and LOOP statement Using cursors on SELECT statements in procedures
cursors : availability Availability of cursors
cursors : bookmarks Bookmarks and cursors
cursors : canceling Canceling cursor operations
cursors : choosing a type Choosing a cursor type
cursors : connection limit Managing the resources connections use
cursors : cursor stability Cursor stability
cursors : definition of Cursor stability
cursors : deleting through Modifying rows through a cursor
cursors : describing Describing result sets
cursors : Dynamic scroll Types of cursor
cursors : eliminating lost updates Transactions for which no updates are lost
cursors : fetching multiple rows Fetching multiple rows
cursors : fetching rows Fetching rows through a cursor
cursors : holding Configuring cursors on opening
cursors : in procedures Using cursors on SELECT statements in procedures
cursors : Insensitive Types of cursor
cursors : introduction Introduction to cursors
cursors : isolation level Configuring cursors on opening
cursors : No scroll Types of cursor
cursors : on SELECT statements Using cursors on SELECT statements in procedures
cursors : ordering of results Cursor stability
cursors : platforms Availability of cursors
cursors : preventing lost updates Cursor stability
cursors : procedures and triggers Using cursors in procedures and triggers
cursors : read only Types of cursor
cursors : savepoints Cursors and transactions
cursors : Scroll Types of cursor
cursors : scrollable Fetching with scrollable cursors
cursors : step-by-step Steps in using a cursor
cursors : transactions Configuring cursors on opening
Cursors and transactions
cursors : types Types of cursor
cursors : unique Types of cursor
cursors : updating Modifying rows through a cursor
cursors : uses of What you can do with cursors
cursors : using Working with cursors