There are a large number of SQL reserved words that cannot be used in SQL
clauses. The migration tool renames functions, data items, records, and
maps if the part name is an SQL reserved word. The migration tool does
not rename tables, map groups, or programs. The SQL reserved words are
as follows:
Letter | Reserved words |
---|---|
A | absolute, action, add, alias, all, allocate, alter, and, any, are, as, asc, assertion, at, authorization, avg |
B | begin, between, bigint, binaryLargeObject, bit, bit_length, blob, boolean, both, by |
C | 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 |
D | data, database, date, dateTime, day, deallocate, dec, decimal, declare, default, deferrable, deferred, delete, desc, describe, diagnostics, disconnect, distinct, domain, double, doublePrecision, drop |
E | else, end, endExec, escape, except, exception, exec, execute, exists, explain, external, extract |
F | false, fetch, first, float, for, foreign, found, from, full |
G | get, getCurrentConnection, global, go, goto, grant, group |
H | having, hour |
I | identity, image, immediate, in, index, indicator, initially, inner, input, insensitive, insert, int, integer, intersect, into, is, isolation |
J | join |
K | key |
L | language, last, leading, left, level, like, local, long, longint, lower, ltrim |
M | match, max, min, minute, module, month |
N | national, nationalCharacter, nationalCharacterLargeObject, nationalCharacterVarying, nationalCharLargeObject, nationalCharVarying, natural, nchar, ncharVarying, nclob, next, no, not, null, nullIf, number, numeric |
O | octet_length, of, on, only, open, option, or, order, outer, output, overlaps |
P | pad, partial, position, prepare, preserve, primary, prior, privileges, procedure, public |
R | raw, read, real, references, relative, restrict, revoke, right, rollback, rows, rtrim, runtimeStatistics |
S | schema, scroll, second, section, select, session, session_user, set, signal, size, smallint, some, space, sql, sqlcode, sqlerror, sqlstate, substr, substring, sum, system_user |
T | table, tablespace, temporary, terminate, then, time, timestamp, timezone_hour, timezone_minute, tinyint, to, trailing, transaction, translate, translation, trim, true |
U | uncatalog, union, unique, unknown, update, upper, usage, user, using |
V | values, varbinary, varchar, varchar2, varying, view |
W | when, whenever, where, with, work, write |
Y | year |
Z | zone |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.