Executing SQL Interactively

Go Up to Executing SQL Statements

To execute a SQL statement interactively:

1. Type a single SQL statement in the SQL input area. Make sure any other existing statements are commented. A statement is commented if it is preceded by “/*” and followed by “*/”.

If the statement already exists in the SQL input area make sure all statements except the one you wish to execute are commented. Commented statements in the SQL input area are ignored during execution.

2. Choose Query|Execute, enter W+E, or click the Execute toolbar button.

If more than one statement is uncommented, Execute executes each statement, one after the other.

Tip: You can copy text from other Windows applications such as the Notepad and Wordpad text editors and paste it into the SQL input area. You can also copy statements from the isql output area and paste them into the SQL input area. This cut-and-paste method is also a convenient way to use the online SQL tutorial provided in the online Help.

When SQL statements are executed, whether successfully or not, they become part of the isql command history, a sequential list of SQL statements entered in the current session.