Filter
Top Products
■
SIN(float)
■
SQRT(float)
■
TAN(float)
SQL Words That Are Allowed in Queries
Some SQL reserved words (such as BETWEEN or LIKE) are allowed in queries and are expected to
occur. An SQL reserved word cannot be used as an attribute name unless it is enclosed in double
quotes (for example, "FIRST").
The following reserved words are allowed:
ABS, ABSOLUTE, AFTER, AND, AS, ASCII, AT, BEFORE, BETWEEN, BINARY, BIT,
BIT_LENGTH, BOOLEAN, BOTH, CASE, CAST, CHAR, CHARACTER, CHARACTER_LENGTH,
CHAR_LENGTH, COALESCE, COLLATE, COLLATION, CONTAINS,COUNT, CURRENT_DATE,
CURRENT_TIME, CURRENT_TIMESTAMP, DATE, DAY, DEC,DECIMAL, DOUBLE, ELSE, ELSEIF,
END, ESCAPE, EXISTS, EXIT, EXPAND,EXTRACT, FALSE, FIRST, FOR, FROM, HOUR, IF,
IN, INT, INTEGER, INTERVAL,IS, LCASE, LEADING, LEFT, LIKE, LOWER, MATCH, MAX,
MIN, MINUTE, MONTH,NCHAR, NO, NOT, NULL, NUMERIC, OCTET_LENGTH, OF, R, PAD,
PI,POSITION, REAL, RIGHT, RTRIM, SECOND, SIZE, SMALLINT, SUBSTRING, THEN,TIME,
TIMESTAMP, TIMESTAMPDIFF, TIMESTAMPADD, TIMEZONE_HOUR, TIMEZONE_MINUTE, TO,
TRAILING, TRIM,TRUE, UCASE, UNKNOWN, UPPER, VARBINARY, VARCHAR, VARYING,
WHEN,WHENEVER, YEAR, ZONE.
Note – Even if an SQL term is on the list of allowed query terms, it is not guaranteed that the term
can actually be used in a working query. The function of this list is to determine words that will
not be treated as an identier unless enclosed in double quotes.
SQL Words That Are Not Allowed in Queries
Some SQL reserved words (such as SELECT or CREATE) are forbidden from occurring unquoted
in queries. The 5800 system server will immediately raise an exception when one of the
forbidden reserved words is used in a query. These forbidden words can be used as attribute
names by enclosing them in double quotes.
The following reserved words are forbidden:
ACTION, ADD, ALL, ALLOCATE, ALTER, ANY, APPLICATION, ARE, AREA, ASC, ASSERTION,
ATOMIC, AUTHORIZATION, AVG, BEGIN, BY, CALL, CASCADE, CASCADED, CATALOG, CHECK,
CLOSE, COLUMN, COMMIT, COMPRESS, CONNECT, CONNECTION, CONSTRAINT, CONSTRAINTS,
CONTINUE, CONVERT, CORRESPONDING, CREATE, CROSS, CURRENT, CURRENT_PATH,
CURRENT_SCHEMA, CURRENT_SCHEMAID, CURRENT_USER, CURRENT_USERID, CURSOR, DATA,
SQLWordsThatAre AllowedinQueries
SunStorageTek 5800SystemClientAPIReferenceManual • June 2008124