Previous Topic

Next Topic

Multi Word Keywords

Reserved multi-word keywords are listed in the following table.

Abbreviations used:

Note: The ESQL and EQUEL preprocessors also reserve forms statements.

 

 

SQL

 

 

QUEL

 

Keyword

ISQL

ESQL

4GL

IQUEL

EQUEL

4GL

add privileges

 

 

*

 

 

after field

 

 

*

 

 

*

after 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 declare

 

*

 

 

 

 

begin exclude

 

*

 

 

 

 

begin transaction

*

*

*

*

*

*

by group

 

 

*

 

 

 

by role

*

 

 

 

 

 

by user

*

 

*

 

 

 

call on

 

 

*

 

 

 

call procedure

 

 

*

 

 

 

class of

 

 

*

 

 

 

clear array

 

*

 

 

 

 

close cursor

 

*

 

*

*

 

comment on

*

*

*

 

 

 

connect to

 

 

*

 

 

 

copy table

 

 

*

 

 

 

create dbevent

*

*

*

 

 

 

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

 

 

*

 

 

*

resume nextfield

 

 

*

 

 

 

resume previousfield

 

 

*

 

 

 

retrieve cursor

 

*

 

*

*

right join

*

 

*

 

 

 

right outer

*

 

 

 

 

 

run submenu

 

 

*

 

 

*

send userevent

 

 

*

 

 

 

session group

 

 

*

 

 

 

session role

 

 

*

 

 

 

session user

 

 

*

 

 

 

set aggregate

*

 

 

*

 

 

set attribute

 

*

 

 

 

 

set autocommit

*

 

 

*

 

 

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 transaction

*

 

 

 

 

 

set unicode_substitution

*

 

 

 

 

 

set update_rowcount

*

 

 

 

 

 

set work

*

 

 

 

 

 

system user

 

 

*

 

 

 

to group

*

 

*

 

 

 

to role

*

 

*

 

 

 

to user

*

*

 

 

 

 

user authorization

 

 

*

 

 

 

with null

 

 

 

*

 

 

with short_remark

*

 

 

 

 

 


© 2007 Ingres Corporation. All rights reserved.