Installing sample databases
46 Adaptive Server Enterprise
-Sservername -i
%SYBASE%\%SYBASE_ASE%\scripts\instpix2
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 instpix2 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.
2 Determine the type (raw partition, logical volume, operating system file,
and so on) and location of the device where you will be storing the
interpubs database. You will need to provide this information later.
3 Make a copy of the original installintpubs script. Be sure you can access
this copy, in case you experience problems with the edited script.
4 Use a text editor to edit the script, if necessary, to specify a default device
other than the
master device, or use sp_diskdefault.
5 Execute the script, using the
-J flag to ensure that the database is installed
with the correct character set:
isql -Usa -Ppassword -Sservername -Jroman8 -i
$SYBASE/$SYBASE_ASE/scripts/roman8/installintpubs
isql -Usa -Ppassword -Sservername -Jiso_1
-i %SYBASE%\%SYBASE_ASE\%scripts\iso_1\
installintpubs
