OmniSci Reserved Words
Following is a list of OmniSci keywords.
ABS ACCESS ADD ALL ALLOCATE ALLOW ALTER AMMSC AND ANY ARE ARRAY_MAX_CARDINALITY ARRAY AS ASC ASENSITIVE ASYMMETRIC AT ATOMIC AUTHORIZATION AVG BEGIN_FRAME BEGIN_PARTITION BEGIN BETWEEN BIGINT BINARY BIT BLOB BOOLEAN BOTH BY CALL CALLED CARDINALITY CASCADED CASE CAST CEIL CEILING CHAR_LENGTH CHAR CHARACTER_LENGTH CHARACTER CHECK CLASSIFIER CLOB CLOSE COALESCE COLLATE COLLECT COLUMN COMMIT CONDITION CONNECT CONSTRAINT CONTAINS CONTINUE CONVERT COPY CORR CORRESPONDING COUNT COVAR_POP COVAR_SAMP CREATE CROSS CUBE CUME_DIST CURRENT_CATALOG CURRENT_DATE CURRENT_DEFAULT_TRANSFORM_GROUP CURRENT_PATH CURRENT_ROLE CURRENT_ROW CURRENT_SCHEMA CURRENT_TIME CURRENT_TIMESTAMP CURRENT_TRANSFORM_GROUP_FOR_TYPE CURRENT_USER CURRENT CURSOR CYCLE DASHBOARD DATABASE DATE_TRUNC DATE DATETIME DAY DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFINE DELETE DENSE_RANK DEREF DESC DESCRIBE DETERMINISTIC DISALLOW DISCONNECT DISTINCT DOUBLE DROP DYNAMIC EACH EDIT EDITOR ELEMENT ELSE EMPTY END_FRAME END_PARTITION END-EXEC END EQUALS ESCAPE EVERY EXCEPT EXEC EXECUTE EXISTS EXP EXPLAIN EXTEND EXTERNAL EXTRACT FALSE FETCH FILTER FIRST_VALUE FIRST FLOAT FLOOR FOR FOREIGN FOUND FRAME_ROW FREE FROM FULL FUNCTION FUSION GEOGRAPHY GEOMETRY GET GLOBAL GRANT GROUP GROUPING GROUPS HAVING HOLD HOUR IDENTITY IF ILIKE IMPORT IN INDICATOR INITIAL INNER INOUT INSENSITIVE INSERT INT INTEGER INTERSECT INTERSECTION INTERVAL INTO IS JOIN LAG LANGUAGE LARGE LAST_VALUE LAST LATERAL LEAD LEADING LEFT LENGTH LIKE_REGEX LIKE LIMIT LINESTRING LN LOCAL LOCALTIME LOCALTIMESTAMP LOWER MATCH_NUMBER MATCH_RECOGNIZE MATCH MATCHES MAX MEASURES MEMBER MERGE METHOD MIN MINUS MINUTE MOD MODIFIES MODULE MONTH MULTIPOLYGON MULTISET NATIONAL NATURAL NCHAR NCLOB NEW NEXT NO NONE NORMALIZE NOT NOW NTH_VALUE NTILE NULL NULLIF NULLX NUMERIC OCCURRENCES_REGEX OCTET_LENGTH OF OFFSET OLD OMIT ON ONE ONLY OPEN OPTIMIZE OPTION OR ORDER OUT OUTER OVER OVERLAPS OVERLAY PARAMETER PARTITION PATTERN PER PERCENT_RANK PERCENT PERCENTILE_CONT PERCENTILE_DISC PERIOD PERMUTE POINT POLYGON PORTION POSITION_REGEX POSITION POWER PRECEDES PRECISION PREPARE PREV PRIMARY PRIVILEGES PROCEDURE PUBLIC RANGE RANK READS REAL RECURSIVE REF REFERENCES REFERENCING REGR_AVGX REGR_AVGY REGR_COUNT REGR_INTERCEPT REGR_R2 REGR_SLOPE REGR_SXX REGR_SXY REGR_SYY RELEASE RENAME RESET RESULT RETURN RETURNS REVOKE RIGHT ROLE ROLLBACK ROLLUP ROW_NUMBER ROW ROWID ROWS RUNNING SAVEPOINT SCHEMA SCOPE SCROLL SEARCH SECOND SEEK SELECT SENSITIVE SESSION_USER SET SHOW SIMILAR SKIP SMALLINT SOME SPECIFIC SPECIFICTYPE SQL SQL SQLEXCEPTION SQLSTATE SQLWARNING SQRT START STATIC STDDEV_POP STDDEV_SAMP STREAM SUBMULTISET SUBSET SUBSTRING_REGEX SUBSTRING SUCCEEDS SUM SYMMETRIC SYSTEM_TIME SYSTEM_USER SYSTEM TABLE TABLESAMPLE TEMPORARY TEXT THEN TIME TIMESTAMP TIMEZONE_HOUR TIMEZONE_MINUTE TINYINT TO TRAILING TRANSLATE_REGEX TRANSLATE TRANSLATION TREAT TRIGGER TRIM_ARRAY TRIM TRUE TRUNCATE UESCAPE UNION UNIQUE UNKNOWN UNNEST UPDATE UPPER UPSERT USER USING VALUE_OF VALUE VALUES VAR_POP VAR_SAMP VARBINARY VARCHAR VARYING VERSIONING VIEW WHEN WHENEVER WHERE WIDTH_BUCKET WINDOW WITH WITHIN WITHOUT WORK YEAR