Using Sybase

Sybase SQL Server is very similar to Microsoft SQL Server (prior to version 7), and they share many of the same tools and utilities. One command line utility that is available in every Sybase installation is iSQL (which is also included with Microsoft SQL Server). To use iSQL, do the following:

  1. Execute the iSQL application. (It is a command line application that resides in the Sybase directory.) You must specify a login name using the -U parameter, a password using the -P parameter, and a server name using the -S parameter.

  2. You'll be prompted with a 1>. This is the first line on which you type your SQL statement. (You may type the SQL on one line or broken over many lines.)

  3. Keep typing your SQL statement, pressing Enter at the end ...

Get Sams Teach Yourself SQL in 10 Minutes now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.