Previous Topic: Table RestrictionsNext Topic: Operations Performed With the CA OPS/MVS SQL


Reserved Keywords in SQL Statements

Following is a list of reserved keywords in SQL statements. When specifying columns for relational tables, do not use these keywords as column names. The list may grow in future versions of the SQL standard component.

ADD

DELETE

KEY

SCHEMA*

ALTER

DESC

LEADING

SECOND 

AND

DISTINCT

LEFT*

SELECT 

AS 

DOUBLE*

LIKE

SET

ASC

DROP

LOCK*

SMALLINT

AVG

ESCAPE

LOWER 

SQLCODE

BETWEEN

EXISTS*

MAX

SQLMSG 

BOTH

EXTRACT

MIN

SUBSTR 

BY 

FETCH 

MINUS*

SUM

BYTE

FIRST 

MINUTE 

SYNONYM*

BYTES

FLOAT*

MONTH 

TABLE 

CASE

FOR

NATURAL*

TEMPORARY

CHAR

FORMAT

NEXT

TIME

CHAR_LENGTH

FROM

NOT

TIMESTAMP

CLOSE

FULL*

NULL

TO 

COALESCE

GLOBAL 

NUMBER 

TRAILING

COLUMN

GRANT*

NUMERIC

TRIGGER*

COMMIT*

GRAPHIC*

OF 

TRIM

COUNT

GROUP 

ON*

UNION*

CREATE

HAVING 

OPEN

UNIQUE 

CROSS

HEX

OPTION*

UPDATE 

CURRENT

HOUR

OR 

UPPER 

CURSOR

IN 

ORDER 

USER

DATABASE

INDEX 

OUTER*

USING*

DATE

INDICATOR

POSITION

VALIDATE*

DAY

INNER*

PRECISION* 

VALUES 

DEBUG

INSERT 

PRIMARY

VARCHAR

DEC

INT

PRIOR*

VIEW*

DECIMAL

INTEGER

REAL*

WHERE 

DECLARE

INTO

RIGHT*

WHILE 

DEFAULT

IS 

ROLLBACK*

WITH

DEFINITION 

JOIN

ROW

WITHIN 

 

 

 

YEAR

* Currently unsupported under CA OPS/MVS. However, these keywords may be supported in future releases of the product.