Sybase and its Documentation

Accessing Sybase

Please note that Sybase 11 is available only for SUN Sparc machines.

Steps for accessing SYBASE:

Log into your eos/unity account.

Type

	unsetenv DSQUERY
	unsetenv DSCONSOLE
	unsetenv SYBASE
	add csc_sybase

This command configures your path and sets the environment variables for accessing SYBASE. These variables are

	DSQUERY   : the name of the Sybase server you wish to access
        DSCONSOLE : the name of the Sybase server
	SYBASE    : the path to the sybase executables

The current Sybase server is remus.csc.ncsu.edu

To begin using the Sybase system, type
```
	isql
```
isql will prompt for your Sybase password, which should be your social security number without any hyphens.
There is a graphical tool, wisql, which is a lot nicer to use than isql. To use this tool
```
	add tcl
	add csc_sybase
	wisql
```
wisql too asks for your Sybase password.

If your login fails on either of the above that means your account is not set up. In this case, please contact software@csc.ncsu.edu indicating that you are taking a database course.

Information about Sybase

There is online documentation about Sybase, called Sybooks. Type

	add csc_sybase
	sybooks

This brings up the DynaText Library. Information on using isql can be found in the following places.

  Collection: SYBASE SQL Server Release 10.0.2
  Book:       SYBASE SQL Server Utility Programs for UNIX
  Chapter:    3

A description of all Commands can be found at.

  Collection: SYBASE SQL Server Release 10.0.2
  Book:       SYBASE SQL Server Reference Manual, Volumes I, II