blob: 57ed158f986d0d349c2d90ecf834c082b2347e22 [file] [log] [blame]
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +00001" Vim syntax file
2" Language: SQL, Adaptive Server Anywhere
3" Maintainer: David Fishburn <fishburn at ianywhere dot com>
Bram Moolenaar5c736222010-01-06 20:54:52 +01004" Last Change: 2009 Mar 15
5" Version: 11.0.1
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +00006
Bram Moolenaar5c736222010-01-06 20:54:52 +01007" Description: Updated to Adaptive Server Anywhere 11.0.1
8" Updated to Adaptive Server Anywhere 10.0.1
Bram Moolenaar446cb832008-06-24 21:56:24 +00009" Updated to Adaptive Server Anywhere 9.0.2
10" Updated to Adaptive Server Anywhere 9.0.1
11" Updated to Adaptive Server Anywhere 9.0.0
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +000012"
13" For version 5.x: Clear all syntax items
14" For version 6.x: Quit when a syntax file was already loaded
15if version < 600
16 syntax clear
17elseif exists("b:current_syntax")
18 finish
19endif
20
21syn case ignore
22
23" The SQL reserved words, defined as keywords.
24
25syn keyword sqlSpecial false null true
26
27" common functions
Bram Moolenaar446cb832008-06-24 21:56:24 +000028syn keyword sqlFunction count sum avg min max debug_eng isnull
29syn keyword sqlFunction greater lesser argn string ymd todate
30syn keyword sqlFunction totimestamp date today now utc_now
31syn keyword sqlFunction number identity years months weeks days
32syn keyword sqlFunction hours minutes seconds second minute hour
33syn keyword sqlFunction day month year dow date_format substr
34syn keyword sqlFunction substring byte_substr length byte_length
35syn keyword sqlFunction datalength ifnull evaluate list
36syn keyword sqlFunction soundex similar difference like_start
37syn keyword sqlFunction like_end regexp_compile
38syn keyword sqlFunction regexp_compile_patindex remainder abs
39syn keyword sqlFunction graphical_plan plan explanation ulplan
40syn keyword sqlFunction graphical_ulplan long_ulplan
41syn keyword sqlFunction short_ulplan rewrite watcomsql
42syn keyword sqlFunction transactsql dialect estimate
43syn keyword sqlFunction estimate_source index_estimate
44syn keyword sqlFunction experience_estimate traceback wsql_state
45syn keyword sqlFunction lang_message dateadd datediff datepart
46syn keyword sqlFunction datename dayname monthname quarter
47syn keyword sqlFunction tsequal hextoint inttohex rand textptr
48syn keyword sqlFunction rowid grouping stddev variance rank
49syn keyword sqlFunction dense_rank density percent_rank user_name
50syn keyword sqlFunction user_id str stuff char_length nullif
51syn keyword sqlFunction sortkey compare ts_index_statistics
52syn keyword sqlFunction ts_table_statistics isdate isnumeric
53syn keyword sqlFunction get_identity lookup newid uuidtostr
54syn keyword sqlFunction strtouuid varexists
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +000055
56" 9.0.1 functions
Bram Moolenaar5c736222010-01-06 20:54:52 +010057syn keyword sqlFunction acos asin atan atn2 cast ceiling convert cos cot
Bram Moolenaar446cb832008-06-24 21:56:24 +000058syn keyword sqlFunction char_length coalesce dateformat datetime degrees exp
Bram Moolenaar5c736222010-01-06 20:54:52 +010059syn keyword sqlFunction floor getdate insertstr
Bram Moolenaar446cb832008-06-24 21:56:24 +000060syn keyword sqlFunction log log10 lower mod pi power
Bram Moolenaar5c736222010-01-06 20:54:52 +010061syn keyword sqlFunction property radians replicate round sign sin
Bram Moolenaar446cb832008-06-24 21:56:24 +000062syn keyword sqlFunction sqldialect tan truncate truncnum
63syn keyword sqlFunction base64_encode base64_decode
64syn keyword sqlFunction hash compress decompress encrypt decrypt
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +000065
Bram Moolenaar5c736222010-01-06 20:54:52 +010066" 11.0.1 functions
67syn keyword sqlFunction connection_extended_property text_handle_vector_match
68syn keyword sqlFunction read_client_file write_client_file
69
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +000070" string functions
Bram Moolenaar446cb832008-06-24 21:56:24 +000071syn keyword sqlFunction ascii char left ltrim repeat
72syn keyword sqlFunction space right rtrim trim lcase ucase
73syn keyword sqlFunction locate charindex patindex replace
Bram Moolenaar5c736222010-01-06 20:54:52 +010074syn keyword sqlFunction errormsg csconvert
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +000075
76" property functions
Bram Moolenaar446cb832008-06-24 21:56:24 +000077syn keyword sqlFunction db_id db_name property_name
78syn keyword sqlFunction property_description property_number
79syn keyword sqlFunction next_connection next_database property
80syn keyword sqlFunction connection_property db_property db_extended_property
81syn keyword sqlFunction event_parmeter event_condition event_condition_name
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +000082
83" sa_ procedures
Bram Moolenaar446cb832008-06-24 21:56:24 +000084syn keyword sqlFunction sa_add_index_consultant_analysis
85syn keyword sqlFunction sa_add_workload_query
86syn keyword sqlFunction sa_app_deregister
87syn keyword sqlFunction sa_app_get_infoStr
88syn keyword sqlFunction sa_app_get_status
89syn keyword sqlFunction sa_app_register
90syn keyword sqlFunction sa_app_registration_unlock
91syn keyword sqlFunction sa_app_set_infoStr
92syn keyword sqlFunction sa_audit_string
93syn keyword sqlFunction sa_check_commit
94syn keyword sqlFunction sa_checkpoint_execute
95syn keyword sqlFunction sa_conn_activity
96syn keyword sqlFunction sa_conn_compression_info
97syn keyword sqlFunction sa_conn_deregister
98syn keyword sqlFunction sa_conn_info
99syn keyword sqlFunction sa_conn_properties
100syn keyword sqlFunction sa_conn_properties_by_conn
101syn keyword sqlFunction sa_conn_properties_by_name
102syn keyword sqlFunction sa_conn_register
103syn keyword sqlFunction sa_conn_set_status
104syn keyword sqlFunction sa_create_analysis_from_query
105syn keyword sqlFunction sa_db_info
106syn keyword sqlFunction sa_db_properties
107syn keyword sqlFunction sa_disable_auditing_type
108syn keyword sqlFunction sa_disable_index
109syn keyword sqlFunction sa_disk_free_space
110syn keyword sqlFunction sa_enable_auditing_type
111syn keyword sqlFunction sa_enable_index
112syn keyword sqlFunction sa_end_forward_to
113syn keyword sqlFunction sa_eng_properties
114syn keyword sqlFunction sa_event_schedules
115syn keyword sqlFunction sa_exec_script
116syn keyword sqlFunction sa_flush_cache
117syn keyword sqlFunction sa_flush_statistics
118syn keyword sqlFunction sa_forward_to
119syn keyword sqlFunction sa_get_dtt
120syn keyword sqlFunction sa_get_histogram
121syn keyword sqlFunction sa_get_request_profile
122syn keyword sqlFunction sa_get_request_profile_sub
123syn keyword sqlFunction sa_get_request_times
124syn keyword sqlFunction sa_get_server_messages
125syn keyword sqlFunction sa_get_simulated_scale_factors
126syn keyword sqlFunction sa_get_workload_capture_status
127syn keyword sqlFunction sa_index_density
128syn keyword sqlFunction sa_index_levels
129syn keyword sqlFunction sa_index_statistics
130syn keyword sqlFunction sa_internal_alter_index_ability
131syn keyword sqlFunction sa_internal_create_analysis_from_query
132syn keyword sqlFunction sa_internal_disk_free_space
133syn keyword sqlFunction sa_internal_get_dtt
134syn keyword sqlFunction sa_internal_get_histogram
135syn keyword sqlFunction sa_internal_get_request_times
136syn keyword sqlFunction sa_internal_get_simulated_scale_factors
137syn keyword sqlFunction sa_internal_get_workload_capture_status
138syn keyword sqlFunction sa_internal_index_density
139syn keyword sqlFunction sa_internal_index_levels
140syn keyword sqlFunction sa_internal_index_statistics
141syn keyword sqlFunction sa_internal_java_loaded_classes
142syn keyword sqlFunction sa_internal_locks
143syn keyword sqlFunction sa_internal_pause_workload_capture
144syn keyword sqlFunction sa_internal_procedure_profile
145syn keyword sqlFunction sa_internal_procedure_profile_summary
146syn keyword sqlFunction sa_internal_read_backup_history
147syn keyword sqlFunction sa_internal_recommend_indexes
148syn keyword sqlFunction sa_internal_reset_identity
149syn keyword sqlFunction sa_internal_resume_workload_capture
150syn keyword sqlFunction sa_internal_start_workload_capture
151syn keyword sqlFunction sa_internal_stop_index_consultant
152syn keyword sqlFunction sa_internal_stop_workload_capture
153syn keyword sqlFunction sa_internal_table_fragmentation
154syn keyword sqlFunction sa_internal_table_page_usage
155syn keyword sqlFunction sa_internal_table_stats
156syn keyword sqlFunction sa_internal_virtual_sysindex
157syn keyword sqlFunction sa_internal_virtual_sysixcol
158syn keyword sqlFunction sa_java_loaded_classes
159syn keyword sqlFunction sa_jdk_version
160syn keyword sqlFunction sa_locks
161syn keyword sqlFunction sa_make_object
162syn keyword sqlFunction sa_pause_workload_capture
163syn keyword sqlFunction sa_proc_debug_attach_to_connection
164syn keyword sqlFunction sa_proc_debug_connect
165syn keyword sqlFunction sa_proc_debug_detach_from_connection
166syn keyword sqlFunction sa_proc_debug_disconnect
167syn keyword sqlFunction sa_proc_debug_get_connection_name
168syn keyword sqlFunction sa_proc_debug_release_connection
169syn keyword sqlFunction sa_proc_debug_request
170syn keyword sqlFunction sa_proc_debug_version
171syn keyword sqlFunction sa_proc_debug_wait_for_connection
172syn keyword sqlFunction sa_procedure_profile
173syn keyword sqlFunction sa_procedure_profile_summary
174syn keyword sqlFunction sa_read_backup_history
175syn keyword sqlFunction sa_recommend_indexes
176syn keyword sqlFunction sa_recompile_views
177syn keyword sqlFunction sa_remove_index_consultant_analysis
178syn keyword sqlFunction sa_remove_index_consultant_workload
179syn keyword sqlFunction sa_reset_identity
180syn keyword sqlFunction sa_resume_workload_capture
181syn keyword sqlFunction sa_server_option
182syn keyword sqlFunction sa_set_simulated_scale_factor
183syn keyword sqlFunction sa_setremoteuser
184syn keyword sqlFunction sa_setsubscription
185syn keyword sqlFunction sa_start_recording_commits
186syn keyword sqlFunction sa_start_workload_capture
187syn keyword sqlFunction sa_statement_text
188syn keyword sqlFunction sa_stop_index_consultant
189syn keyword sqlFunction sa_stop_recording_commits
190syn keyword sqlFunction sa_stop_workload_capture
191syn keyword sqlFunction sa_sync
192syn keyword sqlFunction sa_sync_sub
193syn keyword sqlFunction sa_table_fragmentation
194syn keyword sqlFunction sa_table_page_usage
195syn keyword sqlFunction sa_table_stats
196syn keyword sqlFunction sa_update_index_consultant_workload
197syn keyword sqlFunction sa_validate
198syn keyword sqlFunction sa_virtual_sysindex
199syn keyword sqlFunction sa_virtual_sysixcol
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000200
201" sp_ procedures
Bram Moolenaar446cb832008-06-24 21:56:24 +0000202syn keyword sqlFunction sp_addalias
203syn keyword sqlFunction sp_addauditrecord
204syn keyword sqlFunction sp_adddumpdevice
205syn keyword sqlFunction sp_addgroup
206syn keyword sqlFunction sp_addlanguage
207syn keyword sqlFunction sp_addlogin
208syn keyword sqlFunction sp_addmessage
209syn keyword sqlFunction sp_addremotelogin
210syn keyword sqlFunction sp_addsegment
211syn keyword sqlFunction sp_addserver
212syn keyword sqlFunction sp_addthreshold
213syn keyword sqlFunction sp_addtype
214syn keyword sqlFunction sp_adduser
215syn keyword sqlFunction sp_auditdatabase
216syn keyword sqlFunction sp_auditlogin
217syn keyword sqlFunction sp_auditobject
218syn keyword sqlFunction sp_auditoption
219syn keyword sqlFunction sp_auditsproc
220syn keyword sqlFunction sp_bindefault
221syn keyword sqlFunction sp_bindmsg
222syn keyword sqlFunction sp_bindrule
223syn keyword sqlFunction sp_changedbowner
224syn keyword sqlFunction sp_changegroup
225syn keyword sqlFunction sp_checknames
226syn keyword sqlFunction sp_checkperms
227syn keyword sqlFunction sp_checkreswords
228syn keyword sqlFunction sp_clearstats
229syn keyword sqlFunction sp_column_privileges
230syn keyword sqlFunction sp_columns
231syn keyword sqlFunction sp_commonkey
232syn keyword sqlFunction sp_configure
233syn keyword sqlFunction sp_cursorinfo
234syn keyword sqlFunction sp_databases
235syn keyword sqlFunction sp_datatype_info
236syn keyword sqlFunction sp_dboption
237syn keyword sqlFunction sp_dbremap
238syn keyword sqlFunction sp_depends
239syn keyword sqlFunction sp_diskdefault
240syn keyword sqlFunction sp_displaylogin
241syn keyword sqlFunction sp_dropalias
242syn keyword sqlFunction sp_dropdevice
243syn keyword sqlFunction sp_dropgroup
244syn keyword sqlFunction sp_dropkey
245syn keyword sqlFunction sp_droplanguage
246syn keyword sqlFunction sp_droplogin
247syn keyword sqlFunction sp_dropmessage
248syn keyword sqlFunction sp_dropremotelogin
249syn keyword sqlFunction sp_dropsegment
250syn keyword sqlFunction sp_dropserver
251syn keyword sqlFunction sp_dropthreshold
252syn keyword sqlFunction sp_droptype
253syn keyword sqlFunction sp_dropuser
254syn keyword sqlFunction sp_estspace
255syn keyword sqlFunction sp_extendsegment
256syn keyword sqlFunction sp_fkeys
257syn keyword sqlFunction sp_foreignkey
258syn keyword sqlFunction sp_getmessage
259syn keyword sqlFunction sp_help
260syn keyword sqlFunction sp_helpconstraint
261syn keyword sqlFunction sp_helpdb
262syn keyword sqlFunction sp_helpdevice
263syn keyword sqlFunction sp_helpgroup
264syn keyword sqlFunction sp_helpindex
265syn keyword sqlFunction sp_helpjoins
266syn keyword sqlFunction sp_helpkey
267syn keyword sqlFunction sp_helplanguage
268syn keyword sqlFunction sp_helplog
269syn keyword sqlFunction sp_helpprotect
270syn keyword sqlFunction sp_helpremotelogin
271syn keyword sqlFunction sp_helpsegment
272syn keyword sqlFunction sp_helpserver
273syn keyword sqlFunction sp_helpsort
274syn keyword sqlFunction sp_helptext
275syn keyword sqlFunction sp_helpthreshold
276syn keyword sqlFunction sp_helpuser
277syn keyword sqlFunction sp_indsuspect
278syn keyword sqlFunction sp_lock
279syn keyword sqlFunction sp_locklogin
280syn keyword sqlFunction sp_logdevice
281syn keyword sqlFunction sp_login_environment
282syn keyword sqlFunction sp_modifylogin
283syn keyword sqlFunction sp_modifythreshold
284syn keyword sqlFunction sp_monitor
285syn keyword sqlFunction sp_password
286syn keyword sqlFunction sp_pkeys
287syn keyword sqlFunction sp_placeobject
288syn keyword sqlFunction sp_primarykey
289syn keyword sqlFunction sp_procxmode
290syn keyword sqlFunction sp_recompile
291syn keyword sqlFunction sp_remap
292syn keyword sqlFunction sp_remote_columns
293syn keyword sqlFunction sp_remote_exported_keys
294syn keyword sqlFunction sp_remote_imported_keys
295syn keyword sqlFunction sp_remote_pcols
296syn keyword sqlFunction sp_remote_primary_keys
297syn keyword sqlFunction sp_remote_procedures
298syn keyword sqlFunction sp_remote_tables
299syn keyword sqlFunction sp_remoteoption
300syn keyword sqlFunction sp_rename
301syn keyword sqlFunction sp_renamedb
302syn keyword sqlFunction sp_reportstats
303syn keyword sqlFunction sp_reset_tsql_environment
304syn keyword sqlFunction sp_role
305syn keyword sqlFunction sp_server_info
306syn keyword sqlFunction sp_servercaps
307syn keyword sqlFunction sp_serverinfo
308syn keyword sqlFunction sp_serveroption
309syn keyword sqlFunction sp_setlangalias
310syn keyword sqlFunction sp_setreplicate
311syn keyword sqlFunction sp_setrepproc
312syn keyword sqlFunction sp_setreptable
313syn keyword sqlFunction sp_spaceused
314syn keyword sqlFunction sp_special_columns
315syn keyword sqlFunction sp_sproc_columns
316syn keyword sqlFunction sp_statistics
317syn keyword sqlFunction sp_stored_procedures
318syn keyword sqlFunction sp_syntax
319syn keyword sqlFunction sp_table_privileges
320syn keyword sqlFunction sp_tables
321syn keyword sqlFunction sp_tsql_environment
322syn keyword sqlFunction sp_tsql_feature_not_supported
323syn keyword sqlFunction sp_unbindefault
324syn keyword sqlFunction sp_unbindmsg
325syn keyword sqlFunction sp_unbindrule
326syn keyword sqlFunction sp_volchanged
327syn keyword sqlFunction sp_who
328syn keyword sqlFunction xp_scanf
329syn keyword sqlFunction xp_sprintf
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000330
331" server functions
Bram Moolenaar446cb832008-06-24 21:56:24 +0000332syn keyword sqlFunction col_length
333syn keyword sqlFunction col_name
334syn keyword sqlFunction index_col
335syn keyword sqlFunction object_id
336syn keyword sqlFunction object_name
337syn keyword sqlFunction proc_role
338syn keyword sqlFunction show_role
339syn keyword sqlFunction xp_cmdshell
340syn keyword sqlFunction xp_msver
341syn keyword sqlFunction xp_read_file
342syn keyword sqlFunction xp_real_cmdshell
343syn keyword sqlFunction xp_real_read_file
344syn keyword sqlFunction xp_real_sendmail
345syn keyword sqlFunction xp_real_startmail
346syn keyword sqlFunction xp_real_startsmtp
347syn keyword sqlFunction xp_real_stopmail
348syn keyword sqlFunction xp_real_stopsmtp
349syn keyword sqlFunction xp_real_write_file
350syn keyword sqlFunction xp_scanf
351syn keyword sqlFunction xp_sendmail
352syn keyword sqlFunction xp_sprintf
353syn keyword sqlFunction xp_startmail
354syn keyword sqlFunction xp_startsmtp
355syn keyword sqlFunction xp_stopmail
356syn keyword sqlFunction xp_stopsmtp
357syn keyword sqlFunction xp_write_file
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000358
359" http functions
Bram Moolenaar446cb832008-06-24 21:56:24 +0000360syn keyword sqlFunction http_header http_variable
361syn keyword sqlFunction next_http_header next_http_variable
362syn keyword sqlFunction sa_set_http_header sa_set_http_option
363syn keyword sqlFunction sa_http_variable_info sa_http_header_info
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000364
Bram Moolenaar5c736222010-01-06 20:54:52 +0100365" http functions 9.0.1
Bram Moolenaar446cb832008-06-24 21:56:24 +0000366syn keyword sqlFunction http_encode http_decode
367syn keyword sqlFunction html_encode html_decode
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000368
369" keywords
Bram Moolenaar5c736222010-01-06 20:54:52 +0100370syn keyword sqlKeyword absolute accent action active add address aes_decrypt
371syn keyword sqlKeyword after aggregate algorithm allow_dup_row allowed
372syn keyword sqlKeyword alter and ansi_substring any as append apply asc ascii ase
373syn keyword sqlKeyword assign at atan2 atomic attach attended audit authorization
Bram Moolenaar446cb832008-06-24 21:56:24 +0000374syn keyword sqlKeyword autoincrement autostop batch bcp before
Bram Moolenaar5c736222010-01-06 20:54:52 +0100375syn keyword sqlKeyword between bit_and bit_length bit_or bit_substr bit_xor
376syn keyword sqlKeyword blank blanks block
377syn keyword sqlKeyword both bottom unbounded break breaker bufferpool
Bram Moolenaar446cb832008-06-24 21:56:24 +0000378syn keyword sqlKeyword build bulk by byte bytes cache calibrate calibration
379syn keyword sqlKeyword cancel capability cascade cast
Bram Moolenaar5c736222010-01-06 20:54:52 +0100380syn keyword sqlKeyword catalog ceil changes char char_convert check checksum
Bram Moolenaar446cb832008-06-24 21:56:24 +0000381syn keyword sqlKeyword class classes client cmp
Bram Moolenaar5c736222010-01-06 20:54:52 +0100382syn keyword sqlKeyword cluster clustered collation
383syn keyword sqlKeyword column columns
Bram Moolenaar446cb832008-06-24 21:56:24 +0000384syn keyword sqlKeyword command comment committed comparisons
385syn keyword sqlKeyword compatible component compressed compute computes
Bram Moolenaar5c736222010-01-06 20:54:52 +0100386syn keyword sqlKeyword concat configuration confirm conflict connection
Bram Moolenaar446cb832008-06-24 21:56:24 +0000387syn keyword sqlKeyword console consolidate consolidated
Bram Moolenaar5c736222010-01-06 20:54:52 +0100388syn keyword sqlKeyword constraint constraints content continue
389syn keyword sqlKeyword convert coordinator copy count count_set_bits
390syn keyword sqlKeyword crc createtime cross cube cume_dist
Bram Moolenaar446cb832008-06-24 21:56:24 +0000391syn keyword sqlKeyword current cursor data data database
392syn keyword sqlKeyword current_timestamp current_user
Bram Moolenaar5c736222010-01-06 20:54:52 +0100393syn keyword sqlKeyword databases datatype dba dbfile
394syn keyword sqlKeyword dbspace dbspaces dbspacename debug decoupled
395syn keyword sqlKeyword decrypted default defaults default_dbspace deferred
396syn keyword sqlKeyword definer definition
Bram Moolenaar446cb832008-06-24 21:56:24 +0000397syn keyword sqlKeyword delay deleting delimited dependencies desc
398syn keyword sqlKeyword description detach deterministic directory
Bram Moolenaar5c736222010-01-06 20:54:52 +0100399syn keyword sqlKeyword disable disabled distinct do domain download duplicate
Bram Moolenaar446cb832008-06-24 21:56:24 +0000400syn keyword sqlKeyword dsetpass dttm dynamic each editproc ejb
Bram Moolenaar5c736222010-01-06 20:54:52 +0100401syn keyword sqlKeyword else elseif empty enable encapsulated encrypted end
402syn keyword sqlKeyword encoding endif engine environment erase error escape escapes event
403syn keyword sqlKeyword event_parameter every except exception exclude excluded exclusive exec
404syn keyword sqlKeyword existing exists expanded expiry express exprtype extended_property
Bram Moolenaar446cb832008-06-24 21:56:24 +0000405syn keyword sqlKeyword external externlogin factor failover false
Bram Moolenaar5c736222010-01-06 20:54:52 +0100406syn keyword sqlKeyword fastfirstrow fieldproc file files filler
407syn keyword sqlKeyword fillfactor finish first first_keyword first_value
408syn keyword sqlKeyword following force foreign format forxml forxml_sep fp frame
409syn keyword sqlKeyword freepage french fresh full function gb get_bit go global
410syn keyword sqlKeyword group handler hash having header hexadecimal
411syn keyword sqlKeyword hidden high history hg hng hold holdlock host
412syn keyword sqlKeyword hours http_body http_session_timeout id identified identity ignore
Bram Moolenaar446cb832008-06-24 21:56:24 +0000413syn keyword sqlKeyword ignore_dup_key ignore_dup_row immediate
Bram Moolenaar5c736222010-01-06 20:54:52 +0100414syn keyword sqlKeyword in inactiv inactive inactivity included incremental
415syn keyword sqlKeyword index index_enabled index_lparen indexonly info
Bram Moolenaar446cb832008-06-24 21:56:24 +0000416syn keyword sqlKeyword inline inner inout insensitive inserting
417syn keyword sqlKeyword instead integrated
Bram Moolenaar5c736222010-01-06 20:54:52 +0100418syn keyword sqlKeyword internal intersection into introduced invoker iq is isolation
419syn keyword sqlKeyword jar java java_location java_main_userid java_vm_options
Bram Moolenaar446cb832008-06-24 21:56:24 +0000420syn keyword sqlKeyword jconnect jdk join kb key keep kerberos language last
Bram Moolenaar5c736222010-01-06 20:54:52 +0100421syn keyword sqlKeyword last_keyword last_value lateral ld left len lf ln level like
422syn keyword sqlKeyword limit local location log
423syn keyword sqlKeyword logging login logscan long low lru main manual mark
424syn keyword sqlKeyword match matched materialized max maximum mb membership
425syn keyword sqlKeyword merge metadata methods minimum minutes mirror mode modify monitor move mru
426syn keyword sqlKeyword multiplex name named national native natural new next no
Bram Moolenaar446cb832008-06-24 21:56:24 +0000427syn keyword sqlKeyword noholdlock nolock nonclustered none not
Bram Moolenaar5c736222010-01-06 20:54:52 +0100428syn keyword sqlKeyword notify null nullable_constant nulls object oem_string of off offline
429syn keyword sqlKeyword old on online only openstring optimization optimizer option
Bram Moolenaar446cb832008-06-24 21:56:24 +0000430syn keyword sqlKeyword or order others out outer over
431syn keyword sqlKeyword package packetsize padding page pages
Bram Moolenaar5c736222010-01-06 20:54:52 +0100432syn keyword sqlKeyword paglock parallel part partial partition partitions partner password path
433syn keyword sqlKeyword pctfree plan policy populate port postfilter preceding precision
434syn keyword sqlKeyword prefetch prefilter prefix preserve preview primary
435syn keyword sqlKeyword prior priority priqty private privileges procedure profile
436syn keyword sqlKeyword property_is_cumulative property_is_numeric public publication publish publisher
437syn keyword sqlKeyword quiesce quote quotes range readclientfile readcommitted reader readfile readonly
Bram Moolenaar446cb832008-06-24 21:56:24 +0000438syn keyword sqlKeyword readpast readuncommitted readwrite rebuild
439syn keyword sqlKeyword received recompile recover recursive references
Bram Moolenaar5c736222010-01-06 20:54:52 +0100440syn keyword sqlKeyword referencing refresh regex regexp regexp_substr relative relocate
Bram Moolenaar446cb832008-06-24 21:56:24 +0000441syn keyword sqlKeyword rename repeatable repeatableread
Bram Moolenaar5c736222010-01-06 20:54:52 +0100442syn keyword sqlKeyword replicate request_timeout required rereceive resend reserve reset
Bram Moolenaar446cb832008-06-24 21:56:24 +0000443syn keyword sqlKeyword resizing resolve resource respect
444syn keyword sqlKeyword restrict result retain
Bram Moolenaar5c736222010-01-06 20:54:52 +0100445syn keyword sqlKeyword returns reverse right role
446syn keyword sqlKeyword rollup root row row_number rowlock rows save
447syn keyword sqlKeyword sa_index_hash sa_internal_fk_verify sa_internal_termbreak
448syn keyword sqlKeyword sa_order_preserving_hash sa_order_preserving_hash_big sa_order_preserving_hash_prefix
449syn keyword sqlKeyword schedule schema scope scripted scroll seconds secqty security
Bram Moolenaar446cb832008-06-24 21:56:24 +0000450syn keyword sqlKeyword send sensitive sent serializable
Bram Moolenaar5c736222010-01-06 20:54:52 +0100451syn keyword sqlKeyword server server session set_bit set_bits sets
Bram Moolenaar446cb832008-06-24 21:56:24 +0000452syn keyword sqlKeyword share simple since site size skip
Bram Moolenaar5c736222010-01-06 20:54:52 +0100453syn keyword sqlKeyword snapshot soapheader soap_header split some sorted_data
454syn keyword sqlKeyword sqlcode sqlid sqlflagger sqlstate sqrt square
455syn keyword sqlKeyword stacker stale statement statistics status stddev_pop stddev_samp
456syn keyword sqlKeyword stemmer stogroup stoplist store
457syn keyword sqlKeyword strip stripesizekb striping subpages subscribe subscription
458syn keyword sqlKeyword subtransaction suser_id suser_name synchronization
Bram Moolenaar446cb832008-06-24 21:56:24 +0000459syn keyword sqlKeyword syntax_error table tablock
Bram Moolenaar5c736222010-01-06 20:54:52 +0100460syn keyword sqlKeyword tablockx tb temp template temporary term then
461syn keyword sqlKeyword ties timezone to to_char to_nchar top traced_plan tracing
462syn keyword sqlKeyword transfer transaction transactional tries true
Bram Moolenaar446cb832008-06-24 21:56:24 +0000463syn keyword sqlKeyword tsequal type tune uncommitted unconditionally
Bram Moolenaar5c736222010-01-06 20:54:52 +0100464syn keyword sqlKeyword unenforced unicode unique union unistr unknown unlimited unload
465syn keyword sqlKeyword unpartition unquiesce updatetime updating updlock upgrade upload
466syn keyword sqlKeyword upper use user
Bram Moolenaar446cb832008-06-24 21:56:24 +0000467syn keyword sqlKeyword using utc utilities validproc
468syn keyword sqlKeyword value values varchar variable
Bram Moolenaar5c736222010-01-06 20:54:52 +0100469syn keyword sqlKeyword varying var_pop var_samp vcat verify versions view virtual wait
470syn keyword sqlKeyword warning wd web when where window with with_auto
Bram Moolenaar446cb832008-06-24 21:56:24 +0000471syn keyword sqlKeyword with_auto with_cube with_rollup without
Bram Moolenaar5c736222010-01-06 20:54:52 +0100472syn keyword sqlKeyword with_lparen within word work workload write writefile
473syn keyword sqlKeyword writeclientfile writer writers writeserver xlock zeros
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000474" XML function support
Bram Moolenaar5c736222010-01-06 20:54:52 +0100475syn keyword sqlFunction openxml xmlelement xmlforest xmlgen xmlconcat xmlagg
476syn keyword sqlFunction xmlattributes
Bram Moolenaar446cb832008-06-24 21:56:24 +0000477syn keyword sqlKeyword raw auto elements explicit
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000478" HTTP support
Bram Moolenaar5c736222010-01-06 20:54:52 +0100479syn keyword sqlKeyword authorization secure url service next_soap_header
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000480" HTTP 9.0.2 new procedure keywords
Bram Moolenaar446cb832008-06-24 21:56:24 +0000481syn keyword sqlKeyword namespace certificate clientport proxy
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000482" OLAP support 9.0.0
Bram Moolenaar5c736222010-01-06 20:54:52 +0100483syn keyword sqlKeyword covar_pop covar_samp corr regr_slope regr_intercept
Bram Moolenaar446cb832008-06-24 21:56:24 +0000484syn keyword sqlKeyword regr_count regr_r2 regr_avgx regr_avgy
485syn keyword sqlKeyword regr_sxx regr_syy regr_sxy
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000486
487" Alternate keywords
Bram Moolenaar446cb832008-06-24 21:56:24 +0000488syn keyword sqlKeyword character dec options proc reference
Bram Moolenaar5c736222010-01-06 20:54:52 +0100489syn keyword sqlKeyword subtrans tran syn keyword
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000490
491
Bram Moolenaar446cb832008-06-24 21:56:24 +0000492syn keyword sqlOperator in any some all between exists
Bram Moolenaar5c736222010-01-06 20:54:52 +0100493syn keyword sqlOperator like escape not is and or
Bram Moolenaar446cb832008-06-24 21:56:24 +0000494syn keyword sqlOperator intersect minus
495syn keyword sqlOperator prior distinct
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000496
497syn keyword sqlStatement allocate alter backup begin call case
498syn keyword sqlStatement checkpoint clear close commit configure connect
499syn keyword sqlStatement create deallocate declare delete describe
500syn keyword sqlStatement disconnect drop execute exit explain fetch
501syn keyword sqlStatement for forward from get goto grant help if include
502syn keyword sqlStatement input insert install leave load lock loop
503syn keyword sqlStatement message open output parameter parameters passthrough
504syn keyword sqlStatement prepare print put raiserror read readtext release
505syn keyword sqlStatement remote remove reorganize resignal restore resume
506syn keyword sqlStatement return revoke rollback savepoint select
507syn keyword sqlStatement set setuser signal start stop synchronize
508syn keyword sqlStatement system trigger truncate unload update
509syn keyword sqlStatement validate waitfor whenever while writetext
510
511
Bram Moolenaar446cb832008-06-24 21:56:24 +0000512syn keyword sqlType char long varchar text
Bram Moolenaar5c736222010-01-06 20:54:52 +0100513syn keyword sqlType bigint decimal double float int integer numeric
Bram Moolenaar446cb832008-06-24 21:56:24 +0000514syn keyword sqlType smallint tinyint real
515syn keyword sqlType money smallmoney
Bram Moolenaar5c736222010-01-06 20:54:52 +0100516syn keyword sqlType bit
517syn keyword sqlType date datetime smalldate time timestamp
Bram Moolenaar446cb832008-06-24 21:56:24 +0000518syn keyword sqlType binary image varbinary uniqueidentifier
519syn keyword sqlType xml unsigned
520" New types 10.0.0
521syn keyword sqlType varbit nchar nvarchar
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000522
Bram Moolenaar446cb832008-06-24 21:56:24 +0000523syn keyword sqlOption Allow_nulls_by_default
Bram Moolenaar5c736222010-01-06 20:54:52 +0100524syn keyword sqlOption Allow_read_client_file
525syn keyword sqlOption Allow_snapshot_isolation
526syn keyword sqlOption Allow_write_client_file
Bram Moolenaar446cb832008-06-24 21:56:24 +0000527syn keyword sqlOption Ansi_blanks
528syn keyword sqlOption Ansi_close_cursors_on_rollback
Bram Moolenaar446cb832008-06-24 21:56:24 +0000529syn keyword sqlOption Ansi_permissions
Bram Moolenaar5c736222010-01-06 20:54:52 +0100530syn keyword sqlOption Ansi_substring
Bram Moolenaar446cb832008-06-24 21:56:24 +0000531syn keyword sqlOption Ansi_update_constraints
532syn keyword sqlOption Ansinull
Bram Moolenaar446cb832008-06-24 21:56:24 +0000533syn keyword sqlOption Auditing
534syn keyword sqlOption Auditing_options
Bram Moolenaar446cb832008-06-24 21:56:24 +0000535syn keyword sqlOption Background_priority
Bram Moolenaar446cb832008-06-24 21:56:24 +0000536syn keyword sqlOption Blocking
537syn keyword sqlOption Blocking_timeout
538syn keyword sqlOption Chained
Bram Moolenaar446cb832008-06-24 21:56:24 +0000539syn keyword sqlOption Checkpoint_time
540syn keyword sqlOption Cis_option
541syn keyword sqlOption Cis_rowset_size
542syn keyword sqlOption Close_on_endtrans
Bram Moolenaar5c736222010-01-06 20:54:52 +0100543syn keyword sqlOption Collect_statistics_on_dml_updates
544syn keyword sqlOption Conn_auditing
Bram Moolenaar446cb832008-06-24 21:56:24 +0000545syn keyword sqlOption Connection_authentication
546syn keyword sqlOption Continue_after_raiserror
547syn keyword sqlOption Conversion_error
548syn keyword sqlOption Cooperative_commit_timeout
549syn keyword sqlOption Cooperative_commits
550syn keyword sqlOption Database_authentication
551syn keyword sqlOption Date_format
552syn keyword sqlOption Date_order
553syn keyword sqlOption Debug_messages
554syn keyword sqlOption Dedicated_task
Bram Moolenaar5c736222010-01-06 20:54:52 +0100555syn keyword sqlOption Default_dbspace
Bram Moolenaar446cb832008-06-24 21:56:24 +0000556syn keyword sqlOption Default_timestamp_increment
557syn keyword sqlOption Delayed_commit_timeout
558syn keyword sqlOption Delayed_commits
Bram Moolenaar446cb832008-06-24 21:56:24 +0000559syn keyword sqlOption Escape_character
560syn keyword sqlOption Exclude_operators
561syn keyword sqlOption Extended_join_syntax
Bram Moolenaar446cb832008-06-24 21:56:24 +0000562syn keyword sqlOption Fire_triggers
563syn keyword sqlOption First_day_of_week
Bram Moolenaar446cb832008-06-24 21:56:24 +0000564syn keyword sqlOption For_xml_null_treatment
565syn keyword sqlOption Force_view_creation
566syn keyword sqlOption Global_database_id
Bram Moolenaar5c736222010-01-06 20:54:52 +0100567syn keyword sqlOption Http_session_timeout
Bram Moolenaar446cb832008-06-24 21:56:24 +0000568syn keyword sqlOption Integrated_server_name
569syn keyword sqlOption Isolation_level
Bram Moolenaar5c736222010-01-06 20:54:52 +0100570syn keyword sqlOption Java_location
571syn keyword sqlOption Java_main_userid
572syn keyword sqlOption Java_vm_options
Bram Moolenaar446cb832008-06-24 21:56:24 +0000573syn keyword sqlOption Lock_rejected_rows
574syn keyword sqlOption Log_deadlocks
Bram Moolenaar446cb832008-06-24 21:56:24 +0000575syn keyword sqlOption Login_mode
576syn keyword sqlOption Login_procedure
Bram Moolenaar5c736222010-01-06 20:54:52 +0100577syn keyword sqlOption Materialized_view_optimization
578syn keyword sqlOption Max_client_statements_cached
Bram Moolenaar446cb832008-06-24 21:56:24 +0000579syn keyword sqlOption Max_cursor_count
580syn keyword sqlOption Max_hash_size
581syn keyword sqlOption Max_plans_cached
Bram Moolenaar5c736222010-01-06 20:54:52 +0100582syn keyword sqlOption Max_priority
583syn keyword sqlOption Max_query_tasks
Bram Moolenaar446cb832008-06-24 21:56:24 +0000584syn keyword sqlOption Max_recursive_iterations
585syn keyword sqlOption Max_statement_count
Bram Moolenaar5c736222010-01-06 20:54:52 +0100586syn keyword sqlOption Max_temp_space
Bram Moolenaar446cb832008-06-24 21:56:24 +0000587syn keyword sqlOption Min_password_length
588syn keyword sqlOption Nearest_century
589syn keyword sqlOption Non_keywords
Bram Moolenaar5c736222010-01-06 20:54:52 +0100590syn keyword sqlOption Odbc_describe_binary_as_varbinary
591syn keyword sqlOption Odbc_distinguish_char_and_varchar
592syn keyword sqlOption Oem_string
593syn keyword sqlOption On_charset_conversion_failure
Bram Moolenaar446cb832008-06-24 21:56:24 +0000594syn keyword sqlOption On_tsql_error
Bram Moolenaar446cb832008-06-24 21:56:24 +0000595syn keyword sqlOption Optimization_goal
596syn keyword sqlOption Optimization_level
Bram Moolenaar446cb832008-06-24 21:56:24 +0000597syn keyword sqlOption Optimization_workload
Bram Moolenaar446cb832008-06-24 21:56:24 +0000598syn keyword sqlOption Pinned_cursor_percent_of_cache
Bram Moolenaar5c736222010-01-06 20:54:52 +0100599syn keyword sqlOption Post_login_procedure
Bram Moolenaar446cb832008-06-24 21:56:24 +0000600syn keyword sqlOption Precision
601syn keyword sqlOption Prefetch
602syn keyword sqlOption Preserve_source_format
603syn keyword sqlOption Prevent_article_pkey_update
Bram Moolenaar5c736222010-01-06 20:54:52 +0100604syn keyword sqlOption Priority
605syn keyword sqlOption Query_mem_timeout
Bram Moolenaar446cb832008-06-24 21:56:24 +0000606syn keyword sqlOption Quoted_identifier
607syn keyword sqlOption Read_past_deleted
608syn keyword sqlOption Recovery_time
609syn keyword sqlOption Remote_idle_timeout
610syn keyword sqlOption Replicate_all
Bram Moolenaar5c736222010-01-06 20:54:52 +0100611syn keyword sqlOption Request_timeout
Bram Moolenaar446cb832008-06-24 21:56:24 +0000612syn keyword sqlOption Return_date_time_as_string
Bram Moolenaar446cb832008-06-24 21:56:24 +0000613syn keyword sqlOption Rollback_on_deadlock
614syn keyword sqlOption Row_counts
Bram Moolenaar446cb832008-06-24 21:56:24 +0000615syn keyword sqlOption Scale
Bram Moolenaar5c736222010-01-06 20:54:52 +0100616syn keyword sqlOption Secure_feature_key
617syn keyword sqlOption Sort_collation
618syn keyword sqlOption Sql_flagger_error_level
619syn keyword sqlOption Sql_flagger_warning_level
Bram Moolenaar446cb832008-06-24 21:56:24 +0000620syn keyword sqlOption String_rtruncation
Bram Moolenaar446cb832008-06-24 21:56:24 +0000621syn keyword sqlOption Subsume_row_locks
Bram Moolenaar5c736222010-01-06 20:54:52 +0100622syn keyword sqlOption Suppress_tds_debugging
623syn keyword sqlOption Synchronize_mirror_on_commit
624syn keyword sqlOption Tds_empty_string_is_null
Bram Moolenaar446cb832008-06-24 21:56:24 +0000625syn keyword sqlOption Temp_space_limit_check
Bram Moolenaar446cb832008-06-24 21:56:24 +0000626syn keyword sqlOption Time_format
627syn keyword sqlOption Time_zone_adjustment
628syn keyword sqlOption Timestamp_format
Bram Moolenaar446cb832008-06-24 21:56:24 +0000629syn keyword sqlOption Truncate_timestamp_values
Bram Moolenaar5c736222010-01-06 20:54:52 +0100630syn keyword sqlOption Tsql_outer_joins
Bram Moolenaar446cb832008-06-24 21:56:24 +0000631syn keyword sqlOption Tsql_variables
Bram Moolenaar5c736222010-01-06 20:54:52 +0100632syn keyword sqlOption Updatable_statement_isolation
Bram Moolenaar446cb832008-06-24 21:56:24 +0000633syn keyword sqlOption Update_statistics
Bram Moolenaar5c736222010-01-06 20:54:52 +0100634syn keyword sqlOption Upgrade_database_capability
Bram Moolenaar446cb832008-06-24 21:56:24 +0000635syn keyword sqlOption User_estimates
Bram Moolenaar5c736222010-01-06 20:54:52 +0100636syn keyword sqlOption Verify_password_function
Bram Moolenaar446cb832008-06-24 21:56:24 +0000637syn keyword sqlOption Wait_for_commit
Bram Moolenaar5c736222010-01-06 20:54:52 +0100638syn keyword sqlOption Webservice_namespace_host
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000639
640" Strings and characters:
641syn region sqlString start=+"+ end=+"+ contains=@Spell
642syn region sqlString start=+'+ end=+'+ contains=@Spell
643
644" Numbers:
645syn match sqlNumber "-\=\<\d*\.\=[0-9_]\>"
646
647" Comments:
648syn region sqlDashComment start=/--/ end=/$/ contains=@Spell
649syn region sqlSlashComment start=/\/\// end=/$/ contains=@Spell
650syn region sqlMultiComment start="/\*" end="\*/" contains=sqlMultiComment,@Spell
651syn cluster sqlComment contains=sqlDashComment,sqlSlashComment,sqlMultiComment,@Spell
652syn sync ccomment sqlComment
653syn sync ccomment sqlDashComment
654syn sync ccomment sqlSlashComment
655
656" Define the default highlighting.
657" For version 5.7 and earlier: only when not done already
658" For version 5.8 and later: only when an item doesn't have highlighting yet
659if version >= 508 || !exists("did_sql_syn_inits")
660 if version < 508
661 let did_sql_syn_inits = 1
662 command -nargs=+ HiLink hi link <args>
663 else
664 command -nargs=+ HiLink hi link <args>
665 endif
666
667 HiLink sqlDashComment Comment
668 HiLink sqlSlashComment Comment
669 HiLink sqlMultiComment Comment
670 HiLink sqlNumber Number
671 HiLink sqlOperator Operator
672 HiLink sqlSpecial Special
673 HiLink sqlKeyword Keyword
674 HiLink sqlStatement Statement
675 HiLink sqlString String
676 HiLink sqlType Type
677 HiLink sqlFunction Function
678 HiLink sqlOption PreProc
679
680 delcommand HiLink
681endif
682
683let b:current_syntax = "sqlanywhere"
684
Bram Moolenaar446cb832008-06-24 21:56:24 +0000685" vim:sw=4: