VisualAge Generator to Enterprise Generation Language Migration Guide


SQL reserved words

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


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]