B. Keywords : Reserved Double Keywords
 
Share this page                  
Reserved Double Keywords
The following double keywords are reserved.
SQL
 
 
QUEL
 
Keyword
Non 6.4
ISQL
ESQL
4GL
IQUEL
EQUEL
4GL
add privileges
*
*
after field
*
*
*
alter 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 domain
*
 
*
 
 
 
 
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 privileges
*
 
 
*
 
 
 
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 exclude
*
 
*
 
 
 
 
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 attribute
*
 
*
 
 
 
 
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 connection
*
 
*
*
 
 
*
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
*
*