vi
Transact-SQL User’s Guide – documents Transact-SQL, Sybase’s
enhanced version of the relational database language. This manual serves
as a textbook for beginning users of the database management system.
This manual also contains descriptions of the pubs2 and pubs3 sample
databases.
System Administration Guide – provides in-depth information about
administering servers and databases. This manual includes instructions
and guidelines for managing physical resources, security, us er and syst em
databases, and specifying character conversion, international language,
and sort order settings.
Reference Manual – contains detailed information about all Transact-SQL
commands, functions, procedures, and datatypes. This manual also
contains a list of the Transact-SQL reserved words and definitions of
system tables.
Performance and Tuning Guide – explains how to tune Adaptive Server
for maximum performance. This manual includes information about
database design issues that affect performance, query optimization, how to
tune Adaptive Server for very large databases, disk and cache issues, and
the effects of locking and cursors on performance.
•The Utility Guide – documents the Adaptive Server utility programs, such
as isql and bcp, which are executed at the operating-system level.
•The Quick Reference Guide – provides a comprehensive listing of the
names and syntax for commands, functions, system procedures, extended
system procedures, datatypes, and utilities in a pocket-sized book.
Available only in print.
•The System Tables Diagram – illustrates system tables and their entity
relationships in a poster format. Available only in print.
Error Messages and Troubleshooting Guide – explains how to resolve
frequently occurring error messages and describes solutions to system
problems frequently encountered by users.
Component Integration Services User’s Guide – explains how to use the
Adaptive Server Component Integration Services feature to connect
remote Sybase and non-Sybase databases.
Java in Adaptive Server Enterprise – describes how to install and use Java
classes as datatypes, functions, and stored procedures in the Adaptive
Server database.