Getting Started With SYBASE .....

Registering for a Sybase Account

Please see the Sybase Registration Page and follow the directions. If this is the first time you've used the CISE secure web server, accept the web server certificate. While entering your sybase password, the following points should carefully be noted.

1. The password should be LONGER than 6 characters.
2. The password should contain at least one special character (#, !, @ etc.).
3. The password should contain TWO non-alphabetic characters. (digits)
4. The Sybase password has to be different from the CISE password.

The Sybase password requires 6 hours to get activated before you can start using it. Please be patient and check it the next day. Once your sybase password is activated, try out the following tutorial.

At the unix prompt, type the following:

    source /local/etc/sybase.cshrc
    sqsh

    sqsh-1.7 Copyright (C) 1995-1999 Scott C. Gray
    This is free software with ABSOLUTELY NO WARRANTY
    For more information type '\warranty'
    Password:  <ENTER YOUR PASSWORD HERE> 

If your password has successfully worked here, then you have been able to enter the Sybase database system.

Let us play with some basic sybase commands

• 1> sp_who
  2> go
  

  For each process being run, sp_who reports the server process ID, its status, the login name of the process user, the name of the host computer, the server process ID of a process that's blocking this one (if any), the name of the database, and the command being run.

• 1> sp_helpgroup
  2> go
  

  The sp_helpgroup reports on groups within a database

• 1> sp_helprotect
  2> go 
  

  The system procedure sp_helprotect reports on permissions by database object or by user, and (optionally) by user for a specified object. Any user can execute this procedure.

Back to Sybase Home Page