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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Interactive SQL

 

Starting Interactive SQL

You can use Interactive SQL to connect to a SQL Anywhere database, an UltraLite database, an SAP Sybase IQ database, an SAP HANA database, or a generic ODBC database.

Prerequisites

  • Linux   You must have a version of Linux that supports the Linux desktop icons, and they must have been installed when you installed SQL Anywhere.

  • Unix and Mac OS X   The SQL Anywhere utilities must already be sourced. See Unix and Mac OS X environment variables.

 Task
  • Open Interactive SQL and connect to a database.

    Option Action
    Command line and/or Unix

    Run the following command:

    dbisql

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

    Windows
    1. Click Start » Programs » SQL Anywhere 16 » Administration Tools » Interactive SQL.

    2. Click Change Database Type and choose the type of database to connect to. You can connect to a SQL Anywhere database, an UltraLite database, an SAP Sybase IQ database, an SAP HANA database, or a generic ODBC database.

      For example, to connect to a SQL Anywhere database, click Change Database Type and click SQL Anywhere.

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

    4. Click Connect.

    Sybase Central
    1. Click Tools » SQL Anywhere 16 » Open Interactive SQL.

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

    3. Click Connect.

    Tip

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

    • Selecting a database, and clicking File » Open Interactive SQL.

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

    • Right-clicking a stored procedure, and clicking 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 clicking View Data In Interactive SQL. Interactive SQL opens with a SELECT * FROM table-name and executes the query.

    Mac OS X
    1. In the Finder, double-click Interactive SQL in /Applications/SQLAnywhere16.

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

    3. Click Connect.

    Linux
    1. Click Applications » SQL Anywhere 16 » Administration Tools » Interactive SQL.

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

    3. Click Connect.

Results

Interactive SQL is started and you are connected to the database.

Example

To start Interactive SQL and connect to the sample database from the command line, run the following command:

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

 See also