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.

Prérequis

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

Click Start » Programs » SQL Anywhere 16 » Administration Tools » Interactive SQL.
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.
Enter the connection information for your database in the Connect window.
Click Connect.

Sybase Central

Click Tools » SQL Anywhere 16 » Open Interactive SQL.
Enter the connection information for your database in the Connect window.
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

In the Finder, double-click Interactive SQL in /Applications/SQLAnywhere16.
Enter the connection information for your database in the Connect window.
Click Connect.

Linux

Click Applications » SQL Anywhere 16 » Administration Tools » Interactive SQL.
Enter the connection information for your database in the Connect window.
Click Connect.

Résultat

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

Exemple

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"

Starting Interactive SQL

Task

Tip

See also