| Bram Moolenaar | d4755bb | 2004-09-02 19:12:26 +0000 | [diff] [blame] | 1 | " Vim syntax file |
| 2 | " Informix Structured Query Language (SQL) and Stored Procedure Language (SPL) |
| 3 | " Language: SQL, SPL (Informix Dynamic Server 2000 v9.2) |
| 4 | " Maintainer: Dean Hill <dhill@hotmail.com> |
| 5 | " Last Change: 2004 Aug 30 |
| 6 | |
| 7 | " For version 5.x: Clear all syntax items |
| 8 | " For version 6.x: Quit when a syntax file was already loaded |
| 9 | if version < 600 |
| 10 | syntax clear |
| 11 | elseif exists("b:current_syntax") |
| 12 | finish |
| 13 | endif |
| 14 | |
| 15 | syn case ignore |
| 16 | |
| 17 | |
| 18 | |
| 19 | " === Comment syntax group === |
| 20 | syn region sqlComment start="{" end="}" contains=sqlTodo |
| 21 | syn match sqlComment "--.*$" contains=sqlTodo |
| 22 | syn sync ccomment sqlComment |
| 23 | |
| 24 | |
| 25 | |
| 26 | " === Constant syntax group === |
| 27 | " = Boolean subgroup = |
| 28 | syn keyword sqlBoolean true false |
| 29 | syn keyword sqlBoolean null |
| 30 | syn keyword sqlBoolean public user |
| 31 | syn keyword sqlBoolean current today |
| 32 | syn keyword sqlBoolean year month day hour minute second fraction |
| 33 | |
| 34 | " = String subgroup = |
| 35 | syn region sqlString start=+"+ end=+"+ |
| 36 | syn region sqlString start=+'+ end=+'+ |
| 37 | |
| 38 | " = Numbers subgroup = |
| 39 | syn match sqlNumber "-\=\<\d*\.\=[0-9_]\>" |
| 40 | |
| 41 | |
| 42 | |
| 43 | " === Statement syntax group === |
| 44 | " SQL |
| 45 | syn keyword sqlStatement allocate alter |
| 46 | syn keyword sqlStatement begin |
| 47 | syn keyword sqlStatement close commit connect create |
| 48 | syn keyword sqlStatement database deallocate declare delete describe disconnect drop |
| 49 | syn keyword sqlStatement execute fetch flush free get grant info insert |
| 50 | syn keyword sqlStatement load lock open output |
| 51 | syn keyword sqlStatement prepare put |
| 52 | syn keyword sqlStatement rename revoke rollback select set start stop |
| 53 | syn keyword sqlStatement truncate unload unlock update |
| 54 | syn keyword sqlStatement whenever |
| 55 | " SPL |
| 56 | syn keyword sqlStatement call continue define |
| 57 | syn keyword sqlStatement exit |
| 58 | syn keyword sqlStatement let |
| 59 | syn keyword sqlStatement return system trace |
| 60 | |
| 61 | " = Conditional subgroup = |
| 62 | " SPL |
| 63 | syn keyword sqlConditional elif else if then |
| 64 | syn keyword sqlConditional case |
| 65 | " Highlight "end if" with one or more separating spaces |
| 66 | syn match sqlConditional "end \+if" |
| 67 | |
| 68 | " = Repeat subgroup = |
| 69 | " SQL/SPL |
| 70 | " Handle SQL triggers' "for each row" clause and SPL "for" loop |
| 71 | syn match sqlRepeat "for\( \+each \+row\)\=" |
| 72 | " SPL |
| 73 | syn keyword sqlRepeat foreach while |
| 74 | " Highlight "end for", etc. with one or more separating spaces |
| 75 | syn match sqlRepeat "end \+for" |
| 76 | syn match sqlRepeat "end \+foreach" |
| 77 | syn match sqlRepeat "end \+while" |
| 78 | |
| 79 | " = Exception subgroup = |
| 80 | " SPL |
| 81 | syn match sqlException "on \+exception" |
| 82 | syn match sqlException "end \+exception" |
| 83 | syn match sqlException "end \+exception \+with \+resume" |
| 84 | syn match sqlException "raise \+exception" |
| 85 | |
| 86 | " = Keyword subgroup = |
| 87 | " SQL |
| 88 | syn keyword sqlKeyword aggregate add as authorization autofree by |
| 89 | syn keyword sqlKeyword cache cascade check cluster collation |
| 90 | syn keyword sqlKeyword column connection constraint cross |
| 91 | syn keyword sqlKeyword dataskip debug default deferred_prepare |
| 92 | syn keyword sqlKeyword descriptor diagnostics |
| 93 | syn keyword sqlKeyword each escape explain external |
| 94 | syn keyword sqlKeyword file foreign fragment from function |
| 95 | syn keyword sqlKeyword group having |
| 96 | syn keyword sqlKeyword immediate index inner into isolation |
| 97 | syn keyword sqlKeyword join key |
| 98 | syn keyword sqlKeyword left level log |
| 99 | syn keyword sqlKeyword mode modify mounting new no |
| 100 | syn keyword sqlKeyword object of old optical option |
| 101 | syn keyword sqlKeyword optimization order outer |
| 102 | syn keyword sqlKeyword pdqpriority pload primary procedure |
| 103 | syn keyword sqlKeyword references referencing release reserve |
| 104 | syn keyword sqlKeyword residency right role routine row |
| 105 | syn keyword sqlKeyword schedule schema scratch session set |
| 106 | syn keyword sqlKeyword statement statistics synonym |
| 107 | syn keyword sqlKeyword table temp temporary timeout to transaction trigger |
| 108 | syn keyword sqlKeyword using values view violations |
| 109 | syn keyword sqlKeyword where with work |
| 110 | " Highlight "on" (if it's not followed by some words we've already handled) |
| 111 | syn match sqlKeyword "on \+\(exception\)\@!" |
| 112 | " SPL |
| 113 | " Highlight "end" (if it's not followed by some words we've already handled) |
| 114 | syn match sqlKeyword "end \+\(if\|for\|foreach\|while\|exception\)\@!" |
| 115 | syn keyword sqlKeyword resume returning |
| 116 | |
| 117 | " = Operator subgroup = |
| 118 | " SQL |
| 119 | syn keyword sqlOperator not and or |
| 120 | syn keyword sqlOperator in is any some all between exists |
| 121 | syn keyword sqlOperator like matches |
| 122 | syn keyword sqlOperator union intersect |
| 123 | syn keyword sqlOperator distinct unique |
| 124 | |
| 125 | |
| 126 | |
| 127 | " === Identifier syntax group === |
| 128 | " = Function subgroup = |
| 129 | " SQL |
| 130 | syn keyword sqlFunction abs acos asin atan atan2 avg |
| 131 | syn keyword sqlFunction cardinality cast char_length character_length cos count |
| 132 | syn keyword sqlFunction exp filetoblob filetoclob hex |
| 133 | syn keyword sqlFunction initcap length logn log10 lower lpad |
| 134 | syn keyword sqlFunction min max mod octet_length pow range replace root round rpad |
| 135 | syn keyword sqlFunction sin sqrt stdev substr substring sum |
| 136 | syn keyword sqlFunction to_char tan to_date trim trunc upper variance |
| 137 | |
| 138 | |
| 139 | |
| 140 | " === Type syntax group === |
| 141 | " SQL |
| 142 | syn keyword sqlType blob boolean byte char character clob |
| 143 | syn keyword sqlType date datetime dec decimal double |
| 144 | syn keyword sqlType float int int8 integer interval list lvarchar |
| 145 | syn keyword sqlType money multiset nchar numeric nvarchar |
| 146 | syn keyword sqlType real serial serial8 smallfloat smallint |
| 147 | syn keyword sqlType text varchar varying |
| 148 | |
| 149 | |
| 150 | |
| 151 | " === Todo syntax group === |
| 152 | syn keyword sqlTodo TODO FIXME XXX DEBUG NOTE |
| 153 | |
| 154 | |
| 155 | |
| 156 | " Define the default highlighting. |
| 157 | " For version 5.7 and earlier: only when not done already |
| 158 | " For version 5.8 and later: only when an item doesn't have highlighting yet |
| 159 | if version >= 508 || !exists("did_sql_syn_inits") |
| 160 | if version < 508 |
| 161 | let did_sql_syn_inits = 1 |
| 162 | command -nargs=+ HiLink hi link <args> |
| 163 | else |
| 164 | command -nargs=+ HiLink hi def link <args> |
| 165 | endif |
| 166 | |
| 167 | |
| 168 | " === Comment syntax group === |
| 169 | HiLink sqlComment Comment |
| 170 | |
| 171 | " === Constant syntax group === |
| 172 | HiLink sqlNumber Number |
| 173 | HiLink sqlBoolean Boolean |
| 174 | HiLink sqlString String |
| 175 | |
| 176 | " === Statment syntax group === |
| 177 | HiLink sqlStatement Statement |
| 178 | HiLink sqlConditional Conditional |
| 179 | HiLink sqlRepeat Repeat |
| 180 | HiLink sqlKeyword Keyword |
| 181 | HiLink sqlOperator Operator |
| 182 | HiLink sqlException Exception |
| 183 | |
| 184 | " === Identifier syntax group === |
| 185 | HiLink sqlFunction Function |
| 186 | |
| 187 | " === Type syntax group === |
| 188 | HiLink sqlType Type |
| 189 | |
| 190 | " === Todo syntax group === |
| 191 | HiLink sqlTodo Todo |
| 192 | |
| 193 | delcommand HiLink |
| 194 | endif |
| 195 | |
| 196 | let b:current_syntax = "sqlinformix" |