Progress SQL-92 Reserved Words
Reserved words are keywords. You can use keywords as identifiers in SQL statements only if you delimit them with double quotation marks. If you use keywords without delimiting them, the statement generates one of the following errors:
Table A–1 is a list of Progress SQL-92 reserved words.
Table A–1: Progress SQL-92 Reserved Words
A
|
ABS
|
ACOS
|
ADD
|
ADD_MONTHS
|
AFTER
|
ALL
|
ALTER
|
AN
|
AND
|
ANY
|
ARRAY
|
AS
|
ASC
|
ASCII
|
ASIN
|
ATAN
|
ATAN2
|
AVG
|
BEFORE
|
BEGIN
|
BETWEEN
|
BIGINT
|
BINARY
|
BIND
|
BINDING
|
BIT
|
BY
|
CALL
|
CASCADE
|
CASE
|
CAST
|
CEILING
|
CHAR
|
CHAR_LENGTH
|
CHARACTER
|
CHARACTER_LENGTH
|
CHARTOROWID
|
CHECK
|
CHR
|
CLEANUP
|
CLOSE
|
CLUSTERED
|
COALESCE
|
COLGROUP
|
COLLATE
|
COMMIT
|
COMPLEX
|
COMPRESS
|
CONCAT
|
CONNECT
|
CONSTRAINT
|
CONTAINS
|
CONTINUE
|
CONVERT
|
COS
|
COUNT
|
CREATE
|
CROSS
|
CURDATE
|
CURRENT
|
CURSOR
|
CURTIME
|
CVAR
|
DATABASE
|
DATAPAGES
|
DATE
|
DAYNAME
|
DAYOFMONTH
|
DAYOFWEEK
|
DAYOFYEAR
|
DB_NAME
|
DBA
|
DEC
|
DECIMAL
|
DECLARATION
|
DECLARE
|
DECODE
|
DEFAULT
|
DEFINITION
|
DEGREES
|
DELETE
|
DESC
|
DESCRIBE
|
DESCRIPTOR
|
DHTYPE
|
DIFFERENCE
|
DISTINCT
|
DOUBLE
|
DROP
|
EACH
|
ELSE
|
END
|
ESCAPE
|
EXCLUSIVE
|
EXEC
|
EXECUTE
|
EXISTS
|
EXIT
|
EXP
|
EXPLICIT
|
EXTENT
|
FETCH
|
FIELD FILE
|
FLOAT
|
FLOOR
|
FOR
|
FOREIGN
|
FOUND
|
FROM
|
FULL
|
GO
|
GOTO
|
GRANT
|
GREATEST
|
GROUP
|
HASH
|
HAVING
|
HOUR
|
IDENTIFIED
|
IFNULL
|
IMMEDIATE
|
IN
|
INDEX
|
INDEXPAGES
|
INDICATOR
|
INITCAP
|
INNER
|
INOUT
|
INPUT
|
INSERT
|
INSTR
|
INT
|
INTEGER
|
INTERFACE
|
INTERSECT
|
INTO
|
IS
|
JOIN
|
KEY
|
LAST_DAY
|
LCASE
|
LEAST
|
LEFT
|
LENGTH
|
LIKE
|
LINK
|
LIST
|
LOCATE
|
LOCK
|
LOG
|
LOG10
|
LONG
|
LOWER
|
LPAD
|
LTRIM
|
LVARBINARY
|
LVARCHAR
|
MAIN
|
MAX
|
METADATA_ONLY
|
MIN
|
MINUS
|
MINUTE
|
MOD
|
MODE
|
MODIFY
|
MONEY
|
MONTH
|
MONTHNAME
|
MONTHS_BETWEEN
|
NAME
|
NATIONAL
|
NATURAL
|
NCHAR
|
NEWROW
|
NEXT_DAY
|
NOCOMPRESS
|
NOT
|
NOW
|
NOWAIT
|
NULL
|
NULLIF
|
NULLVALUE
|
NUMBER
|
NUMERIC
|
NVL
|
OBJECT_ID
|
ODBC_CONVERT
|
ODBCINFO
|
OF
|
OLDROW
|
ON
|
OPEN
|
OPTION
|
OR
|
ORDER
|
OUT
|
OUTER
|
OUTPUT
|
PCTFREE
|
PI
|
POWER
|
PRECISION
|
PREFIX
|
PREPARE
|
PRIMARY
|
PRIVILEGES
|
PROCEDURE
|
PUBLIC
|
QUARTER
|
RADIANS
|
RAND
|
RANGE
|
RAW
|
REAL
|
RECORD
|
REFERENCES
|
REFERENCING
|
RENAME
|
REPEAT
|
REPLACE
|
RESOURCE
|
RESTRICT
|
RESULT
|
RETURN
|
REVOKE
|
RIGHT
|
ROLLBACK
|
ROW
|
ROWID
|
ROWIDTOCHAR
|
ROWNUM
|
RPAD
|
RTRIM
|
SEARCHED_CASE
|
SECOND
|
SECTION
|
SELECT
|
SERVICE
|
SET
|
SHARE
|
SHORT
|
SIGN
|
SIMPLE_CASE
|
SIN
|
SIZE
|
SMALLINT
|
SOME
|
SOUNDEX
|
SPACE
|
SQL
|
SQL_BIGINT
|
SQL_BINARY
|
SQL_BIT
|
SQL_CHAR
|
SQL_DATE
|
SQL_DECIMAL
|
SQL_DOUBLE
|
SQL_FLOAT
|
SQL_INTEGER
|
SQL_LONGVARBINARY
|
SQL_LONGVARCHAR
|
SQL_NUMERIC
|
SQL_REAL
|
SQL_SMALLINT
|
SQL_TIME
|
SQL_TIMESTAMP
|
SQL_TINYINT
|
SQL_TSI_DAY
|
SQL_TSI_FRAC_SECOND
|
SQL_TSI_HOUR
|
SQL_TSI_MINUTE
|
SQL_TSI_MONTH
|
SQL_TSI_QUARTER
|
SQL_TSI_SECOND
|
SQL_TSI_WEEK
|
SQL_TSI_YEAR
|
SQL_VARBINARY
|
SQL_VARCHAR
|
SQLERROR
|
SQLWARNING
|
SQRT
|
START
|
STATEMENT
|
STATISTICS
|
STOP
|
STORAGE_ATTRIBUTES
|
STORAGE_MANAGER
|
STORE_IN_PROGRESS
|
SUBSTR
|
SUBSTRING
|
SUFFIX
|
SUM
|
SUSER_NAME
|
SYNONYM
|
SYSDATE
|
SYSTIME
|
SYSTIMESTAMP
|
TABLE
|
TAN
|
THEN
|
TIME
|
TIMEOUT
|
TIMESTAMP
|
TIMESTAMPADD
|
TIMESTAMPDIFF
|
TINYINT
|
TO
|
TO_CHAR
|
TO_DATE
|
TO_NUMBER
|
TO_TIME
|
TO_TIMESTAMP
|
TPE
|
TRANSACTION
|
TRANSLATE
|
TRIGGER
|
TYPE
|
UCASE
|
UID
|
UNION
|
UNIQUE
|
UNSIGNED
|
UPDATE
|
UPPER
|
USER
|
USER_ID
|
USER_NAME
|
USING
|
UUID
|
VALUES
|
VARBINARY
|
VARCHAR
|
VARIABLES
|
VARYING
|
VERSION
|
VIEW
|
WEEK
|
WHEN
|
WHENEVER
|
WHERE
|
WITH
|
WORK
|
YEAR
|
–
|
–
|
–
|