Sybase

1. If you have not already done so, set database-specific environment variables:

C Shell: setenv SYBASE sybase_directory
Bourne/Korn Shell:	SYBASE=sybase_directory
	export SYBASE

where sybase_directory is the directory containing the Sybase interfaces file.

2. Since the tutorials require data from a database, as well as dynamic SQL and Stored Procedures to manipulate the data, you will have to load the pubs2 database which comes with Sybase. Unless you have an "sa" account on the database, your database administrator will have to perform this step.

	$SYBASE/bin/isql -Uuser -Sserver -i$SYBASE/scripts/installpubs2


 user: 	the dbo's (database owner's) username

 server:	the name of the server on which to install pubs2

Note: If you already have a database called pubs2, you will need to remove it before running these scripts.

3. Unless you have an "sa" account on the database, your database administrator will have to perform this step.

	$SAPPHIRE/bin/loadtuts sa  servername 


 sa:	the owner of pubs2

 servername:	the name of the server on which you installed pubs2

4. To load the tutorial's DSQL Objects into the correct location, at the command line type:

	$SAPPHIRE/bin/install_db servername owner  S


 servername:	the name of the server where pubs2 is located

 owner: 	the username of the pubs2 database owner (should be dbo)

 S:	Vendor Type should always be S for Sybase

5. Copy the DSQL Objects into your DSQLDIR by typing:

	cp $SAPPHIRE/tutorials/dsql/* $HOME/dsql

6. Finally, grant connect privileges to all potential users of the pubs2 database.