Reserved Multi Word Keywords¶
Reserved multi-word keywords are listed in the following table.
| 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 hashagg | * | |||||
| set hashjoin | * | |||||
| 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 nohashagg | * | |||||
| set nohashjoin | * | |||||
| 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 | * |