pubs2
database which comes with Sybase. The following steps load the pubs2
database to the server, create the necessary Stored Procedures for the tutorials, and grant the correct permissions to use them:
setenv SYBASE sybase-distribution-directory
setenv SAPPHIRE distribution-directory
SYBASE=sybase-distribution-directory; export SYBASE
SAPPHIRE=distribution-directory; export SAPPHIRE To load
the pubs2
database, at the command line type:
$SYBASE/bin/isql -Uuser -Sservername- i$SYBASE/scripts/installpubs2
pubs2.
pubs2
database, type the following at the command line
$SAPPHIRE/bin/loadtuts sa servername
pubs2
$SAPPHIRE/bin/install_db servername owner S
pubs2
database owner (should be dbo)
setenv SAPPHIRE distribution-directory
SAPPHIRE=distribution-directory; export SAPPHIRE
$SAPPHIRE/bin/build_pubs2_ora user pword database 0
$SAPPHIRE/bin/install_db sid owner O
setenv INFORMIXDIR informix-distribution-directory
setenv SAPPHIRE distribution-directory
INFORMIXDIR=informix-distribution-directory; export INFORMIXDIR
SAPPHIRE=distribution-directory; export SAPPHIRE
$SAPPHIRE/bin/build_pubs2_inf server
$SAPPHIRE/bin/install_db server owner I
I
for Informix.