ASA SQL User's Guide
  Using Procedures, Triggers, and Batches

Statements allowed in batches

All SQL statements are acceptable in batches (including data definition statements such as CREATE TABLE, ALTER TABLE, and so on), with the exception of the following:

• CONNECT or DISCONNECT statement.

• ALTER PROCEDURE or ALTER FUNCTION statement.

• CREATE TRIGGER statement.

• Interactive SQL commands such as INPUT or OUTPUT.

• You cannot use host variables in batches.

The CREATE PROCEDURE statement is allowed, but must be the final statement of the batch. Therefore a batch can contain only a single CREATE PROCEDURE statement.

Using SELECT statements in batches