Table 2-1 displays valid constructs in Embedded SQL statements:
begin declare section begin tran begin work checkpoint close cursor_name commit tran commit work connect create database create default create table create index create unique index create clustered index create nonclustered index create unique clustered index create unique nonclustered index create proc create rule create trigger create view declare cursor delete disconnect drop table drop default drop index drop proc drop rule |
drop trigger drop view dump database dump tran end declare section exec procedure_name execute name execute immediate fetch cursor_name grant include sqlca or file insert open cursor_name prepare statement_name revoke rollback tran rollback work select set truncate update use whenever condition action |
