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
} |