Interpubs database – Sybase ADAPTIVE 15.0.2 User Manual

Page 60

Advertising
background image

Installing sample databases

44

Adaptive Server Enterprise

From the Adaptive Server scripts directory
($SYBASE/$SYBASE_ASE/scripts), use

isql

to log in to Adaptive Server

and run the script:

isql -Usa -P***** -Sserver_name -iscript_name

Where:

server_name – represents the destination server for the database

script_name – is the full path to and file name of the script to run

For example, to install

pubs2

on a server named VIOLIN, enter:

isql -Usa -P***** -SVIOLIN \

-i $SYBASE/$SYBASE_ASE/scripts/installpubs2

5

To install the

image

data associated with

pubs2

(

pubs3

does not use

image

data), run:

isql -Usa -Ppassword -Sservername \

-i $SYBASE/$SYBASE_ASE/scripts/installpix2

Note

The

image

data requires a fair amount of space—there are six pictures,

two each in the PICT, TIFF, and Sun raster file formats. Run installpix2 script
only to use or test the

image

datatype. Sybase does not supply any tools for

displaying

image

data. You must use appropriate window graphics tools to

display the images after you have extracted them from the database.

For more information about running these scripts, see the configuration guide
for your platform.

interpubs database

interpubs

is a database similar to

pubs2

that contains French and German data.

This data contains 8-bit characters and is available for use at Adaptive Server
installations using the ISO 8859-1 (iso_1), ISO 8859-15 (iso15), Roman8, or
Roman9 (for HP-UX) character set. To display the French and German data
correctly, you must set up your terminal to display 8-bit characters.

v

Installing the interpubs database

1

Be sure iso_1, iso15, Roman8, Roman 9, or UTF-8 is installed as the
default character set or as an additional character set.

Advertising