Statement Types Not Supported
Go Up to Procedures and Triggers
The stored procedure and trigger language does not include many of the statement types available in DSQL or gpre
. The following statement types are not supported in triggers or stored procedures:
- Data definition language statements:
CREATE
,ALTER
,DROP
,DECLARE EXTERNAL FUNCTION
, andDECLARE FILTER
- Transaction control statements:
SET TRANSACTION
,COMMIT
,ROLLBACK
- Dynamic SQL statements:
PREPARE
,DESCRIBE
,EXECUTE
CONNECT/DISCONNECT
, and sending SQL statements to another databaseGRANT/REVOKE
SET GENERATOR
EVENT INIT/WAIT
BEGIN/END DECLARE SECTION
BASED ON
WHENEVER
DECLARE CURSOR
OPEN
FETCH