Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Starting Interactive SQL

There are several ways you can start Interactive SQL: from a command prompt, from the Windows Start menu, and from within Sybase Central.

To start Interactive SQL (command prompt)

• Execute a dbisql command from a command prompt.

  If you omit the -c option, which specifies the connection parameters for the database, or if you supply insufficient connection parameters, the Connect dialog appears, where you can enter connection information for the database.

  For more information about the supported options, see Interactive SQL utility (dbisql).

  The following command starts Interactive SQL and connects to the sample database:

  dbisql -c "UID=DBA;PWD=sql;DSN=SQL Anywhere 10 Demo"

To start Interactive SQL (Windows)

1. From the Start menu, choose Programs > SQL Anywhere 10 > Interactive SQL.

   Interactive SQL opens, and the Connect dialog appears.

2. Enter the connection information for your database in the Connect dialog.

To start Interactive SQL (Sybase Central)

1. From the Tools menu, choose SQL Anywhere 10 > Open Interactive SQL.

   Interactive SQL opens, and the Connect dialog appears.

2. Enter the connection information for your database in the Connect dialog.

The following steps can be used if you are using a version of Linux that supports the Linux Desktop icons and if you chose to install them when you installed SQL Anywhere 10.

To start Interactive SQL (Linux Desktop icons)

1. Open the SQL Anywhere 10 folder on your desktop.

2. Double-click Interactive SQL.

   Interactive SQL opens, and the Connect dialog appears.

3. Enter the connection information for your database in the Connect dialog.

Note The following steps assume that you have already sourced the SQL Anywhere utilities. See Setting environment variables on Unix and Mac OS X.

To start Interactive SQL (Unix command line)

1. In a terminal session, enter the following command:

   dbisql

   Interactive SQL opens, and the Connect dialog appears.

2. Enter the connection information for your database in the Connect dialog.

Tip You can also access Interactive SQL from within Sybase Central in the following ways: Selecting a database, and choosing Open Interactive SQL from the File menu. Right-clicking a database, and choosing Open Interactive SQL from the popup menu. Right-clicking a stored procedure, and choosing Execute from Interactive SQL from the popup menu. Interactive SQL opens with a CALL to the procedure in the SQL Statements pane and executes the stored procedure. Right-clicking a table or view and choosing View Data in Interactive SQL. Interactive SQL opens with a SELECT * FROM table-name and executes the query.