There are several ways you can start Interactive SQL: from a command prompt, from the Windows Start menu, and from within Sybase Central.
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. See Connection parameters.
To start Interactive SQL and connect to the sample database, run the following command:
dbisql -c "UID=DBA;PWD=sql;DSN=SQL Anywhere 12 Demo" |
For information about the supported options, see Interactive SQL utility (dbisql).
From the Start menu, choose Programs » SQL Anywhere 12 » Administration Tools » Interactive SQL.
Enter the connection information for your database in the Connect window.
For example, to connect to the SQL Anywhere sample database:
In the Authentication field, choose Database.
From the Action dropdown menu list choose Connect With An ODBC Data Source.
Click ODBC Data Source Name, and then in the box below type SQL Anywhere 12 Demo.
Click Connect.
From the Tools menu, choose SQL Anywhere 12 » Open Interactive SQL.
Enter the connection information for your database in the Connect window.
For example, to connect to the SQL Anywhere sample database:
In the Authentication field, choose Database.
From the Action dropdown menu list choose Connect With An ODBC Data Source.
Click ODBC Data Source Name, and then in the box below type SQL Anywhere 12 Demo.
Click Connect.
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.
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |