Mercurial > hg > RemoteEditor > vim7

comparison runtime/syntax/sqlinformix.vim @ 0:76efa0be13f1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Initial revision
author atsuki
date Sat, 10 Nov 2007 15:07:22 +0900
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:76efa0be13f1
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"