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