Sybase Adaptive Server Anywhere - Page 126

The Interactive SQL utility
108
♦ The following command, entered at a system prompt, runs the command
file mycom.sql against the current default server, using the user ID DBA
and the password SQL.
dbisql -c "uid=DBA;pwd=SQL" mycom.sql
♦ The following command, when entered on a single line at a system
prompt, adds a user to the current default database:
dbisql -c "uid=DBA;pwd=SQL" grant connect to joe identified by passwd
Starting Interactive SQL from Sybase Central
You can start Interactive SQL from Sybase Central in the following ways:
♦ Right-click a database, and select Open Interactive SQL from the popup
menu.
♦ Right-click a table, and select View Data from the popup menu.
Interactive SQL opens with the data in the table displayed in the Data
window.
♦ Right-click a stored procedure, and select Test from the popup menu.
Interactive SQL opens with a test script in the SQL Statements pane.
♦ Click Tools➤Adaptive Server Anywhere➤Open Interactive SQL.
Examples