SQL Reference Guide > SQL Reference Guide > Keywords > Reserved Multi Word Keywords
Was this helpful?
Reserved Multi Word Keywords
Reserved multi-word keywords are listed in the following table.
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 hashagg
*
 
 
 
 
 
set hashjoin
*
 
 
 
 
 
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 nohashagg
*
 
 
 
 
 
set nohashjoin
*
 
 
 
 
 
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
*
 
 
 
 
 
Last modified date: 04/03/2024