interactive SQL

To test this procedure from Interactive SQL, you can CALL it, specifying one of the departments of the company.

Connect to the sample database from Interactive SQL with a user ID of DBA and a password of SQL.

If engine-name is not specified in Interactive SQL, all running engines will be searched for a database of the specified name.

PROMPT Interactive SQL prompts the user to see if the user wishes to continue.

When not using this statement in Interactive SQL, the database is stopped only if it is started on the current database server.

To see the entire result set, export your query back to Interactive SQL by clicking OK.

If an index is no longer required, you can remove it from the database in Sybase Central or in Interactive SQL.

Profiling information is stored in memory by the server and can be viewed in Sybase Central via the Profile tab or in Interactive SQL.

The Plan tab is located at the bottom of the Interactive SQL window.

The UltraLite Plan tab appears at the bottom of the Interactive SQL window.

Interactive SQL will attempt to determine which format, based on information in the file.

The settings in this dialog are preserved for the current Sybase Central, Interactive SQL, or Adaptive Server Anywhere Console session only.

Interactive SQL Starts the Interactive SQL utility for sending SQL statements to a database.

You can create a view containing the results of this statement using either Sybase Central or Interactive SQL.

Options The Options dialog sets options for commands, appearance, importing and exporting data, and messages in Interactive SQL.

The following Interactive SQL example passes a SELECT statement as a string parameter and returns the plan for executing the query.

You can execute the examples in Interactive SQL, but the SQL statements are independent of the administration tool you use.

In this case, Interactive SQL sends each statement to the server individually, not as a batch.

The setting of the option COMMIT_ON_EXIT controls what happens to uncommitted changes when you exit Interactive SQL.

Determine that you can connect to a remote server using a client tool such as Interactive SQL before configuring Adaptive Server Anywhere.

To run the clean ups scripts, use ij, the interactive SQL scripting tool, present as ij.

You can perform these tasks using Sybase Central or with the CREATE PUBLICATION statement in Interactive SQL.

In the left pane, right click the sp_customer_products procedure and choose Execute from Interactive SQL from the popup menu.

For information about logging statements in Interactive SQL, see Logging commands.

Consultant can be run from either Sybase Central or Interactive SQL.

For more information about the Adaptive Server Anywhere utility for running SQL commands, see Using Interactive SQL.

Verify that the new data arrives in the client database using another interactive SQL session.

Execute the procedure again, and confirm that Interactive SQL displays the correct results.

CONTINUE The error is ignored and Interactive SQL continues executing statements.

This option is set only for the current Interactive SQL unless you click the Make Permanent button.

Interactive SQL can execute a command file containing multiple INPUT statements.

Enter an INPUT statement in the SQL Statements pane of the Interactive SQL window.

For more information about Interactive SQL and encodings, see DEFAULT_ISQL_ENCODING option [Interactive SQL].

UltraLite Interactive SQL has a window that displays the access plan of a query.

NOTIFY_EXIT The error is reported and the user is prompted to press Enter or click OK to terminate Interactive SQL.

Interactive SQL appears after a few seconds.

The Unload utility creates an Interactive SQL command file to rebuild your database.

If you execute this example from Interactive SQL, the message is displayed in the Messages pane.

In Interactive SQL, you can specify an option in a SET OPTION statement.

Interactive SQL prints a warning in the Messages pane if any string values are truncated on INPUT.

You can modify an existing procedure using either Sybase Central or Interactive SQL.

If using the INPUT or OUTPUT command, run Interactive SQL or the client application on the same machine as the database server.

To unload data onto a client machine, see OUTPUT statement [Interactive SQL].

If the option is set to DETECT, Interactive SQL will obtain the CharacterSet connection property from the server.

For information about using the INPUT statement to import data, see INPUT statement [Interactive SQL].

You do not need to change the command delimiter in Interactive SQL or Sybase Central when you write procedures.

A message box appears, asking if you want to debug the connection from Interactive SQL.

Checking for updates is done when you open Interactive SQL, Sybase Central, or the SQL Anywhere Console utility.

In Interactive SQL, you can view the plan for any SQL statement on the Plan tab in the Results pane.

You can delete a user from the database using both Sybase Central and Interactive SQL.

Using Interactive SQL, execute the following SQL statement, which adds an HTML service that exposes the SYS. SYSTABLE to HTTP users.

Any changes you make are discarded when UltraLite Interactive SQL closes, even if you commit your changes.

Start Interactive SQL and connect to your new database using the user ID DBA and the password SQL.

For more information about Interactive SQL, see The Interactive SQL utility.

Connect to the sample database with Interactive SQL.

For information on running command files from Interactive SQL, see Using SQL command files.

The following table provides a guide to where you can look for information about how to run and use Interactive SQL.

In Interactive SQL, the results appear on the Results tab in the Results pane.

UltraLite Interactive SQL is a graphical utility for executing SQL statements against an UltraLite database.

When you work with Interactive SQL, you can also log statements that you execute.

Open an interactive SQL session with the root database.

Connect to the database using Interactive SQL.

This lesson introduces the UltraLite Interactive SQL utility.

If you have SQL code selected in Interactive SQL, the selected code is automatically imported into the Query Editor.

Connect to the host database from Interactive SQL.

Interactive SQL parses a list of semicolon-separated statements, such as the above, before sending them to the server.

When you finish creating a query in the Query Editor, click OK to write the query to the Interactive SQL Statements pane.

You can delete a view in both Sybase Central and Interactive SQL.

From Interactive SQL, using the sa_validate stored procedure or the VALIDATE TABLE statement.

Open Interactive SQL by typing dbisql at a command prompt.

From the File menu choose Open Interactive SQL.

If your customer application is running on machines with limited resources, you may want to deploy dbisqlc. Exe instead of Interactive SQL.

If you select (Default), the default encoding for the machine Interactive SQL is running on is used.

LOAD TABLE is more efficient than the Interactive SQL statement INPUT.

In this tutorial we use UltraLite Interactive SQL to add data to the UltraLite database.

This example shows you how to import data using the Interactive SQL INPUT statement.

This example shows you how to import data using the Interactive SQL Data menu.

For example, execute the following command in Interactive SQL to verify the contents of the Product table.

To choose a plan type in Interactive SQL, open the Options dialog from the Tools menu, and click the Plan tab.

Connecting to a database on your own machine from Sybase Central or Interactive SQL

"Interactive SQL" [ SQL Anywhere Server - Database Administration ]

Viewing procedure profiling information in Interactive SQL

Interactive SQL lets you control when and how transactions from your application terminate

Once connected to the sample database from Interactive SQL, enter the following command in the SQL Statements pane

The code page specified with the -codepage option when Interactive SQL was started

Connecting to the sample database from Sybase Central or Interactive SQL

The following types of plan are available in Interactive SQL

Execute the following commands in Interactive SQL

The following statement shows how to use DISCONNECT from Interactive SQL to disconnect all connections

Lesson 3: Displaying data using Interactive SQL

How to open a new Interactive SQL window