EGL reserved words

EGL includes two categories of reserved words:

Words that are reserved outside of an SQL statement

Outside of SQL statements, the reserved words are as follows in any combination of upper- and lower-case letters:

Words that are reserved in an SQL statement

In SQL statements, the reserved words are as follows in any combination of upper- and lower-case letters:

  • absolute, action, add, alias, all, allocate, alter, and, any, are, as, asc, assertion, at, authorization, avg

  • begin, between, bigint, binaryLargeObject, bit, bit_length, blob, boolean, both, by

  • call, cascade, cascaded, case, cast, catalog, char, char_length, character, character_length, characterLargeObject, characterVarying, charLargeObject, charVarying, check, clob, close, coalesce, collate, collation, column, comment, commit, connect, connection, constraint, constraints, continue, convert, copy, corresponding, count, create, cross, current, current_date, current_time, current_timestamp, current_user, cursor

  • data, database, date, dateTime, day, deallocate, dec, decimal, declare, default, deferrable, deferred, delete, desc, describe, diagnostics, disconnect, distinct, domain, double, doublePrecision, drop

  • else, end, endExec, escape, except, exception, exec, execute, exists, explain, external, extract

  • false, fetch, first, float, for, foreign, found, from, full

  • get, getCurrentConnection, global, go, goto, grant, group

  • having, hour

  • identity, image, immediate, in, index, indicator, initially, inner, input, insensitive, insert, int, integer, intersect, into, is, isolation

  • join

  • key

  • language, last, leading, left, level, like, local, long, longint, lower, ltrim

  • match, max, min, minute, module, month

  • national, nationalCharacter, nationalCharacterLargeObject, nationalCharacterVarying, nationalCharLargeObject, nationalCharVarying, natural, nchar, ncharVarying, nclob, next, no, not, null, nullIf, number, numeric

  • octet_length, of, on, only, open, option, or, order, outer, output, overlaps

  • pad, partial, position, prepare, preserve, primary, prior, privileges, procedure, public

  • raw, read, real, references, relative, restrict, revoke, right, rollback, rows, rtrim, runtimeStatistics

  • schema, scroll, second, section, select, session, session_user, set, signal, size, smallint, some, space, sql, sqlcode, sqlerror, sqlstate, substr, substring, sum, system_user

  • table, tablespace, temporary, terminate, then, time, timestamp, timezone_hour, timezone_minute, tinyint, to, trailing, transaction, translate, translation, trim, true

  • uncatalog, union, unique, unknown, update, upper, usage, user, using

  • values, varbinary, varchar, varchar2, varying, view

  • when, whenever, where, with, work, write

  • year

  • zone

Related reference
EGL statements
Naming conventions