OpenSQL Reference Guide > OpenSQL Reference Guide > A. Keywords > Reserved Double Keywords
Was this helpful?
Reserved Double Keywords
The following table lists OpenSQL double keywords:
SQL
 
 
QUEL
 
Double Keyword
ISQL
ESQL
4GL
IQUEL
EQUEL
4GL
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 transaction
    *
    *
    *
    *
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 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
    *
    *
 
    *
    *
retrieve cursor
    *
    *
 
    *
    *
right join
    *
    *
 
    *
    *
run submenu
    *
    *
 
    *
    *
session group
    *
    *
 
    *
    *
session role
    *
    *
 
    *
    *
session user
    *
    *
 
    *
    *
set aggregate
    *
    *
 
    *
    *
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 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: 01/30/2023