Embedded SQL constructs

Table 2-1 displays valid constructs in Embedded SQL statements:

Table 2-1: Embedded SQL constructs

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