AV | Reserved Multi Word Keywords

SQL Language 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: 10/30/2024