Starting Interactive SQL

The menu item Open Interactive SQL opens a connection to a server. However, when you select the menu item for a server, Interactive SQL opens a connection to the default database for that server. When you select a specific database from the Open Interactive SQL menu, Interactive SQL opens to the selected database.

Starting Interactive SQL from Sybase Central

1. To start Interactive SQL, either:

   • Select a database in Sybase Central and select File | Open Interactive SQL. Interactive SQL connects to the database. You can also right-click on the database and select Open Interactive SQL.

   • To start Interactive SQL without a connection to a server, select Tools | Adaptive Server Enterprise | Open Interactive SQL. The Connect dialog appears.

Starting Interactive SQL from the command line

How you start Interactive SQL from the command line depends on your operating system.

• If you start Interactive SQL independently, the Connect dialog appears, which lets you connect to a database just as you would in Sybase Central.

• • For UNIX, Sybase Central and Interactive SQL do not have to be installed under $SYBASE ($SYBASE does not even need to exist for them to start). Instead, they are installed under $SYBROOT, an environment variable set by the installer. Move to $SYBROOT and enter:

    dbisql
    

    On Windows, change to the %SYBROOT directory and enter:

    dbisql.bat
    

    For the Mac OS, open the Interactive SQL application under the /Applications/Sybase folder.

  • In the Connection dialog, enter the information to connect to a database in the Connect dialog box and click OK.

To open a new Interactive SQL window:

1. Choose Window | New Window. The Connect dialog appears.

2. In the Connect dialog, enter connection options, and click OK to connect.

   The connection information (including the database name, your user ID, and the database server) appears on the title bar above the SQL Statements pane.

You can also connect to or disconnect from a database with the Connect and Disconnect commands in the SQL menu, or by executing a connect or disconnect statement in the SQL Statements pane.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF