The following single keywords are reserved.
Note: The ESQL and EQUEL preprocessors also reserve forms statements.
|
|
|
SQL |
|
|
QUEL |
|
|---|---|---|---|---|---|---|---|
Keyword |
Non 6.4 |
ISQL |
ESQL |
4GL |
IQUEL |
EQUEL |
4GL |
abort |
|
* |
* |
* |
* |
* |
* |
activate |
|
|
* |
|
|
* |
|
add |
|
* |
* |
* |
|
|
|
addform |
|
|
* |
|
|
* |
|
after |
* |
|
|
* |
|
|
* |
all |
|
* |
* |
|
* |
* |
|
alter |
|
* |
|
* |
|
|
|
and |
|
* |
* |
|
* |
* |
|
any |
|
* |
* |
* |
* |
* |
|
append |
|
|
|
|
* |
* |
* |
array |
* |
|
|
* |
|
|
|
as |
|
* |
* |
|
* |
* |
* |
asc |
|
* |
|
* |
|
|
|
asymmetric |
* |
* |
* |
|
|
|
|
at |
|
* |
* |
* |
* |
* |
* |
authorization |
|
* |
* |
|
|
|
|
avg |
|
* |
* |
* |
* |
* |
|
avgu |
|
|
* |
|
* |
* |
|
before |
|
|
|
* |
|
|
* |
begin |
|
* |
* |
* |
* |
|
* |
between |
|
* |
* |
* |
|
|
|
breakdisplay |
|
|
* |
|
|
* |
|
by |
|
* |
* |
* |
* |
* |
* |
byref |
* |
* |
|
* |
|
|
* |
call |
|
|
* |
* |
|
* |
* |
callframe |
* |
|
|
* |
|
|
* |
callproc |
* |
* |
|
* |
|
|
* |
cascade |
* |
* |
* |
|
|
|
|
case |
* |
* |
* |
* |
|
|
|
cast |
* |
* |
|
|
|
|
|
check |
|
* |
* |
* |
|
|
|
clear |
|
|
* |
* |
|
* |
* |
clearrow |
|
|
* |
* |
|
* |
* |
close |
|
* |
* |
|
* |
|
|
coalesce |
* |
* |
|
|
|
|
|
collate |
* |
* |
* |
|
|
|
|
column |
|
* |
* |
* |
|
* |
|
command |
|
|
* |
|
|
* |
|
comment |
* |
|
|
* |
|
|
|
commit |
|
* |
* |
* |
|
|
|
committed |
* |
* |
* |
* |
|
|
|
connect |
|
|
* |
|
|
|
|
constraint |
* |
* |
* |
* |
|
|
|
continue |
|
* |
* |
|
|
|
|
copy |
|
* |
* |
* |
* |
* |
* |
copy_from |
* |
* |
|
|
|
|
|
copy_into |
* |
* |
|
|
|
|
|
count |
|
* |
* |
* |
* |
* |
|
countu |
|
|
* |
|
* |
* |
|
create |
|
* |
* |
* |
* |
* |
* |
current |
|
* |
* |
|
|
|
|
current_user |
* |
* |
* |
|
|
|
|
currval |
* |
* |
* |
* |
|
|
|
cursor |
|
* |
* |
|
|
|
|
cycle |
* |
* |
* |
* |
|
|
|
datahandler |
* |
|
* |
|
|
|
|
dbms_password |
* |
|
* |
* |
|
|
|
declare |
|
* |
* |
* |
|
|
* |
default |
* |
* |
* |
* |
|
|
* |
define |
* |
* |
|
|
* |
|
* |
delete |
* |
* |
* |
* |
* |
* |
* |
deleterow |
|
|
* |
* |
|
* |
* |
desc |
|
|
|
* |
|
|
|
describe |
* |
* |
* |
|
|
|
|
descriptor |
|
|
* |
|
|
|
|
destroy |
|
|
|
|
* |
* |
* |
direct |
* |
|
|
* |
|
|
* |
disconnect |
|
|
* |
|
|
|
|
display |
|
|
* |
* |
|
* |
* |
distinct |
|
* |
* |
* |
|
|
|
distribute |
* |
|
|
|
* |
|
|
do |
|
* |
|
* |
|
|
* |
down |
|
|
* |
|
|
* |
|
drop |
|
* |
* |
* |
|
|
|
else |
|
* |
|
* |
|
|
* |
elseif |
|
* |
|
* |
|
|
* |
enable |
* |
|
|
* |
|
|
|
end |
|
* |
* |
* |
* |
* |
* |
end-exec |
* |
|
* |
|
|
|
|
enddata |
|
|
* |
|
|
* |
|
enddisplay |
|
|
* |
|
|
* |
|
endfor |
|
* |
* |
* |
|
|
|
endforms |
|
|
* |
|
|
* |
|
endif |
|
* |
|
* |
|
|
* |
endloop |
|
* |
* |
* |
|
* |
* |
endrepeat |
|
* |
* |
* |
|
|
|
endretrieve |
|
|
|
|
|
* |
|
endselect |
|
|
* |
|
|
|
|
endwhile |
|
* |
|
* |
|
|
* |
escape |
|
* |
* |
|
|
|
|
except |
* |
* |
|
|
|
|
|
exclude |
* |
|
|
|
* |
|
|
excluding |
* |
* |
* |
|
* |
|
|
execute |
|
* |
* |
* |
* |
|
|
exists |
|
* |
* |
* |
|
|
|
exit |
|
|
|
* |
|
* |
* |
fetch |
|
* |
* |
|
|
|
|
field |
|
|
* |
|
|
* |
|
finalize |
|
|
* |
|
|
* |
|
first |
|
* |
* |
* |
|
|
|
for |
|
* |
* |
* |
* |
* |
|
foreign |
* |
* |
* |
|
|
|
|
formdata |
|
|
* |
|
|
* |
|
forminit |
|
|
* |
|
|
* |
|
forms |
|
|
* |
|
|
* |
|
from |
|
* |
* |
* |
* |
* |
* |
full |
* |
* |
* |
* |
|
|
|
get |
* |
|
|
* |
|
|
|
getform |
|
|
* |
|
|
* |
|
getoper |
|
|
* |
|
|
* |
|
getrow |
|
|
* |
|
|
* |
|
global |
* |
* |
* |
* |
|
|
|
goto |
|
|
* |
|
|
|
|
grant |
|
* |
* |
* |
|
|
|
granted |
* |
|
* |
* |
|
|
|
group |
|
* |
* |
* |
|
|
|
having |
|
* |
* |
* |
|
|
|
help |
|
|
* |
|
* |
* |
|
help_forms |
* |
|
|
* |
|
|
* |
help_frs |
|
|
* |
|
|
* |
|
helpfile |
|
|
* |
* |
|
* |
* |
identified |
|
|
* |
* |
|
|
|
if |
|
* |
|
* |
|
|
* |
iimessage |
* |
|
* |
|
|
* |
|
iiprintf |
* |
|
* |
|
|
* |
|
iiprompt |
* |
|
* |
|
|
* |
|
iistatement |
* |
|
|
|
|
* |
|
immediate |
|
* |
* |
* |
|
|
* |
import |
* |
* |
|
|
|
|
|
in |
|
* |
* |
* |
* |
* |
|
include |
|
|
* |
|
* |
|
|
increment |
* |
* |
* |
* |
|
|
|
index |
|
* |
* |
* |
* |
* |
* |
indicator |
|
|
* |
|
|
|
|
ingres |
|
|
|
|
|
* |
|
initial_user |
* |
* |
* |
|
|
|
|
initialize |
|
|
* |
* |
|
* |
* |
inittable |
|
|
* |
* |
|
* |
* |
inquire_equel |
|
|
|
|
|
* |
|
inquire_forms |
* |
|
|
* |
|
|
* |
inquire_frs |
|
|
* |
|
|
* |
|
inquire_ingres |
* |
|
* |
* |
|
* |
* |
inquire_sql |
|
|
* |
* |
|
|
|
insert |
|
* |
* |
* |
|
|
|
insertrow |
|
|
* |
* |
|
* |
* |
integrity |
|
* |
* |
|
* |
|
* |
intersect |
* |
* |
|
|
|
|
|
into |
|
* |
* |
* |
* |
* |
* |
is |
|
* |
* |
* |
* |
* |
* |
isolation |
* |
* |
* |
* |
|
|
|
join |
* |
* |
* |
|
|
|
|
key |
* |
|
* |
* |
|
|
* |
leave |
|
* |
* |
* |
|
|
|
left |
* |
|
* |
* |
|
|
|
level |
* |
* |
* |
|
* |
* |
|
like |
|
* |
* |
|
|
|
|
loadtable |
|
|
* |
* |
|
* |
* |
local |
* |
* |
|
|
|
|
|
max |
|
* |
* |
* |
* |
* |
|
maxvalue |
* |
* |
* |
* |
|
|
|
menuitem |
|
|
* |
|
|
* |
|
message |
|
* |
* |
* |
|
* |
* |
min |
|
* |
* |
* |
* |
* |
|
minvalue |
* |
* |
* |
* |
|
|
|
mode |
* |
|
|
* |
|
|
* |
modify |
|
* |
* |
* |
* |
* |
* |
module |
* |
* |
|
|
|
|
|
move |
* |
|
|
|
* |
|
|
natural |
* |
* |
* |
|
|
|
|
next |
|
* |
* |
|
|
* |
|
nextval |
* |
* |
* |
* |
|
|
|
nocache |
* |
* |
* |
* |
|
|
|
nocycle |
* |
* |
* |
* |
|
|
|
noecho |
* |
|
|
* |
|
|
* |
nomaxvalue |
* |
* |
* |
* |
|
|
|
nominvalue |
* |
* |
* |
* |
|
|
|
noorder |
* |
* |
* |
* |
|
|
|
not |
|
* |
* |
|
* |
* |
|
notrim |
|
|
* |
|
|
* |
|
null |
|
* |
* |
* |
|
* |
* |
nullif |
* |
* |
|
|
|
|
|
of |
|
* |
* |
* |
* |
* |
* |
on |
|
* |
* |
|
* |
* |
* |
only |
* |
* |
* |
* |
* |
|
* |
open |
|
* |
* |
|
* |
|
|
option |
|
* |
|
|
|
|
|
or |
|
* |
* |
|
* |
* |
|
order |
|
* |
* |
* |
* |
* |
* |
out |
|
|
* |
|
|
* |
|
outer |
* |
* |
* |
* |
|
|
|
param |
|
|
|
|
|
* |
|
partition |
* |
|
* |
|
|
|
|
permit |
|
* |
* |
|
* |
|
* |
prepare |
|
* |
* |
|
|
|
|
preserve |
* |
* |
* |
|
|
|
|
primary |
* |
|
* |
* |
|
|
|
|
|
* |
|
* |
* |
|
|
printscreen |
|
|
* |
* |
|
* |
* |
privileges |
|
* |
|
|
|
|
|
procedure |
|
* |
* |
* |
|
|
* |
prompt |
|
|
* |
* |
|
* |
* |
public |
|
* |
* |
|
|
|
|
purgetable |
* |
|
* |
* |
|
* |
* |
putform |
|
|
* |
|
|
* |
|
putoper |
|
|
* |
|
|
* |
|
putrow |
|
|
* |
|
|
* |
|
qualification |
* |
|
|
* |
|
|
* |
raise |
* |
* |
|
* |
|
|
|
range |
|
|
|
|
* |
* |
* |
rawpct |
* |
* |
* |
* |
|
|
|
read |
* |
* |
* |
|
* |
|
|
redisplay |
|
|
* |
* |
|
* |
* |
references |
* |
* |
* |
* |
|
|
|
referencing |
|
* |
|
* |
|
|
|
register |
|
* |
* |
* |
* |
* |
* |
relocate |
|
* |
* |
* |
* |
* |
* |
remove |
|
* |
* |
* |
|
* |
* |
rename |
* |
|
|
|
* |
|
|
repeat |
|
* |
* |
* |
|
* |
* |
repeatable |
* |
* |
* |
|
|
|
|
repeated |
|
|
* |
* |
|
|
|
replace |
|
|
|
|
* |
* |
* |
replicate |
* |
|
|
|
* |
|
|
restart |
* |
* |
* |
* |
|
|
|
restrict |
* |
* |
* |
|
|
|
|
result |
* |
|
* |
|
|
|
|
resume |
|
|
* |
* |
|
* |
* |
retrieve |
|
|
|
|
* |
* |
* |
return |
|
* |
|
* |
|
|
* |
revoke |
|
* |
* |
* |
|
|
|
right |
* |
|
* |
* |
|
|
|
role |
* |
|
* |
* |
|
|
|
rollback |
|
* |
* |
* |
|
|
|
row |
|
* |
* |
* |
|
|
|
rows |
* |
* |
* |
|
|
|
|
run |
* |
|
|
* |
|
|
* |
save |
|
* |
* |
* |
* |
* |
* |
savepoint |
|
* |
* |
* |
* |
* |
* |
schema |
* |
* |
* |
|
|
|
|
screen |
|
|
* |
* |
|
* |
* |
scroll |
|
|
* |
* |
|
* |
* |
scrolldown |
|
|
* |
|
|
* |
|
scrollup |
|
|
* |
|
|
* |
|
section |
|
|
* |
|
|
|
|
select |
|
* |
* |
* |
|
|
|
serializable |
* |
* |
* |
* |
|
|
|
session |
* |
* |
* |
* |
|
|
|
session_user |
* |
* |
* |
|
|
|
|
set |
|
* |
* |
* |
* |
* |
* |
set_4gl |
* |
|
|
* |
|
|
* |
set_equel |
|
|
|
|
|
* |
|
set_forms |
* |
|
|
* |
|
|
* |
set_frs |
|
|
* |
|
|
* |
|
set_ingres |
* |
|
* |
* |
|
* |
* |
set_sql |
|
|
* |
* |
|
|
|
sleep |
|
|
* |
* |
|
* |
* |
some |
|
* |
* |
* |
|
|
|
sort |
|
|
|
|
* |
* |
* |
sql |
|
* |
|
|
|
|
|
start |
* |
* |
* |
* |
|
|
|
stop |
|
|
* |
|
|
|
|
submenu |
|
|
* |
|
|
* |
|
substring |
|
* |
* |
|
|
|
|
sum |
|
* |
* |
* |
* |
* |
|
sumu |
|
|
* |
|
* |
* |
|
symmetric |
* |
* |
* |
|
|
|
|
system |
* |
|
|
* |
|
|
* |
system_ |
* |
* |
* |
|
* |
* |
|
system_user |
* |
* |
* |
|
|
|
|
table |
|
* |
* |
|
|
|
|
tabledata |
|
|
* |
|
|
* |
|
temporary |
* |
* |
* |
|
|
|
|
then |
|
* |
* |
* |
|
|
* |
to |
|
* |
* |
|
* |
* |
* |
type |
* |
|
|
* |
|
|
|
uncommitted |
* |
* |
* |
* |
|
|
|
union |
|
* |
* |
* |
|
|
|
unique |
|
* |
* |
* |
* |
* |
* |
unloadtable |
|
|
* |
* |
|
* |
* |
until |
|
* |
* |
* |
* |
* |
* |
up |
|
|
* |
|
|
* |
|
update |
|
* |
* |
* |
* |
|
|
user |
|
* |
* |
* |
|
|
|
using |
|
* |
* |
|
|
|
|
validate |
|
|
* |
* |
|
* |
* |
validrow |
|
|
* |
* |
|
* |
* |
values |
|
* |
* |
* |
|
|
|
view |
|
* |
* |
|
* |
|
* |
when |
* |
* |
* |
|
|
|
|
whenever |
|
|
* |
|
|
|
|
where |
|
* |
* |
* |
* |
* |
* |
while |
|
* |
|
|
|
|
* |
with |
|
* |
* |
* |
* |
* |
* |
work |
|
* |
|
* |
|
|
|
write |
* |
* |
* |
* |
|
|
|