Reserved multi-word keywords are listed in the following table.
Abbreviations used:
Note: The ESQL and EQUEL preprocessors also reserve forms statements.
|
|
SQL |
|
|
QUEL |
|
---|---|---|---|---|---|---|
Keyword |
ISQL |
ESQL |
4GL |
IQUEL |
EQUEL |
4GL |
add privileges |
|
|
* |
|
|
|
after field |
|
|
* |
|
|
* |
after default |
|
* |
* |
|
|
|
alter group |
* |
* |
* |
|
|
|
alter location |
* |
* |
* |
|
|
|
alter profile |
* |
|
|
|
|
|
alter role |
* |
* |
* |
|
|
|
alter security_audit |
* |
* |
* |
|
|
|
alter sequence |
* |
* |
* |
|
|
|
alter table |
|
* |
* |
|
|
|
alter user |
* |
* |
* |
|
|
|
array of |
|
|
* |
|
|
|
base table structure |
* |
|
|
|
|
|
before field |
|
|
* |
|
|
* |
begin declare |
|
* |
|
|
|
|
begin exclude |
|
* |
|
|
|
|
begin transaction |
* |
* |
* |
* |
* |
* |
by group |
|
|
* |
|
|
|
by role |
* |
|
|
|
|
|
by user |
* |
|
* |
|
|
|
call on |
|
|
* |
|
|
|
call procedure |
|
|
* |
|
|
|
class of |
|
|
* |
|
|
|
clear array |
|
* |
|
|
|
|
close cursor |
|
* |
|
* |
* |
|
comment on |
* |
* |
* |
|
|
|
connect to |
|
|
* |
|
|
|
copy table |
|
|
* |
|
|
|
create dbevent |
* |
* |
* |
|
|
|
create group |
* |
|
* |
|
|
|
create integrity |
* |
|
* |
|
|
|
create link |
* |
* |
|
|
|
|
create location |
* |
* |
* |
|
|
|
create permit |
* |
|
* |
|
|
|
create procedure |
|
|
* |
|
|
|
create profile |
* |
|
|
|
|
|
create role |
* |
* |
* |
|
|
|
create rule |
* |
* |
* |
|
|
|
create security_alarm |
* |
* |
* |
|
|
|
create sequence |
* |
* |
* |
|
|
|
create synonym |
* |
* |
* |
|
|
|
create user |
* |
* |
* |
|
|
|
create view |
* |
|
* |
|
|
|
cross join |
* |
* |
* |
|
|
|
curr value |
* |
|
|
|
|
|
current installation |
|
|
* |
|
|
|
current value |
* |
* |
* |
|
|
|
define cursor |
|
|
|
* |
|
|
declare cursor |
|
|
|
|
* |
|
define integrity |
|
|
|
* |
* |
* |
define link |
|
|
|
|
* |
|
define location |
|
|
|
* |
|
|
define permit |
|
|
|
* |
* |
* |
define qry |
* |
|
|
* |
|
* |
define query |
* |
|
|
* |
|
|
define view |
|
|
|
* |
* |
* |
delete cursor |
|
|
|
* |
* |
|
describe form |
|
* |
|
|
|
|
destroy integrity |
|
* |
|
* |
* |
* |
destroy link |
|
* |
|
|
* |
|
destroy permit |
|
* |
|
* |
* |
* |
destroy table |
|
* |
|
|
* |
|
destroy view |
|
|
|
|
|
* |
direct connect |
|
* |
* |
|
* |
* |
direct disconnect |
|
* |
* |
|
* |
* |
direct execute |
|
* |
|
|
|
* |
disable security_audit |
* |
* |
* |
|
|
|
disconnect current |
|
|
* |
|
|
|
display submenu |
|
|
* |
|
|
* |
drop dbevent |
* |
* |
* |
|
|
|
drop domain |
|
* |
|
|
|
|
drop group |
* |
|
* |
|
|
|
drop integrity |
* |
|
* |
|
|
|
drop link |
* |
* |
* |
|
|
|
drop location |
* |
* |
* |
|
|
|
drop permit |
* |
|
* |
|
|
|
drop procedure |
|
|
* |
|
|
|
drop profile |
* |
|
|
|
|
|
drop role |
* |
* |
* |
|
|
|
drop rule |
* |
* |
* |
|
|
|
drop security_alarm |
* |
* |
* |
|
|
|
drop sequence |
* |
* |
* |
|
|
|
drop synonym |
* |
* |
* |
|
|
|
drop user |
* |
* |
* |
|
|
|
drop view |
* |
|
* |
|
|
|
each row |
|
* |
|
|
|
|
each statement |
|
* |
|
|
|
|
enable security_audit |
* |
* |
* |
|
|
|
end transaction |
* |
* |
* |
* |
* |
* |
exec sql |
|
* |
|
|
|
|
execute immediate |
|
|
* |
|
|
|
execute on |
|
|
* |
|
|
|
execute procedure |
|
|
* |
|
|
|
foreign key |
* |
|
* |
|
|
|
for deferred |
* |
|
|
* |
|
|
for direct |
* |
|
|
* |
|
|
for readonly |
* |
|
|
* |
|
|
for retrieve |
|
|
|
* |
|
|
for update |
|
|
|
* |
|
|
from group |
* |
|
* |
|
|
|
from role |
* |
|
* |
|
|
|
from user |
* |
|
* |
|
|
|
full join |
* |
|
* |
|
|
|
full outer |
* |
|
|
|
|
|
get data |
|
* |
|
|
|
|
get dbevent |
|
* |
* |
|
|
|
get global |
|
* |
|
|
|
|
global temporary |
|
|
* |
|
|
|
help all |
|
* |
|
|
|
|
help comment |
|
* |
|
|
|
|
help integrity |
|
* |
|
|
* |
|
help permit |
|
* |
|
|
* |
|
help table |
|
|
|
|
|
|
help view |
|
* |
|
|
* |
|
identified by |
|
|
* |
|
|
|
inner join |
* |
|
* |
|
|
|
is null |
|
|
|
* |
|
|
isolation level |
|
* |
|
* |
|
|
left join |
* |
|
* |
|
|
|
left outer |
* |
|
|
|
|
|
modify table |
|
|
* |
|
|
|
next value |
* |
* |
* |
|
|
|
no cache |
* |
* |
* |
|
|
|
no cycle |
* |
* |
* |
|
|
|
no maxvalue |
* |
* |
* |
|
|
|
no minvalue |
* |
* |
* |
|
|
|
no order |
* |
* |
* |
|
|
|
not like |
* |
|
* |
|
|
* |
not null |
|
|
|
* |
|
|
on commit |
* |
* |
* |
|
|
|
on current |
* |
|
|
|
|
|
on database |
* |
|
* |
|
|
|
on dbevent |
* |
|
* |
|
|
|
on location |
* |
|
* |
|
|
|
on procedure |
* |
|
|
|
|
|
on sequence |
* |
|
|
|
|
|
only where |
|
|
|
* |
|
|
open cursor |
|
* |
|
* |
* |
|
order by |
|
|
|
* |
|
|
primary key |
* |
|
* |
|
|
|
procedure returning |
|
|
* |
|
|
* |
put data |
|
* |
|
|
|
|
raise dbevent |
* |
* |
* |
|
|
|
raise error |
* |
|
|
|
|
|
read only |
|
* |
|
|
|
|
read write |
|
* |
|
|
|
|
register dbevent |
* |
* |
* |
|
|
|
register table |
|
|
|
|
|
* |
register view |
|
|
* |
|
|
* |
remote system_password |
|
* |
|
|
|
|
remote system_user |
|
* |
|
|
|
|
remove dbevent |
* |
* |
* |
|
|
|
remove table |
|
|
|
|
|
* |
remove view |
|
|
* |
|
|
* |
replace cursor |
|
* |
|
* |
* |
* |
result row |
* |
* |
* |
|
|
|
resume entry |
|
|
* |
|
|
* |
resume menu |
|
|
* |
|
|
* |
resume next |
|
|
* |
|
|
* |
resume nextfield |
|
|
* |
|
|
|
resume previousfield |
|
|
* |
|
|
|
retrieve cursor |
|
* |
|
* |
* |
|
right join |
* |
|
* |
|
|
|
right outer |
* |
|
|
|
|
|
run submenu |
|
|
* |
|
|
* |
send userevent |
|
|
* |
|
|
|
session group |
|
|
* |
|
|
|
session role |
|
|
* |
|
|
|
session user |
|
|
* |
|
|
|
set aggregate |
* |
|
|
* |
|
|
set attribute |
|
* |
|
|
|
|
set autocommit |
* |
|
|
* |
|
|
set cpufactor |
* |
|
|
* |
|
|
set date_format |
* |
|
|
* |
|
|
set ddl_concurrency |
* |
|
|
|
|
|
set decimal |
* |
|
|
* |
|
|
set flatten |
* |
|
|
|
|
|
set global |
|
* |
|
|
|
|
set hash |
* |
|
|
|
|
|
set io_trace |
* |
|
|
* |
|
|
set jcpufactor |
|
|
|
* |
|
|
set joinop |
* |
|
|
* |
|
|
set journaling |
* |
|
|
* |
|
|
set lock_trace |
* |
|
|
* |
|
|
set lockmode |
* |
|
|
* |
|
|
set log_trace |
* |
|
|
* |
|
|
set logdbevents |
* |
|
|
|
|
|
set logging |
* |
|
|
* |
|
|
set maxconnect |
* |
|
|
|
|
|
set maxcost |
* |
|
|
* |
|
|
set maxcpu |
* |
|
|
* |
|
|
set maxidle |
* |
|
|
|
|
|
set maxio |
* |
|
|
* |
|
|
set maxpage |
* |
|
|
* |
|
|
set maxquery |
* |
|
|
* |
|
|
set maxrow |
* |
|
|
* |
|
|
set money_format |
* |
|
|
* |
|
|
set money_prec |
* |
|
|
* |
|
|
set noflatten |
* |
|
|
|
|
|
set nohash |
* |
|
|
|
|
|
set noio_trace |
* |
|
|
* |
|
|
set nojoinop |
* |
|
|
* |
|
|
set nojournaling |
* |
|
|
* |
|
|
set nolock_trace |
* |
|
|
* |
|
|
set nolog_trace |
* |
|
|
* |
|
|
set nologdbevents |
* |
|
|
|
|
|
set nologging |
* |
|
|
* |
|
|
set nomaxconnect |
* |
|
|
|
|
|
set nomaxcost |
* |
|
|
* |
|
|
set nomaxcpu |
* |
|
|
* |
|
|
set nomaxidle |
* |
|
|
|
|
|
set nomaxio |
* |
|
|
* |
|
|
set nomaxpage |
* |
|
|
* |
|
|
set nomaxquery |
* |
|
|
* |
|
|
set nomaxrow |
* |
|
|
* |
|
|
set noojflatten |
* |
|
|
|
|
|
set nooptimizeonly |
* |
|
|
* |
|
|
set noparallel |
* |
|
|
|
|
|
set noprintdbevents |
* |
|
|
|
|
|
set noprintqry |
* |
|
|
* |
|
|
set noprintrules |
* |
|
|
|
|
|
set noqep |
* |
|
|
* |
|
|
set norules |
* |
|
|
|
|
|
set nosql |
|
|
|
* |
|
|
set nostatistics |
* |
|
|
* |
|
|
set notrace |
* |
|
|
* |
|
|
set nounicode_substitution |
* |
|
|
|
|
|
set ojflatten |
* |
|
|
|
|
|
set optimizeonly |
* |
|
|
* |
|
|
set parallel |
* |
|
|
|
|
|
set printdbevents |
* |
|
|
|
|
|
set printqry |
* |
|
|
* |
|
|
set printrules |
* |
|
|
|
|
|
set qep |
* |
|
|
* |
|
|
set random_seed |
* |
|
|
|
|
|
set result_structure |
* |
|
|
* |
|
|
set ret_into |
* |
|
|
* |
|
|
set role |
* |
|
|
|
|
|
set rules |
* |
|
|
|
|
|
set session |
* |
|
|
* |
|
|
set sql |
|
|
|
* |
|
|
set statistics |
* |
|
|
* |
|
|
set trace |
* |
|
|
* |
|
|
set transaction |
* |
|
|
|
|
|
set unicode_substitution |
* |
|
|
|
|
|
set update_rowcount |
* |
|
|
|
|
|
set work |
* |
|
|
|
|
|
system user |
|
|
* |
|
|
|
to group |
* |
|
* |
|
|
|
to role |
* |
|
* |
|
|
|
to user |
* |
* |
|
|
|
|
user authorization |
|
|
* |
|
|
|
with null |
|
|
|
* |
|
|
with short_remark |
* |
|
|
|
|
|