Progress
SQL-92
Guide and Reference


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:

error(-20003): Syntax error
error(-20049): Keyword used for a name 

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


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095