Empress: V8.62 Interactive SQL, Dynamic SQL, ODBC, JDBC Reserved Keywords
Keyword	Comment/Limitation
*
+
-
=
?	Only used in Dynamic SQL
add
admin	Only used in grant/revoke commands
after	Only used in trigger commands
aggregate
alias
all
allocate	Only used in create module command
alter
and
any
as
asc
ascending
at
attr
attribute
authorization	Only used in create schema command
before
begin	Only used in create module command
between
binary	Only used in module/trigger/replication/alter/view commands It is an ANSI data type keyword
body	Only used in create module command
btree
by
bypass
bypass_lock
cache	Only used in create/alter squence commands
call
cancel
cascade
cast
change
char
character
check
checksum
cipher	Only used in create/drop db/schema commands
comment
commit
comparison	Only used in create module command
concat
constraint
convert
corresponding
count
create
cross
current	Only used in Dynamic SQL
database
day
db
dba	Only used in grant/revoke privovilege commands
declare	Only used in create module command
delete
desc
descending
direct_from
direct_into
direct_onto
disable
display
distinct
do	Only used in Interactive SQL
double
drop
dump
dynamic	Only used in create module command
each	Only used in trigger commands
edit	Only used in Interactive SQL
empty
enable
encrypted
end
endvalue	only used in create/alter squence commands
equality	only used in create module command
escape
except
excl
exclusive
execute	Only used in trigger commands
exists
exit
expression	Only used in create module command
external	Only used in create module command
extract
false
for
foreign
from
full
function	Only used in create module command
general	Only used in create module command
generic
grant
group
having
help	Only used in Interactive SQL commands
hold	Only used in Interactive SQL commands
hour
in
incl
inclusive
increment	Only used in create/alter sequece commands
index
infix	Only used in create module command
inner
inout	Only used in create module command
insert
intersect
into
is
join
language	Only used in create module command
large	Only used in module/trigger/replication/alter/view commands It is an ANSI data type keyword
left
level
like
list
locate
lock
master	Only used in replication commands
masters	Only used in replication commands
minus
minute
mode	Only used in lock table command
module
month
national	Only used in module/trigger/replication/alter/view commands It is an ANSI data type keyword
natural
nchar	Only used in module/trigger/replication/alter/view commands It is an ANSI data type keyword
nextvalue	Only used in create/alter sequece commands
nolock	Only used in create/drop db/schema commands
noshmem	Only used in create/drop db/schema commans
not
null
object	Only used in module/trigger/replication/alter/view commands It is an ANSI data type keyword
of
oj
on
onto
operator	Only used in create module command
option	Only used in grant/revoke commands
or
order
out	Only used in create module command
outer
parameter	Only used in create module command
position
postfix	Only used in create module command
prefix	Only used in create module command
primary
print
priority	Only used trigger commands
priv
privilege
procedure	Only used in create module command
range
rc	Only used in Interactive SQL commands
recall	Only used in Interactive SQL commands
refer
reference
references
referential
rename
replicate
replicates	Only used in replication commands
replication
report
restrict
result	Only used in create module command
returns	Only used in create module command
revoke
right
role
rollback
routine
row	Only used trigger commands
run
savepoint
schema
second
select
sequence
seqid	Only used in create/alter sequece commands
set
sets	Only used in create module command
show	Only used in Interactive SQL commands
some
sort
sql	Only used in create module command
sql_tsi_day
sql_tsi_frac_second
sql_tsi_hour
sql_tsi_minute
sql_tsi_month
sql_tsi_quarter
sql_tsi_second
sql_tsi_week
sql_tsi_second
sql_tsi_year
start
startvalue	Only used in create/alter sequece commands
stop
store	Only used in Interactive SQL commands
style	Only used in create module command
subset	Only used in replication commands
table
time	Only used in module/trigger/replication/ alter/view commands It is an ANSI data type keyword
timeseries
timestamp	Only used in module/trigger/replication/alter/view commands It is an ANSI data type keyword
timestampadd
timestampdiff
to
transaction
trigger
triggers	Only used trigger commands
true
type	Only used in create/alter sequece commands
union
unique
unset
update
user
using
values
varying	Only used in module/trigger/replication/ alter/view commands It is an ANSI data type keyword
view
week
when	Only used trigger commands
where
width
with
without	Only used in module/trigger/replication/alter/view commands It is an ANSI data type keyword
work
workspace	Only used in create module command
wrapmargin
year
{
{d	Only used in Dynamic SQL commands
{fn	Only used in Dynamic SQL commands
{oj
{ts	Only used in Dynamic SQL commands
}