| RAISERROR statement : ON EXCEPTION RESUME | Transact-SQL-like error handling in the Watcom-SQL dialect |
| RAISERROR statement : Transact-SQL | Using the RAISERROR statement in procedures |
| range queries | Using ranges (between and not between) in the WHERE clause |
| read locks | The four types of locks The four types of locks Locking during deletes |
| read only cursors : about | Types of cursor |
| read-only media : deploying | Deploying databases on read-only media |
| reading access plans | Reading access plans |
| reading entity-relationship diagrams | Relationships |
| recovery : about | CHAPTER 20. Backup and Data Recovery |
| recovery : media failure | Recovery from media failure |
| recovery : rapid | Using a live backup for machine redundancy |
| recovery : switch | Running in special modes |
| recovery : system failure | Recovery from system failure |
| recovery : transaction log | The transaction log |
| recovery : transaction log mirrors | Using a transaction log mirror |
| recovery : uncommitted changes | Recovering uncommitted changes |
| recovery : urgency | Checkpoint priority |
| RECOVERY_TIME option : using | Checkpoint priority |
| redirecting : error messages to files | Using output redirection |
| redirecting : output to files | Using output redirection |
| REFERENCES permissions | Granting permissions on tables and views |
| referential integrity : actions | Referential integrity actions |
| referential integrity : breached by client application | If a client application breaches referential integrity |
| referential integrity : checking | Referential integrity checking |
| referential integrity : enforcing | Enforcing entity and referential integrity |
| referential integrity : losing | Losing referential integrity |
| referential integrity : orphans | Locking during inserts |
| referential integrity : permissions | Permissions for data modification |
| referential integrity : verification at commit | Locking during inserts |
| reflexive relationships | Relationships |
| registry : deploying | Deploying ODBC clients Deploying connection information |
| registry : ODBC | Deploying connection information |
| relational model : joins and | Joins and the relational model |
| relationships : about | Relationships |
| relationships : cardinality of | Relationships |
| relationships : changing to an entity | Changing many-to-many relationships into entities |
| relationships : choosing | Step 1: Identify entities and relationships |
| relationships : definition of | Database design concepts |
| relationships : mandatory versus optional | Relationships |
| relationships : many-to-many | Relationships |
| relationships : one-to-many | Relationships |
| relationships : one-to-one | Relationships |
| relationships : reflexive | Relationships |
| relationships : resolving | Step 4: Resolve the relationships |
| relationships : roles | Relationships |
| RELEASE SAVEPOINT statement | Savepoints within transactions Savepoints within transactions |
| relocatable : defined | Configuring memory for Java |
| remote data : location | Specifying proxy table locations |
| remote data access : about | CHAPTER 28. Accessing Remote Data |
| remote data access : case sensitivity | Case sensitivity |
| remote data access : DataWindows | Accessing remote data from PowerBuilder DataWindows |
| remote data access : internal operations | Internal operations |
| remote data access : introduction | Introduction |
| remote data access : passthrough mode | Sending native statements to remote servers |
| remote data access : PowerBuilder | Accessing remote data from PowerBuilder DataWindows |
| remote data access : remote servers | Working with remote servers |
| remote data access : SQL Remote unsupported | Features not supported for remote data |
| remote data access : troubleshooting | Troubleshooting remote data access |
| remote data access : unsupported features | Features not supported for remote data |
| remote databases : replication | Replication and concurrency |
| remote procedure calls : about | Using remote procedure calls (RPCs) |
| remote servers : about | Working with remote servers |
| remote servers : altering | Altering remote servers Altering remote servers using Sybase Central |
| remote servers : classes | CHAPTER 29. Server Classes for Remote Data Access Overview |
| remote servers : creating | Creating remote servers Creating remote servers using Sybase Central |
| remote servers : deleting | Deleting remote servers Deleting remote servers using Sybase Central |
| remote servers : external logins | Working with external logins |
| remote servers : listing properties | Listing remote server capabilities |
| remote servers : Sybase Central | Creating remote servers using Sybase Central |
| remote servers : transaction management | Transaction management and remote data |
| remote tables : about | Remote table mappings |
| remote tables : accessing | CHAPTER 28. Accessing Remote Data |
| remote tables : listing | Listing the remote tables on a server |
| remote tables : listing columns | Listing the columns on a remote table |
| repeatable reads | Three typical types of inconsistency Tutorial 2 - The non-repeatable read Selecting at isolation level 1 Selecting at isolation level 2 |
| replicate minimal columns : support for | Configuring tables for replication |
| REPLICATE ON clause | Create the table for the primary database |
| replicate site : adding Replication Server information | Add Replication Server information to the replicate database |
| replicate site : Replication Server | Replicate sites and primary sites |
| replicate site : uses of LTM at | Primary site components |
| replicate sites : creating | Set up the Adaptive Server Anywhere databases |
| replicate sites : Replication Server | Replicate site components |
| replication : backup procedures | Transaction log and backup management Using the DELETE_OLD_LOGS option |
| replication : benfits | Introduction to replication |
| replication : buffering | Replicating transactions in batches |
| replication : concurrency | Replication and concurrency |
| replication : concurrency issues | Particular concurrency issues |
| replication : creating a replication definition | Create a replication definition |
| replication : defining | Configuring tables for replication |
| replication : introduction | Introduction to replication |
| replication : Java objects | Java objects and class versions |
| replication : of an entire database | Replicating an entire database |
| replication : of procedures | Preparing procedures and functions for replication SQL Statements for controlling procedure replication |
| replication : setting flag | Create the table for the primary database |
| replication : stored procedures | SQL Statements for controlling procedure replication |
| replication : transaction log management | Transaction log and backup management Using the DELETE_OLD_LOGS option |
| Replication Server : Adaptive Server Anywhere character sets | Character set issues |
| Replication Server : Adaptive Server Anywhere collations | Character set issues |
| Replication Server : backup procedures | Transaction log and backup management |
| Replication Server : creating a connection | Create a connection for the primary site |
| Replication Server : Creating a connection | Create a connection for the replicate site. |
| Replication Server : creating a replication definition | Create a replication definition |
| Replication Server : creating a subscription | Create a subscription for your replication |
| Replication Server : preparing Adaptive Server Anywhere databases | Add Replication Server information to the replicate database |
| Replication Server : primary site | Create a connection for the primary site |
| Replication Server : primary sites | Primary site components |
| Replication Server : purposes | Sybase replication technologies |
| Replication Server : replicate site | Create a connection for the replicate site. |
| Replication Server : replicate sites | Replicate site components |
| Replication Server : replicating an entire database | Replicating an entire database |
| Replication Server : replicating procedures | Preparing procedures and functions for replication SQL Statements for controlling procedure replication SQL Statements for controlling procedure replication |
| Replication Server : rssetup.sql script | Add Replication Server information to the primary database |
| Replication Server : starting a Adaptive Server Anywhere server | Start the database servers |
| Replication Server : support | Sybase applications and Adaptive Server Anywhere |
| Replication Server : supported versions | Primary site components |
| Replication Server : transaction log management | Transaction log and backup management |
| Replication Server Adaptive Server Anywhere configuration | Configuring databases for Replication Server Setting up the database for Replication Server Run the setup script |
| replications : Replication Server | Replicate sites and primary sites |
| reserved words : remote servers | Features not supported for remote data |
| reserved words : SQL and Java | Keyword conflicts |
| RESETUP.SQL script : about | Setting up the database for Replication Server |
| RESETUP.SQL script : preparing to run | Prepare to run the setup script |
| RESETUP.SQL script : running | Run the setup script |
| RESIGNAL statement : about | Using exception handlers in procedures and triggers |
| resolving : relationships | Step 4: Resolve the relationships |
| RESOURCE authority : about | RESOURCE authority overview |
| RESOURCE authority : granting | Granting DBA and RESOURCE authority |
| RESOURCE authority : not inheritable | Managing groups |
| RESTRICT action : about | Referential integrity actions |
| restrictions : remote data access | Features not supported for remote data |
| result sets : and local variables | Returning result sets from Transact-SQL procedures |
| result sets : and temporary tables | Returning result sets from Transact-SQL procedures |
| result sets : cursors | Introduction to cursors |
| result sets : describing | Describing result sets |
| result sets : from Java | Returning result sets from Java methods |
| result sets : Java stored procedures | Returning result sets from Java methods |
| result sets : Java, and Interactive SQL | JDBC 1.1 limitations and Interactive SQL |
| result sets : metadata | Describing result sets |
| result sets : multiple | Returning multiple result sets from procedures |
| result sets : permissions | Returning result sets from procedures |
| result sets : procedures | Returning procedure results in result sets Returning result sets from procedures |
| result sets : Transact-SQL | Returning result sets from Transact-SQL procedures |
| result sets : using | Working with cursors |
| result sets : variable | Returning variable result sets from procedures |
| retrieving objects | Creating distributed applications |
| RETURN statement : about | Returning a value using the RETURN statement |
| return types : external functions | External function return types |
| return values : procedures | Error handling in Transact-SQL procedures |
| REVOKE statement : about | Revoking user permissions |
| REVOKE statement : and concurrency | Data definition statements and concurrency |
| REVOKE statement : Transact-SQL | Users and groups |
| right-outer joins : FROM clause | Inner, left-outer, and right-outer joins |
| roles : Adaptive Server Enterprise | Administrative roles |
| roles : definition of | Relationships |
| ROLLBACK : TO SAVEPOINT statement | Savepoints within transactions |
| rollback log : about | The rollback log |
| rollback log : savepoints | Savepoints within transactions |
| ROLLBACK statement | Savepoints within transactions |
| ROLLBACK statement : and transactions | Using transactions |
| ROLLBACK statement : compound statements | Atomic compound statements |
| ROLLBACK statement : cursors | Cursors and transactions |
| ROLLBACK statement : definition of | An overview of transactions |
| ROLLBACK statement : log | The rollback log |
| ROLLBACK statement : procedures and triggers | Transactions and savepoints in procedures and triggers |
| ROLLBACK statement : triggers | Transact-SQL trigger overview |
| ROLLBACK TO SAVEPOINT statement : cursors | Cursors and transactions |
| rolling back | An overview of transactions |
| rolling back : transactions | An overview of transactions |
| rolling back transactions | Using transactions |
| row-level locking : about | Using locks to ensure consistency |
| rows : copying with INSERT | Adding new rows with SELECT |
| rows : selecting | The WHERE clause: specifying rows |
| RS parameter | Configure and start the Adaptive Server Anywhere LTM |
| rssetup.sql command file | Add Replication Server information to the primary database Add Replication Server information to the replicate database |
| RS_pw parameter | Configure and start the Adaptive Server Anywhere LTM |
| RS_source_db parameter | Configure and start the Adaptive Server Anywhere LTM |
| RS_source_ds parameter | Configure and start the Adaptive Server Anywhere LTM |
| RS_user parameter | Configure and start the Adaptive Server Anywhere LTM |
| rules : Transact-SQL | Defaults and rules |
| runtime classes : contents | The Sybase runtime Java classes |
| runtime classes : installing | Java-enabling a database |
| runtime classes : Java | Sybase runtime Java classes |
| runtime environment : Java | Managing the runtime environment for Java |