ETL job failure due to reserved words in DB2
Certain words in DB2 are reserved and using them to create user-defined terms in Emptoris® Contract Management can result in an ETL job failure.
The following words are reserved in DB2.
ADD, AFTER, ALL, ALLOCATE, ALLOW, ALTER, AND, ANY, AS, ASENSITIVE, ASSOCIATE, ASUTIME, AT, AUDIT, AUX, AUXILIARY, BEFORE, BEGIN, BETWEEN, BUFFERPOOL, BY, CALL , CAPTURE, CASCADED, CASE, CAST, CCSID, CHAR, CHARACTER, CHECK, CLONE, CLOSE, CLUSTER, COLLECTION, COLLID, COLUMN, COMMENT, COMMIT, CONCAT, CONDITION, CONNECT, CONNECTION, CONSTRAINT, CONTAINS, CONTENT, CONTINUE, CREATE , CURRENT, CURRENT_DATE, CURRENT_LC_CTYPE, CURRENT_PATH, CURRENT_SCHEMA, CURRENT_TIME, CURRENT_TIMESTAMP, CURSOR, DATA, DATABASE, DAY, DAYS, DBINFO, DECLARE, DEFAULT, DELETE, DESCRIPTOR, DETERMINISTIC, DISABLE, DISALLOW, DISTINCT, DO, DOCUMENT, DOUBLE, DROP, DSSIZE, DYNAMIC, EDITPROC, ELSE , ELSEIF, ENCODING, ENCRYPTION, END, ENDING, END-EXEC2, FENCED, FETCH, FIELDPROC, FINAL, Start of changeFIRST1End of change, FOR, FREE, FROM, FULL, FUNCTION, GENERATED, GET, GLOBAL, GO, GOTO , GRANT, GROUP, HANDLER, HAVING, HOLD, HOUR, HOURS, IF, IMMEDIATE, IN, INCLUSIVE, INDEX, INHERIT, INNER, INOUT, INSENSITIVE, INSERT, INTERSECT, INTO, IS, LABEL, LANGUAGE, Start of changeLAST1End of change, LC_CTYPE, LEAVE, LEFT , LIKE, LOCAL, LOCALE, LOCATOR, LOCATORS, LOCK, LOCKMAX, LOCKSIZE, LONG, LOOP, ISOBID, ITERATE, JAR, JOIN, KEEP, KEY, ERASE, ESCAPE, EXCEPT, EXCEPTION, EXECUTE, EXISTS, EXIT, EXPLAIN, EXTERNAL, MAINTAINED, MATERIALIZED, MICROSECOND, MICROSECONDS , MINUTE, MINUTES, MODIFIES, MONTH, MONTHS, NEXTVAL, NO, NONE, NOT, NULL, NULLS, NUMPARTS, OBID, OF, ON, OPEN, OPTIMIZATION, OPTIMIZE, OR, ORDER, OUT, OUTER, PACKAGE, PARAMETER, PART, PADDED, PARTITION, PARTITIONED, PARTITIONING , PATH, PIECESIZE, PLAN, PRECISION, PREPARE, PREVVAL, PRIQTY, PRIVILEGES, PROCEDURE, PROGRAM, PSID, PUBLIC, QUERY, QUERYNO, READS, REFERENCES, REFRESH, RESIGNAL, RELEASE, RENAME, REPEAT, RESTRICT, RESULT, RESULT_SET_LOCATOR, RETURN, RETURNS, REVOKE, RIGHT, ROLE, ROLLBACK, ROUND_CEILING , ROUND_DOWN, ROUND_FLOOR, ROUND_HALF_DOWN, ROUND_HALF_EVEN, ROUND_HALF_UP, ROUND_UP, ROW, ROWSET, RUN, SAVEPOINT, SCHEMA, SCRATCHPAD, SECOND, SECONDS, SECQTY, SECURITY, SEQUENCE, SELECT, SENSITIVE, SESSION_USER, SET, SIGNAL, SIMPLE, SOME, SOURCE, SPECIFIC , STANDARD, STATIC, STATEMENT, STAY, STOGROUP, STORES, STYLE, SUMMARY, SYNONYM, TABLE, TABLESPACE, THEN, TO, TRIGGER, TRUNCATE, TYPE, UNDO, UNION, UNIQUE, UNTIL, UPDATE, USER, USING, VALIDPROC, VALUE, VALUES, VARIABLE, VARIANT, VCAT, VIEW, VOLATILE , VOLUMES, WHEN, WHENEVER, WHERE, WHILE, WITH, WLM, XMLEXISTS, XMLNAMESPACES, XMLCAST, YEAR, YEARS.