The following are 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 |