13.13.1 Reserved Keywords – SQL/ODBC
The following list shows the reserved keywords for field and file identifiers that may be renamed by LANSA. These keywords are from the reserved words lists for Microsoft's SQL Server, Sybase's SQL Anywhere and Oracle's Database Server.
|
@@DBTS @@ERROR @@LANGID @@SPID ABSOLUTE ACCESS ACQUIRE ACTION ADA ADD ADDRESS AFTER AGGREGATE AHEAD ALIAS ALL ALLOCATE ALTER ANALYZE AND ANY APPEND ARE ARRAY ARRAYLEN AS ASC ASCII ASENSITIVE ASSERTION ASYMKEY_ID ASYMMETRIC AT ATOMIC AUDIT AVERAGE AVG BACKUP BADFILE BDDN BEFORE BEGIN BEGINDATA BETWEEN BINARY BIND BINDADD BIT BIT_LENGTH BLANKS BLOB BLOCK BLOCKSIZE BOOLEAN BOTH BREADTH BREAK BROWSE BUFFERPOOL BULK BY C CACHE CALL CALLED CASCADE CASE CAST CATALOG CERT_ID CHAR CHARACTER CHARINDEX CHECK CHECKPOINT CHECKSUM CLASS CLOB CLOSE CLUSTER CLUSTERED COALESCE COBOL COLLATE COLLATION COLLECT COLUMN COMMENT COMMIT COMMITTED COMPLETION COMPRESS COMPUTE CONDITION CONFIRM CONNECT CONNECTION CONSTANT CONSTRAINT CONTAINS CONTINUE CONTINUEIF CONTROL CONTROLROW CONVERT CORR COUNT COUNT_BIG COVAR_POP COVAR_SAMP CREATE CREATETAB CROSS CUBE CURRENT CURSOR CYCLE DATA DATABASE |
DATATYPE DATE DATEADD DATEDIFF DATENAME DATEPART DATETIME DAY DAYS DBA DBADM DBCC DBCS DBSPACE DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFAULTIF DEFERRABLE DEFERRED DELETE DELIMITED DENY DEPTH DEREF DESC DESCRIBE DESCRIPTOR DICTIONARY DIFFERENCE DISABLE DISCARDDN DISCARDS DISCONNECT DISK DISTINCT DO DOMAIN DOUBLE DROP DUAL DUMMY DUMP DURATION DYNAMIC EACH EDITPROC ELSE ELSEIF ENABLE ENCLOSED ENCRYPTED END END_EXEC END-EXEC ENDIF ERASE ERRLVL ERROR_LINE ERROREXIT ESCAPE ESCAPES EVERY EXCEPT EXCEPTION EXCLUSIVE EXEC EXECUTE EXEMPT EXISTS EXIT EXPLAIN EXTEND EXTENDED EXTERNAL EXTRACT FALSE FETCH FIELDPROC FIELDS FILE FILLFACTOR FIRST FIXED FLOAT FLOPPY FOR FOREIGN FORMAT FORTRAN FOUND FRACTION FREETEXT FROM FULL FUNCTION GENERATED GET GETDATE GETUTCDATE GLOBAL GO GOTO GRANT GRAPHIC GROUP GROUPING HAVING HOLD HOLDLOCK HOUR HOURS IDENTIFIED IDENTITY IF IMMEDIATE IN |
INCLUDE INCREMENT INDDN INDEX INDEXES INDICATOR INFILE INITIAL INITIALLY INNER INOUT INPUT INPUT INSERT INSTALL INSTEAD INT INTEGER INTERSECT INTERVAL INTO IS ISDATE ISNULL ISNUMERIC ISOLATION JOIN KEY KEY_GUID KEY_ID KEY_NAME KILL LABEL LABELS LANGUAGE LAST LEADING LEAVE LEFT LENGTH LEVEL LIKE LINENO LIST LOAD LOCAL LOCK LOCKSIZE LOG LONG LOOP LOWER LTRIM MATCH MAX MAXEXTENTS MEMBERSHIP MERGE MESSAGE MIN MINUS MINUTE MINUTES MIRROREXIT MIXED MODE MODIFY MODULE MONTH MONTHS N NAME NAMED NAMES NATIONAL NATURAL NCHAR NETWORK NEW NEXT NHEADER NO NOAUDIT NOCHECK NOCOMPRESS NOHOLDLOCK NONE NOT NOTFOUND NOTIFY NOWAIT NULL NULLCOLS NULLIF NUMBER NUMERIC NUMPARTS NVARCHAR OF OFF OFFLINE OFFSET OFFSETS OLD ON ONCE ONLINE ONLY OPEN OPENQUERY OPENROWSET OPENXML OPTIMIZER OPTION OPTIONALLY OPTIONS OR ORDER |
OTHERS OUT OUTER OUTPUT OVER OVERLAPS PACKAGE PAD PAGE PAGES PARALLEL PART PARTIAL PASCAL PATINDEX PCTFREE PCTINDEX PENDANT PERCENT PERM PERMANENT PIECED PIPE PIVOT PLAN PLI POSITION PRECISION PREPARE PRESERVE PRIMARY PRIOR PRIQTY PRIVATE PRIVILEGES PROC PROCEDURE PROGRAM PUBLIC PUBLISH PUBLISHER PURGE PUT QUOTENAME QUOTES RAISERROR RAND RAW READ READTEXT REAL RECEIVED RECLEN RECNUM RECOMPILE RECORD REFERENCE REFERENCES RELATIVE RELEASE REMOTE REMOVE RENAME REOPEN REPEATABLE REPLACE REPLICATE RERECEIVE RESEND RESET RESIGNAL RESOLVE RESOURCE RESTORE RESTRICT RESULT RESUME RETURN RETURNS REVERSE REVERT REVOKE RIGHT ROLLBACK ROUND ROW ROWCOUNT ROWGUIDCOL ROWID ROWLABEL ROWNUM ROWS RTRIM RULE RUN SAVE SAVEPOINT SBCS SCHEDULE SCHEMA SCROLL SECOND SECONDS SECQTY SECTION SELECT SEND SENT SEQUENCE SESSION SET SETTING SETUSER SHARE SHUTDOWN SIGNAL SIGNBYCERT |
SIZE SKIP SMALLINT SOME SORTDEVT SORTED SORTNUM SOUNDEX SPACE SQL SQLBUF SQLCA SQLCODE SQLERROR SQLSTATE SQLWARNING SQRT SQUARE START STATEMENT STATISTICS STDEV STDEVP STOGROUP STOP STORPOOL STR STREAM STRIP STUFF SUBSCRIBE SUBSTR SUBSTRING SUBTRANS SUCCESSFUL SUM SYNONYM SYSDATE SYSTEM TABLE TABLEGROUP TABLESPACE TAPE TEMP TEMPORARY TERMINATED TEST TEXT TEXTPTR TEXTSIZE TEXTVALID THEN THIS TIME TIMESTAMP TINYINT TO TOP TRAILING TRAN TRANSLATE TRIGGER TRIM TRUE TRUNCATE TSEQUAL TYPE UID UNICODE UNION UNIQUE UNITS UNKNOWN UNLOAD UNLOCK UNPIVOT UNTIL UPDATE UPDATETEXT UPPER USAGE USE USER USING VALIDATE VALIDPROC VALUE VALUES VAR VARBINARY VARCHAR VARCHAR2 VARGRAPHIC VARIABLE VARIABLES VARP VARYING VCAT VERIFY VIEW VOLUMES WAIT WAITFOR WHEN WHENEVER WHERE WHILE WHITESPACE WITH WORK WORKDDM WRITE WRITETEXT YEAR YEARS YES ZONE ZONED |