EGL Reference Guide for iSeries
Outside of SQL statements, the reserved words are as follows in any
combination of upper- and lower-case letters:
- absolute, add, after, all, array, at
- before, bigInt, bin, blob, by, byName, byPosition, byte
- call, case, char, clob, close, command, continue, converse, current,
currentRow
- database, DataItem, DataTable, date, day, dbChar, dbClob, decimal,
decimalFloat, decrement, defined, delete, description, display, dliCall
- else, embed, enable, end, eof, every, execute, exit, externallyDefined
- field, first, float, for, forEach, Form, format, FormGroup, forUpdate,
forward, forwarding, freeSql, from, Function
- get, goto, group
- header, help, hex, hide, hold, hour
- if, import, in, inOut, input, insert, int, integerDate, interval, into, is
- keys
- label, languageBundle, last, library, line
- mbChar, menu, minute, money, month, move
- newLine, newWindow, next, noDelete, noInsert, noRefresh, not, nullable,
num, number, numc
- of, off, on, onException, onKey, open, option, otherwise, out
- pacf, package, PageHandler, passing, physical, prepare, previous, print,
private, Program, prompt, Psb
- Record, relative, replace, report, return, returns, row
- scroll, second, setOption, smallFloat, set, show, singleRow, smallInt,
stack
- this, thru, time, timeStamp, to, trailer, transaction, transfer, try, type
- unicode, update, use, using, usingKeys
- varChar, varDbChar, varMbChar, varUnicode
- when, where, while, window, with, withinParent, wrap
- year
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
reservedWord
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.