Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search

ASA User's Guide [Table of Contents] Part 1  Working with Databases

ASA User's Guide

[-] About This Book

About This Book

About This Manual


This manual describes how to use Adaptive Server Anywhere. It includes material needed to develop applications that work with Adaptive Server Anywhere and material for designing, building, and administering Adaptive Server Anywhere databases.


This manual is for all users of Adaptive Server Anywhere.

Before you begin

This manual assumes that you have an elementary familiarity with database management systems and Adaptive Server Anywhere. If you do not, you should consider readig the First Guide to SQL Anywhere Studio before reading this manual.

Online documentation more current

The printed version of this book may not be updated with each maintenance release of Adaptive Server Anywhere. The online Help version is updated with each maintenance release.

Adaptive Server Anywhere documentation

The Adaptive Server Anywhere documentation consists of the following books:

The format of these books (printed or online) may depend on the product in which you obtained Adaptive Server Anywhere.

Depending on which package you have purchased, you may have additional books describing other components of your product.

Documentation conventions

This section lists the typographic and graphical conventions used in this documentation.

Syntax conventions

The following conventions are used in the SQL syntax descriptions:

Graphic icons

The following icons are used in this documentation:




A client application.


A database server, such as Sybase Adaptive Server Anywhere or Adaptive Server Enterprise.


An Adaptive Server Anywhere database server.


A SQL Remote Message Agent


A Sybase Replication Server.


A Replication Agent. A replication agent is required for a database to act as a primary data site in Sybase Replication Server installations.

Installed files

The following terms are used throughout the manual:

The sample database

There is a sample database included with Adaptive Server Anywhere. Many of the examples throughout the documentation use this sample database.

The sample database represents a small company. It contains internal information about the company (employees, departments, and financial data) as well as product information (products), sales information (sales orders, customers, and contacts), and financial information (fin_code, fin_data).

The following figure shows the tables in the sample database and how they are related to each other.


The sample database is held in a file named asademo.db, and is located in your installation directory.

ASA User's Guide [Table of Contents] Part 1  Working with Databases