Reserved Words

The following table lists SQL reserved words. Do not form names using any of these words as SQL identifiers. See Identifiers.

Note: The SQL transport utility (DDTRSLM) has additional restrictions on words used for an AUTHID, SQL name, or CA Datacom Datadictionary occurrence name. See the CA Datacom Datadictionary Batch Reference Guide.

In the following table, where more than one word is listed on a line, those words as a group are reserved, not necessarily the individual words that make up the group unless that word is listed separately on its own line. Words followed by an asterisk (*) indicate that word is reserved only in the COBOL language. We reserve the right to add or change reserved keywords as needed.

SQL Reserved Words

ADD AFTER ALL ALTER AND ANY ARRAY AS ASSEMBLER ASENSITIVE ATOMIC	BEFORE BEGIN BETWEEN BIT BIT_ADD BIT_AND BIT_NOT BIT_OR BIT_XOR BY BYREF	CALL CASE CAST COALESCE COLUMN COBOL CONCAT CONDITION CONTINUE HANDLER CONTAINS CONVERSION COUNT CURRENT CURSOR	DATA DATACOM DATACOM DUMP DATACOM LOOPLIMIT DATACOM TSN DELETE DESCRIPTOR DETERMINISTIC DISTINCT DO DROP
EACH ELSE ELSEIF END END-EXEC* EXECUTE EXISTS EXIT HANDLER EXTERNAL	FIRST FOR FROM FUNCTION	GENERAL GET CURRENT DIAGNOSTICS GET DIAGNOSTICS GET STACKED GET STACKED DIAGNOSTICS GRANT GROUP	HANDLER HAVING
IF IMMEDIATE IN INDEX INNER INOUT INPUT INSENSITIVE INSERT ITERATE INTEXTRACT INTO INVALIDATE IS	JOIN	KEY	LANGUAGE LEADING LEAVE LEFT LIKE LOOP LOWER LOWERCASE LTRIM
MODIFIES MUF_NAME	NEW NEWFUN1 NEWFUN2 NEWFUN3 NO NOT NOT FOUND NULL NULLIF NULLS	OF OLD ON OPTIMIZE OPTION OPTIONS OR ORDER OUT OUTER	PARAMETER PLI PRIVILEGES PROCEDURE PROGRAM
RAISE ERROR READS REFERENCING REPEAT RESIGNAL RETURN RTRIM RULE RUN	SELECT SENSITIVE SET SIGNAL SOME SPECIFIC SQL SQLEXCEPTION SQLSTATE SQLWARNING SQUEEZE STATEMENT STRIP STYLE SUBSTRING SYNONYM	TABLE THEN TO TO PXXSQL TO SYSOUT TRAILING TRIGGER TRIM TSN	UNION UNDO HANDLER UNTIL UPDATE UPPER UPPERCASE USER USING
VALUES VARCHAR VIEW	WHEN WHERE WHILE WITH WITHOUT	XMLATTRIBUTES XMLCONCAT XMLELEMENT XMLFOREST XMLSERIALIZE