| 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 : 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 |