Filter
Top Products
Installing sample databases
42 Adaptive Server Enterprise
The reports provided by SAMreport belong to three report families:
• Summary reports – summarize usage information about each feature used
from the license server.
• Raw reports – show individual usage detail in textual format.
• Server reports – provide details about a given license server.
For more information on SAMreport, see Chapter 5, “Using SySAM for Asset
Management” in the Sybase Software Asset Management User’s Guide.
Installing sample databases
This section describes how to install the U.S. English and international
language sample databases. For installation instructions specific to each
sample database, see the following sections:
• “Running the database scripts” on page 43
• “Installing the interpubs database” on page 44
• “Installing the jpubs database” on page 45
The sample databases contain information about a fictitious business. You can
use this information to learn about the Sybase products, without affecting
essential data.
Table 3-1 lists the scripts that you can use to install the sample databases.
Table 3-1: Sample database scripts
Script Description
installpubs2 Installs the
pubs2 sample database.
This database contains data that represents a publishing operation. Use this database to test your
server connections and to learn Transact-SQL. Most of the examples in the Adaptive Server
documentation query the pubs2 database.
installpubs3 Installs the pubs3 sample database.
This updated version of
pubs2 uses referential integrity. In addition, its tables are slightly different
than the tables used in
pubs2. Where noted, the Adaptive Server documentation uses the pubs3
database in its examples.