Next / Previous / Index / ITC Help System / Publications / Site map / NM Tech homepage

Starting the Sybase SQL server

Tech Computer Center logo

Sybase SQL Server is a program that works behind the scenes to allow you to create databases, enter data and analyze your data.

You do not work directly with Sybase SQL Server. Instead, to work with your data, you use several utility programs that communicate with Sybase SQL Server. The most frequently used utility is sqsh, a program that allows you to insert data into your database, search through your data, and delete data.

  1. To start sqsh, type this Unix command:
            sqsh
    On your screen you see:
            sqsh 0.8 Copyright (C) 1995, 1996 Scott C. Gray
            This is free software with ABSOLUTELY NO WARRANTY
            For more information type '\warranty'
            Password:
  2. Type your password and press Enter.
  3. On your screen you see a period, the name of the database the TCC has created for you, another period, the number one and then the > (greater-than) symbol. For instance, if your database name is rolodex, you see
            .rolodex.1>
    The number is a counter. It keeps track of how many lines you have typed in the current command set. Since you haven't typed any, the counter is at one. When you press enter, it will increment. When you type the command go the counter will reset to 1 because go ends a command set.

    If you see

            Msg 4002, Level 14, State 1
            Server '', Line 1
            Login failed.
            DB-LIBRARY error (severity 2):
            Login incorrect.
            DB-Library: Login incorrect.
    then you've mis-typed your password. Don't panic; just restart sqsh and be careful to use the password the TCC sent you when you were given permission to use Sybase SQL Server.
    Next: Typing Sybase SQL commands
    See also: Using the Sybase database system
    Previous: Setting up your account to use Sybase
    Site map
    Index: Keyword index to help pages
    Help: New Mexico Tech Information Technology and Communications: Help System
    ITC Publications
    To report a problem: File a ticket
    Send mail to the User consultant on duty or call them at 575-835-5437
    Home: About New Mexico Tech

    Maintained by John Shipman, john@nmt.edu; original by Steve Anderson
    Last updated: 1997/06/25 19:06:21 UT
    URL: http://www.nmt.edu/tcc/help/db/sybase/sqsh.html
    QR two-dimensional bar code