Interpubs database – Sybase ADAPTIVE 15.0.2 User Manual
Page 60

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.