■SIN(float)
■SQRT(float)
■TAN(float)
SQLWords That Are Allowed in Queries
SomeSQL 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").
Thefollowing 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
canactually be used in a working query. The function of this list is to determine words that will
notbe treated as an identier unless enclosed in double quotes.
SQLWords That Are Not Allowed in Queries
SomeSQL reserved words (such as SELECT or CREATE) are forbidden from occurring unquoted
inqueries. The 5800 system server will immediately raise an exception when one of the
forbiddenreserved words is used in a query. These forbidden words can be used as attribute
namesby enclosing them in double quotes.
Thefollowing 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,
SQLWordsThat Are Allowedin Queries
SunStorageTek5800 System Client API Reference Manual • June 2008124