Keywords

This appendix lists Ingres keywords and indicates the contexts in which they are reserved, enabling you to avoid assigning object names that conflict with reserved words. In addition to the explicit keywords, all identifiers starting with the letters ii are reserved for Ingres system catalogs.

The keywords in these lists do not necessarily correspond to supported Ingres features. Some words are reserved for future or internal use, and some words are reserved to provide backward compatibility with older features.

Single Word Keywords

Reserved single word keywords are listed in the following table.

Abbreviations used:

ISQL (Interactive SQL)—keywords reserved by the DBMS
ESQL (Embedded SQL)—keywords reserved by the SQL preprocessors
IQUEL (Interactive QUEL)—keywords reserved by the DBMS
EQUEL (Embedded QUEL)—keywords reserved by the QUEL preprocessors
4GL—keywords reserved in the context of SQL or QUEL in Ingres 4GL routines

Note: The ESQL and EQUEL preprocessors also reserve forms statements. For details about forms statements, see the Forms-based Application Development Tools User Guide.

		SQL			QUEL
Keyword	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	*		*			*
cache	*	*	*
call		*	*		*	*
callframe			*			*
callproc	*		*			*
cascade	*	*
case	*	*	*
cast	*
check	*	*	*
clear		*	*		*	*
clearrow		*	*		*	*
close	*	*		*
coalesce	*
collate	*	*
column	*	*	*		*
command		*			*
comment			*
commit	*	*
commited	*	*	*
connect		*
constraint	*	*	*
continue	*	*
copy	*	*	*	*	*	*
copy_from	*
copy_into	*
count	*	*	*	*	*
countu		*		*	*
create	*	*	*	*	*	*
current	*	*
current_user	*
currval	*	*	*
cursor	*	*
cycle	*	*	*
datahandler		*
declare	*	*	*			*
default	*	*	*			*
define	*			*		*
delete	*	*	*	*	*	*
deleterow		*	*		*	*
desc			*
describe	*	*
descriptor		*
destroy				*	*	*
direct			*			*
disable			*
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		*	*		*	*
inner		*	*
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		*	*
print		*		*	*
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_ maintained	*	*		*	*
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	*	*	*