Appendix C - Reserved Words and Key Words

Reserved Words

The following is a list of reserved words in s-Server:

ABS, ALL, ALLOCATE, ALLOW, ALTER, ANALYZE, AND, ANY, ARE, ARRAY, AS, ASENSITIVE, ASYMMETRIC, AT, ATOMIC, AUTHORIZATION, AVG, BEGIN, BETWEEN, BIGINT, BINARY, BIT, BLOB, BOOLEAN, BOTH, BY, CALL, CALLED, CARDINALITY, CASCADED, CASE, CAST, CEIL, CEILING, CHAR, CHAR_LENGTH, CHARACTER, CHARACTER_LENGTH, CHECK, CHECKPOINT, CLOB, CLOSE, CLUSTERED, COALESCE, COLLATE, COLLECT, COLUMN, COMMIT, CONDITION, CONNECT, CONSTRAINT, CONVERT, CORR, CORRESPONDING, COUNT, COVAR_POP, COVAR_SAMP, CREATE, CROSS, CUBE, CUME_DIST, CURRENT, CURRENT_CATALOG, CURRENT_DATE, CURRENT_DEFAULT_TRANSFORM_GROUP, CURRENT_PATH, CURRENT_ROLE, CURRENT_SCHEMA, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_TRANSFORM_GROUP_FOR_TYPE, CURRENT_USER, CURSOR, CYCLE, DATE, DAY, DEALLOCATE, DEC, DECIMAL, DECLARE, DEFAULT, DELETE, DENSE_RANK, DEREF, DESCRIBE, DETERMINISTIC, DISALLOW, DISCONNECT, DISTINCT, DOUBLE, DROP, DYNAMIC, EACH, ELEMENT, ELSE, END, END-EXEC, ESCAPE, EVERY, EXCEPT, EXEC, EXECUTE, EXISTS, EXP, EXP_AVG, EXPLAIN, EXTERNAL, EXTRACT, FALSE, FETCH, FILTER, FIRST_VALUE, FLOAT, FLOOR, FOR, FOREIGN, FREE, FROM, FULL, FUNCTION, FUSION, GET, GLOBAL, GRANT, GROUP, GROUPING, HAVING, HOLD, HOUR, IDENTITY, IGNORE, IMPORT, IN, INDICATOR, INITCAP, INNER, INOUT, INSENSITIVE, INSERT, INT, INTEGER, INTERSECT, INTERSECTION, INTERVAL, INTO, IS, JOIN, LANGUAGE, LARGE, LAST_VALUE, LATERAL, LEADING, LEFT, LIKE, LIMIT, LN, LOCAL, LOCALTIME, LOCALTIMESTAMP, LOWER, MATCH, MAX, MEMBER, MERGE, METHOD, MIN, MINUTE, MOD, MODIFIES, MODULE, MONTH, MULTISET, NATIONAL, NATURAL, NCHAR, NCLOB, NEW, NO, NODE, NONE, NORMALIZE, NOT, NTH_VALUE, NULL, NULLIF, NUMERIC, OCTET_LENGTH, OF, OLD, ON, ONLY, OPEN, OR, ORDER, OUT, OUTER, OVER, OVERLAPS, OVERLAY, PARAMETER, PARTITION, PERCENT_RANK, PERCENTILE_CONT, PERCENTILE_DISC, POSITION, POWER, PRECISION, PREPARE, PRIMARY, PROCEDURE, RANGE, RANK, READS, REAL, RECURSIVE, REF, REFERENCES, REFERENCING, REGR_AVGX, REGR_AVGY, REGR_COUNT, REGR_INTERCEPT, REGR_R2, REGR_SLOPE, REGR_SXX, REGR_SXY, RELEASE, RESPECT, RESULT, RETURN, RETURNS, REVOKE, RIGHT, ROLLBACK, ROLLUP, ROW, ROW_NUMBER, ROWS, SAVEPOINT, SCOPE, SCROLL, SEARCH, SECOND, SELECT, SENSITIVE, SESSION_USER, SET, SIMILAR, SMALLINT, SOME, SORT, SPECIFIC, SPECIFICTYPE, SQL, SQLEXCEPTION, SQLSTATE, SQLWARNING, SQRT, START, STATIC, STDDEV, STDDEV_POP, STDDEV_SAMP, STOP, STREAM, SUBMULTISET, SUBSTRING, SUM, SYMMETRIC, SYSTEM, SYSTEM_USER, TABLE, TABLESAMPLE, THEN, TIME, TIMESTAMP, TIMEZONE_HOUR, TIMEZONE_MINUTE, TINYINT, TO, TRAILING, TRANSLATE, TRANSLATION, TREAT, TRIGGER, TRIM, TRUE, TRUNCATE, UESCAPE, UNION, UNIQUE, UNKNOWN, UNNEST, UPDATE, UPPER, USER, USING, VALUE, VALUES, VAR_POP, VAR_SAMP, VARBINARY, VARCHAR, VARYING, WHEN, WHENEVER, WHERE, WIDTH_BUCKET, WINDOW, WITH, WITHIN, WITHOUT, YEAR.

Non-reserved Keywords

The following is a list of keywords that are not reserved words.

ABSOLUTE, GOTO, PUMP ADA, HIERARCHY, REBUILD ADMIN, IDENTIFIED, REMOVE ALWAYS, IMPLEMENTATION, REPEATABLE ASSERTION, INCREMENT, RESIDING ATTRIBUTE, INITIALLY, RESTART BASELINE, INSTALL, RETURNED_CARDINALITY BERNOULLI, INSTANTIABLE, RETURNED_OCTET_LENGTH C, IPADDRESS, ROLE CATALOG, JAR, ROUTINE_CATALOG CHAIN, K, ROUTINE_SCHEMA CHARACTERS, KEY_MEMBER, SAMPLE CHARACTER_SET_NAME, LABEL, SCHEMA CLASS_ORIGIN, LENGTH, SCOPE_CATALOGS CLOSING, LIBRARY, SCOPE_SCHEMA COLLATION, LISTEN, SECURITY COLLATION_NAME, LOCATOR, SEQUENCE COLUMNS, MAP, SERVER COMMAND_FUNCTION, MAXVALUE, SESSION COMMITTED, MESSAGE_OCTET_LENGTH, SIMPLE CONDITION_NUMBER, MINVALUE, SLEEP CONNECTION_NAME, MTU, SPACE CONSTRAINT_CATALOG, MUMPS, SQLACTIONS CONSTRAINT_SCHEMA, NAMES, STATE CONTAINS, NEXT, STATISTICS CONTROL, NULLABLE, STRUCTURE DATA, NUMBER, SUBCLASS_ORIGIN DATETIME_INTERVAL_PRECISION, OCTETS, TABLE_NAME DEFERRABLE, ONLINE, TEMPORARY DEFINED, OPTION, TIMEOUT DEGREE, ORDERING, TOP_LEVEL_COUNT DERIVED, OTHERS, TRANSACTIONS_ACTIVE DESCRIPTION, OVERRIDING, TRANSACTIONS_ROLLED_BACK DIAGNOSTICS, PARAMETER_MODE, TRANSFORMS DOMAIN, PARAMETER_ORDINAL_POSITION, TRIGGER_NAME DRIVER, PARAMETER_SPECIFIC_NAME, TYPE DYNAMIC_FUNCTION_CODE, PARTIAL, UNCOMMITTED ERROR, PASSTHROUGH, UNNAMED EXCEPTION, PEER, UP EXCLUDING, PING, USAGE FAIL, PLAN, USER_DEFINED_TYPE_CODE FIRST, PLI, USER_DEFINED_TYPE_SCHEMA FORTRAN, PRECEDING, VIEW G, PRIOR, WRAPPER GENERATED, PROCESSING, XML