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

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Administering Your Database » SQL Anywhere graphical administration tools » Using Interactive SQL

 

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)
To start Interactive SQL (Windows)
  1. From the Start menu, choose Programs » SQL Anywhere 11 » Interactive SQL.

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

  3. Click OK.

To start Interactive SQL (Sybase Central)
  1. From the Tools menu, choose SQL Anywhere 11 » Open Interactive SQL.

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

  3. Click OK.

Tip

You can also use one of the following methods to access Interactive SQL from Sybase Central:

  • Selecting a database, and choosing Open Interactive SQL from the File menu.

  • Right-clicking a database, and choosing Open Interactive SQL.

  • Right-clicking a stored procedure, and choosing Execute From Interactive SQL. 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.

Starting Interactive SQL on Unix
To start Interactive SQL (Unix command line)
  1. In a terminal session, run the following command:

    dbisql
  2. Enter the connection information for your database in the Connect window.

  3. Click OK.

To start Interactive SQL (Mac OS X)
  1. In the Finder, double-click Interactive SQL in /Applications/SQLAnywhere11.

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

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 11.

To start Interactive SQL (Linux desktop icons)
  1. From the Applications menu, choose SQL Anywhere 11 » Interactive SQL

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

  3. Click OK.

Note

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