Valid SQL Statements

Go Up to Preparing SQL Statements

• You can execute interactively any SQL statement identified as “available in DSQL” in the Language Reference. You cannot use any statements that are specifically identified in the Language Reference as isql statements; all these have functionally equivalent menu items in isql.

For example, the SET NAMES statement cannot be executed from the SQL input area. To change the active character set, choose Edit|Options and select the desired character set option value in the SQL Options dialog.

• SQL script files can include statements that are not valid to enter interactively. For example, you can use the SET statements such as SET LIST in scripts.
• Transaction names may not be used with SET TRANSACTION statement.
• The SQL input area accepts multiple statements, although only one can be executed at a time. Each statement entered in the SQL input area must be terminated by a semicolon (;). The SQL input area accepts multiple statements, although only one can be executed at a time. An uncommented statement that holds the mouse cursor is called the current statement.