ftp.editplus.com

home *** CD-ROM | disk | FTP | other *** search

/ ftp.editplus.com / 2015-02-07.ftp.editplus.com.tar / ftp.editplus.com / files / db2.stx < prev next >

Wrap

Text File | 2008-11-26 | 4KB | 472 lines

#TITLE=db2 ; EditPlus Syntax File written by Anothai Akechotikun, eMail: nothai@gmail.com ; This file is provided a editplus syntax for support DB2/SQL #DELIMITER=,(){}[]-+*%/='"'~!&|\<>?:;@ #QUOTATION1=' #QUOTATION2='' #CONTINUE_QUOTE=|| #LINECOMMENT=-- #COMMENTON=/* #COMMENTOFF=*/ #SUFFIX3=. #PREFIX4=. #ESCAPE= #CASE=n #AUTOCASE=y #SPECIAL_STX=db2 #KEYWORD=Reserved words ADD AFTER ALIAS ALL ALLOCATE ALLOW ALTER AND ANY APPLICATION AS ASSOCIATE ASUTIME AUDIT AUTHORIZATION AUX AUXILIARY BEFORE BEGIN BETWEEN BINARY BUFFERPOOL BY CACHE CALL CALLED CAPTURE CARDINALITY CASCADED CASE CAST CCSID CHAR CHARACTER CHECK CLOSE CLUSTER COLLECTION COLLID COLUMN COMMENT COMMIT CONCAT CONDITION CONNECT CONNECTION CONSTRAINT CONTAINS CONTINUE COUNT COUNT_BIG CREATE CROSS CURRENT CURRENT_DATE CURRENT_LC_CTYPE CURRENT_PATH CURRENT_SERVER CURRENT_TIME CURRENT_TIMESTAMP CURRENT_TIMEZONE CURRENT_USER CURSOR CYCLE DATA DATABASE DAY DAYS DB2GENERAL DB2GENRL DB2SQL DBINFO DECLARE DEFAULT DEFAULTS DEFINITION DELETE DESCRIPTOR DETERMINISTIC DISALLOW DISCONNECT DISTINCT DO DOUBLE DROP DSNHATTR DSSIZE DYNAMIC EACH EDITPROC ELSE ELSEIF ENCODING END END-EXEC END-EXEC1 ERASE ESCAPE EXCEPT EXCEPTION EXCLUDING EXECUTE EXISTS EXIT EXTERNAL FENCED FETCH FIELDPROC FILE FINAL FOR FOREIGN FREE FROM FULL FUNCTION GENERAL GENERATED GET GLOBAL GO GOTO GRANT GRAPHIC GROUP HANDLER HAVING HOLD HOUR HOURS IDENTITY IF IMMEDIATE IN INCLUDING INCREMENT INDEX INDICATOR INHERIT INNER INOUT INSENSITIVE INSERT INTEGRITY INTO IS ISOBID ISOLATION ITERATE JAR JAVA JOIN KEY LABEL LANGUAGE LC_CTYPE LEAVE LEFT LIKE LINKTYPE LOCAL LOCALE LOCATOR LOCATORS LOCK LOCKMAX LOCKSIZE LONG LOOP MAXVALUE MICROSECOND MICROSECONDS MINUTE MINUTES MINVALUE MODE MODIFIES MONTH MONTHS NEW NEW_TABLE NO NOCACHE NOCYCLE NODENAME NODENUMBER NOMAXVALUE NOMINVALUE NOORDER NOT NULL NULLS NUMPARTS OBID OF OLD OLD_TABLE ON OPEN OPTIMIZATION OPTIMIZE OPTION OR ORDER OUT OUTER OVERRIDING PACKAGE PARAMETER PART PARTITION PATH PIECESIZE PLAN POSITION PRECISION PREPARE PRIMARY PRIQTY PRIVILEGES PROCEDURE PROGRAM PSID QUERYNO READ READS RECOVERY REFERENCES REFERENCING RELEASE RENAME REPEAT RESET RESIGNAL RESTART RESTRICT RESULT RESULT_SET_LOCATOR RETURN RETURNS REVOKE RIGHT ROLLBACK ROUTINE ROW ROWS RRN RUN SAVEPOINT SCHEMA SCRATCHPAD SECOND SECONDS SECQTY SECURITY SELECT SENSITIVE SET SIGNAL SIMPLE SOME SOURCE SPECIFIC SQL SQLID STANDARD START STATIC STAY STOGROUP STORES STYLE SUBPAGES SUBSTRING SYNONYM SYSFUN SYSIBM SYSPROC SYSTEM TABLE TABLESPACE THEN TO TRANSACTION TRIGGER TRIM TYPE UNDO UNION UNIQUE UNTIL UPDATE USAGE USER USING VALIDPROC VALUES VARIABLE VARIANT VCAT VIEW VOLUMES WHEN WHERE WHILE WITH WLM WRITE YEAR YEARS #KEYWORD=Scalar function ABS ABSVAL ACOS ASCII ASIN ATAN ATAN2 ATANH BIGINT BLOB CEIL CEILING CHAR CHR CLOB COALESCE CONCAT COS COSH COT DATE DAY DAYNAME DAYOFWEEK DAYOFWEEK_ISO DAYOFYEAR DAYS DBCLOB DBPARTITIONNUM DECIMAL DECRYPT_BIN DECRYPT_CHAR DECRYPT_BIN DECRYPT_CHAR DEGREES DEREF DIFFERENCE DIGITS DLCOMMENT DLLINKTYPE DLNEWCOPY DLPREVIOUSCOPY DLREPLACECONTENT DLURLCOMPLETE DLURLCOMPLETEONLY DLURLCOMPLETEWRITE DLURLPATH DLURLPATHONLY DLURLPATHWRITE DLURLSCHEME DLURLSERVER DLVALUE DOUBLE ENCRYPT EVENT_MON_STATE EXP FLOAT FLOOR Function Function GENERATE_UNIQUE GETHINT GRAPHIC HASHEDVALUE HEX HOUR IDENTITY_VAL_LOCAL INSERT INTEGER JULIAN_DAY LCASE LOWER LEFT LENGTH LN LOCATE LOG LOG10 LONG_VARCHAR LONG_VARGRAPHIC LTRIM MICROSECOND MIDNIGHT_SECONDS MINUTE MOD MONTH MONTHNAME MULTIPLY_ALT NULLIF POSSTR POWER QUARTER RADIANS RAISE_ERROR RAND REAL REC2XML REPEAT REPLACE RIGHT ROUND RTRIM SECOND SIGN SIN SINH SMALLINT SOUNDEX SPACE SQRT SUBSTR TABLE_NAME TABLE_SCHEMA TAN TANH TIME TIMESTAMP TIMESTAMP_FORMAT TIMESTAMP_ISO TIMESTAMPDIFF TO_CHAR TO_DATE TRANSLATE TRUNCATE TRUNC TYPE_ID TYPE_NAME TYPE_SCHEMA UCASE UPPER VALUE VARCHAR VARCHAR_FORMAT VARGRAPHIC WEEK WEEK_ISO YEAR #