Gitiles
Code Review Sign In
gerrit.omnirom.org / android_external_vim / 8f3f58f2c361f1b7241128d9821f88d8a30aa066 / . / runtime / syntax / sqlanywhere.vim
blob: 81fa060f4a2b42def30277ee2976a074b871c732 [file] [log] [blame]
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]1
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]2" Vim syntax file
3" Language: SQL, Adaptive Server Anywhere
4" Maintainer: David Fishburn <fishburn at ianywhere dot com>
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]5" Last Change: Tue 29 Jan 2008 12:54:19 PM Eastern Standard Time
6" Version: 10.0.1
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]7
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]8" Description: Updated to Adaptive Server Anywhere 10.0.1
9" 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 +0000[diff] [blame]12"
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 +0000[diff] [blame]28syn 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 +0000[diff] [blame]55
56" 9.0.1 functions
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]57syn keyword sqlFunction acos asin atan atn2 cast ceiling convert cos cot
58syn keyword sqlFunction char_length coalesce dateformat datetime degrees exp
59syn keyword sqlFunction floor getdate insertstr
60syn keyword sqlFunction log log10 lower mod pi power
61syn keyword sqlFunction property radians replicate round sign sin
62syn 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 +0000[diff] [blame]65
66" string functions
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]67syn keyword sqlFunction ascii char left ltrim repeat
68syn keyword sqlFunction space right rtrim trim lcase ucase
69syn keyword sqlFunction locate charindex patindex replace
70syn keyword sqlFunction errormsg csconvert
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]71
72" property functions
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]73syn keyword sqlFunction db_id db_name property_name
74syn keyword sqlFunction property_description property_number
75syn keyword sqlFunction next_connection next_database property
76syn keyword sqlFunction connection_property db_property db_extended_property
77syn keyword sqlFunction event_parmeter event_condition event_condition_name
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]78
79" sa_ procedures
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]80syn keyword sqlFunction sa_add_index_consultant_analysis
81syn keyword sqlFunction sa_add_workload_query
82syn keyword sqlFunction sa_app_deregister
83syn keyword sqlFunction sa_app_get_infoStr
84syn keyword sqlFunction sa_app_get_status
85syn keyword sqlFunction sa_app_register
86syn keyword sqlFunction sa_app_registration_unlock
87syn keyword sqlFunction sa_app_set_infoStr
88syn keyword sqlFunction sa_audit_string
89syn keyword sqlFunction sa_check_commit
90syn keyword sqlFunction sa_checkpoint_execute
91syn keyword sqlFunction sa_conn_activity
92syn keyword sqlFunction sa_conn_compression_info
93syn keyword sqlFunction sa_conn_deregister
94syn keyword sqlFunction sa_conn_info
95syn keyword sqlFunction sa_conn_properties
96syn keyword sqlFunction sa_conn_properties_by_conn
97syn keyword sqlFunction sa_conn_properties_by_name
98syn keyword sqlFunction sa_conn_register
99syn keyword sqlFunction sa_conn_set_status
100syn keyword sqlFunction sa_create_analysis_from_query
101syn keyword sqlFunction sa_db_info
102syn keyword sqlFunction sa_db_properties
103syn keyword sqlFunction sa_disable_auditing_type
104syn keyword sqlFunction sa_disable_index
105syn keyword sqlFunction sa_disk_free_space
106syn keyword sqlFunction sa_enable_auditing_type
107syn keyword sqlFunction sa_enable_index
108syn keyword sqlFunction sa_end_forward_to
109syn keyword sqlFunction sa_eng_properties
110syn keyword sqlFunction sa_event_schedules
111syn keyword sqlFunction sa_exec_script
112syn keyword sqlFunction sa_flush_cache
113syn keyword sqlFunction sa_flush_statistics
114syn keyword sqlFunction sa_forward_to
115syn keyword sqlFunction sa_get_dtt
116syn keyword sqlFunction sa_get_histogram
117syn keyword sqlFunction sa_get_request_profile
118syn keyword sqlFunction sa_get_request_profile_sub
119syn keyword sqlFunction sa_get_request_times
120syn keyword sqlFunction sa_get_server_messages
121syn keyword sqlFunction sa_get_simulated_scale_factors
122syn keyword sqlFunction sa_get_workload_capture_status
123syn keyword sqlFunction sa_index_density
124syn keyword sqlFunction sa_index_levels
125syn keyword sqlFunction sa_index_statistics
126syn keyword sqlFunction sa_internal_alter_index_ability
127syn keyword sqlFunction sa_internal_create_analysis_from_query
128syn keyword sqlFunction sa_internal_disk_free_space
129syn keyword sqlFunction sa_internal_get_dtt
130syn keyword sqlFunction sa_internal_get_histogram
131syn keyword sqlFunction sa_internal_get_request_times
132syn keyword sqlFunction sa_internal_get_simulated_scale_factors
133syn keyword sqlFunction sa_internal_get_workload_capture_status
134syn keyword sqlFunction sa_internal_index_density
135syn keyword sqlFunction sa_internal_index_levels
136syn keyword sqlFunction sa_internal_index_statistics
137syn keyword sqlFunction sa_internal_java_loaded_classes
138syn keyword sqlFunction sa_internal_locks
139syn keyword sqlFunction sa_internal_pause_workload_capture
140syn keyword sqlFunction sa_internal_procedure_profile
141syn keyword sqlFunction sa_internal_procedure_profile_summary
142syn keyword sqlFunction sa_internal_read_backup_history
143syn keyword sqlFunction sa_internal_recommend_indexes
144syn keyword sqlFunction sa_internal_reset_identity
145syn keyword sqlFunction sa_internal_resume_workload_capture
146syn keyword sqlFunction sa_internal_start_workload_capture
147syn keyword sqlFunction sa_internal_stop_index_consultant
148syn keyword sqlFunction sa_internal_stop_workload_capture
149syn keyword sqlFunction sa_internal_table_fragmentation
150syn keyword sqlFunction sa_internal_table_page_usage
151syn keyword sqlFunction sa_internal_table_stats
152syn keyword sqlFunction sa_internal_virtual_sysindex
153syn keyword sqlFunction sa_internal_virtual_sysixcol
154syn keyword sqlFunction sa_java_loaded_classes
155syn keyword sqlFunction sa_jdk_version
156syn keyword sqlFunction sa_locks
157syn keyword sqlFunction sa_make_object
158syn keyword sqlFunction sa_pause_workload_capture
159syn keyword sqlFunction sa_proc_debug_attach_to_connection
160syn keyword sqlFunction sa_proc_debug_connect
161syn keyword sqlFunction sa_proc_debug_detach_from_connection
162syn keyword sqlFunction sa_proc_debug_disconnect
163syn keyword sqlFunction sa_proc_debug_get_connection_name
164syn keyword sqlFunction sa_proc_debug_release_connection
165syn keyword sqlFunction sa_proc_debug_request
166syn keyword sqlFunction sa_proc_debug_version
167syn keyword sqlFunction sa_proc_debug_wait_for_connection
168syn keyword sqlFunction sa_procedure_profile
169syn keyword sqlFunction sa_procedure_profile_summary
170syn keyword sqlFunction sa_read_backup_history
171syn keyword sqlFunction sa_recommend_indexes
172syn keyword sqlFunction sa_recompile_views
173syn keyword sqlFunction sa_remove_index_consultant_analysis
174syn keyword sqlFunction sa_remove_index_consultant_workload
175syn keyword sqlFunction sa_reset_identity
176syn keyword sqlFunction sa_resume_workload_capture
177syn keyword sqlFunction sa_server_option
178syn keyword sqlFunction sa_set_simulated_scale_factor
179syn keyword sqlFunction sa_setremoteuser
180syn keyword sqlFunction sa_setsubscription
181syn keyword sqlFunction sa_start_recording_commits
182syn keyword sqlFunction sa_start_workload_capture
183syn keyword sqlFunction sa_statement_text
184syn keyword sqlFunction sa_stop_index_consultant
185syn keyword sqlFunction sa_stop_recording_commits
186syn keyword sqlFunction sa_stop_workload_capture
187syn keyword sqlFunction sa_sync
188syn keyword sqlFunction sa_sync_sub
189syn keyword sqlFunction sa_table_fragmentation
190syn keyword sqlFunction sa_table_page_usage
191syn keyword sqlFunction sa_table_stats
192syn keyword sqlFunction sa_update_index_consultant_workload
193syn keyword sqlFunction sa_validate
194syn keyword sqlFunction sa_virtual_sysindex
195syn keyword sqlFunction sa_virtual_sysixcol
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]196
197" sp_ procedures
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]198syn keyword sqlFunction sp_addalias
199syn keyword sqlFunction sp_addauditrecord
200syn keyword sqlFunction sp_adddumpdevice
201syn keyword sqlFunction sp_addgroup
202syn keyword sqlFunction sp_addlanguage
203syn keyword sqlFunction sp_addlogin
204syn keyword sqlFunction sp_addmessage
205syn keyword sqlFunction sp_addremotelogin
206syn keyword sqlFunction sp_addsegment
207syn keyword sqlFunction sp_addserver
208syn keyword sqlFunction sp_addthreshold
209syn keyword sqlFunction sp_addtype
210syn keyword sqlFunction sp_adduser
211syn keyword sqlFunction sp_auditdatabase
212syn keyword sqlFunction sp_auditlogin
213syn keyword sqlFunction sp_auditobject
214syn keyword sqlFunction sp_auditoption
215syn keyword sqlFunction sp_auditsproc
216syn keyword sqlFunction sp_bindefault
217syn keyword sqlFunction sp_bindmsg
218syn keyword sqlFunction sp_bindrule
219syn keyword sqlFunction sp_changedbowner
220syn keyword sqlFunction sp_changegroup
221syn keyword sqlFunction sp_checknames
222syn keyword sqlFunction sp_checkperms
223syn keyword sqlFunction sp_checkreswords
224syn keyword sqlFunction sp_clearstats
225syn keyword sqlFunction sp_column_privileges
226syn keyword sqlFunction sp_columns
227syn keyword sqlFunction sp_commonkey
228syn keyword sqlFunction sp_configure
229syn keyword sqlFunction sp_cursorinfo
230syn keyword sqlFunction sp_databases
231syn keyword sqlFunction sp_datatype_info
232syn keyword sqlFunction sp_dboption
233syn keyword sqlFunction sp_dbremap
234syn keyword sqlFunction sp_depends
235syn keyword sqlFunction sp_diskdefault
236syn keyword sqlFunction sp_displaylogin
237syn keyword sqlFunction sp_dropalias
238syn keyword sqlFunction sp_dropdevice
239syn keyword sqlFunction sp_dropgroup
240syn keyword sqlFunction sp_dropkey
241syn keyword sqlFunction sp_droplanguage
242syn keyword sqlFunction sp_droplogin
243syn keyword sqlFunction sp_dropmessage
244syn keyword sqlFunction sp_dropremotelogin
245syn keyword sqlFunction sp_dropsegment
246syn keyword sqlFunction sp_dropserver
247syn keyword sqlFunction sp_dropthreshold
248syn keyword sqlFunction sp_droptype
249syn keyword sqlFunction sp_dropuser
250syn keyword sqlFunction sp_estspace
251syn keyword sqlFunction sp_extendsegment
252syn keyword sqlFunction sp_fkeys
253syn keyword sqlFunction sp_foreignkey
254syn keyword sqlFunction sp_getmessage
255syn keyword sqlFunction sp_help
256syn keyword sqlFunction sp_helpconstraint
257syn keyword sqlFunction sp_helpdb
258syn keyword sqlFunction sp_helpdevice
259syn keyword sqlFunction sp_helpgroup
260syn keyword sqlFunction sp_helpindex
261syn keyword sqlFunction sp_helpjoins
262syn keyword sqlFunction sp_helpkey
263syn keyword sqlFunction sp_helplanguage
264syn keyword sqlFunction sp_helplog
265syn keyword sqlFunction sp_helpprotect
266syn keyword sqlFunction sp_helpremotelogin
267syn keyword sqlFunction sp_helpsegment
268syn keyword sqlFunction sp_helpserver
269syn keyword sqlFunction sp_helpsort
270syn keyword sqlFunction sp_helptext
271syn keyword sqlFunction sp_helpthreshold
272syn keyword sqlFunction sp_helpuser
273syn keyword sqlFunction sp_indsuspect
274syn keyword sqlFunction sp_lock
275syn keyword sqlFunction sp_locklogin
276syn keyword sqlFunction sp_logdevice
277syn keyword sqlFunction sp_login_environment
278syn keyword sqlFunction sp_modifylogin
279syn keyword sqlFunction sp_modifythreshold
280syn keyword sqlFunction sp_monitor
281syn keyword sqlFunction sp_password
282syn keyword sqlFunction sp_pkeys
283syn keyword sqlFunction sp_placeobject
284syn keyword sqlFunction sp_primarykey
285syn keyword sqlFunction sp_procxmode
286syn keyword sqlFunction sp_recompile
287syn keyword sqlFunction sp_remap
288syn keyword sqlFunction sp_remote_columns
289syn keyword sqlFunction sp_remote_exported_keys
290syn keyword sqlFunction sp_remote_imported_keys
291syn keyword sqlFunction sp_remote_pcols
292syn keyword sqlFunction sp_remote_primary_keys
293syn keyword sqlFunction sp_remote_procedures
294syn keyword sqlFunction sp_remote_tables
295syn keyword sqlFunction sp_remoteoption
296syn keyword sqlFunction sp_rename
297syn keyword sqlFunction sp_renamedb
298syn keyword sqlFunction sp_reportstats
299syn keyword sqlFunction sp_reset_tsql_environment
300syn keyword sqlFunction sp_role
301syn keyword sqlFunction sp_server_info
302syn keyword sqlFunction sp_servercaps
303syn keyword sqlFunction sp_serverinfo
304syn keyword sqlFunction sp_serveroption
305syn keyword sqlFunction sp_setlangalias
306syn keyword sqlFunction sp_setreplicate
307syn keyword sqlFunction sp_setrepproc
308syn keyword sqlFunction sp_setreptable
309syn keyword sqlFunction sp_spaceused
310syn keyword sqlFunction sp_special_columns
311syn keyword sqlFunction sp_sproc_columns
312syn keyword sqlFunction sp_statistics
313syn keyword sqlFunction sp_stored_procedures
314syn keyword sqlFunction sp_syntax
315syn keyword sqlFunction sp_table_privileges
316syn keyword sqlFunction sp_tables
317syn keyword sqlFunction sp_tsql_environment
318syn keyword sqlFunction sp_tsql_feature_not_supported
319syn keyword sqlFunction sp_unbindefault
320syn keyword sqlFunction sp_unbindmsg
321syn keyword sqlFunction sp_unbindrule
322syn keyword sqlFunction sp_volchanged
323syn keyword sqlFunction sp_who
324syn keyword sqlFunction xp_scanf
325syn keyword sqlFunction xp_sprintf
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]326
327" server functions
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]328syn keyword sqlFunction col_length
329syn keyword sqlFunction col_name
330syn keyword sqlFunction index_col
331syn keyword sqlFunction object_id
332syn keyword sqlFunction object_name
333syn keyword sqlFunction proc_role
334syn keyword sqlFunction show_role
335syn keyword sqlFunction xp_cmdshell
336syn keyword sqlFunction xp_msver
337syn keyword sqlFunction xp_read_file
338syn keyword sqlFunction xp_real_cmdshell
339syn keyword sqlFunction xp_real_read_file
340syn keyword sqlFunction xp_real_sendmail
341syn keyword sqlFunction xp_real_startmail
342syn keyword sqlFunction xp_real_startsmtp
343syn keyword sqlFunction xp_real_stopmail
344syn keyword sqlFunction xp_real_stopsmtp
345syn keyword sqlFunction xp_real_write_file
346syn keyword sqlFunction xp_scanf
347syn keyword sqlFunction xp_sendmail
348syn keyword sqlFunction xp_sprintf
349syn keyword sqlFunction xp_startmail
350syn keyword sqlFunction xp_startsmtp
351syn keyword sqlFunction xp_stopmail
352syn keyword sqlFunction xp_stopsmtp
353syn keyword sqlFunction xp_write_file
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]354
355" http functions
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]356syn keyword sqlFunction http_header http_variable
357syn keyword sqlFunction next_http_header next_http_variable
358syn keyword sqlFunction sa_set_http_header sa_set_http_option
359syn keyword sqlFunction sa_http_variable_info sa_http_header_info
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]360
361" http functions 9.0.1
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]362syn keyword sqlFunction http_encode http_decode
363syn keyword sqlFunction html_encode html_decode
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]364
365" keywords
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]366syn keyword sqlKeyword absolute accent action activ add address after
367syn keyword sqlKeyword algorithm allow_dup_row
368syn keyword sqlKeyword alter and any as append asc ascii ase at atomic
369syn keyword sqlKeyword attach attended audit authorization
370syn keyword sqlKeyword autoincrement autostop batch bcp before
371syn keyword sqlKeyword between blank blanks block
372syn keyword sqlKeyword both bottom unbounded break bufferpool
373syn keyword sqlKeyword build bulk by byte bytes cache calibrate calibration
374syn keyword sqlKeyword cancel capability cascade cast
375syn keyword sqlKeyword catalog changes char char_convert check checksum
376syn keyword sqlKeyword class classes client cmp
377syn keyword sqlKeyword cluster clustered collation column columns
378syn keyword sqlKeyword command comment committed comparisons
379syn keyword sqlKeyword compatible component compressed compute computes
380syn keyword sqlKeyword concat confirm conflict connection
381syn keyword sqlKeyword console consolidate consolidated
382syn keyword sqlKeyword constraint constraints continue
383syn keyword sqlKeyword convert copy count crc cross cube
384syn keyword sqlKeyword current cursor data data database
385syn keyword sqlKeyword current_timestamp current_user
386syn keyword sqlKeyword datatype dba dbfile
387syn keyword sqlKeyword dbspace dbspacename debug decoupled
388syn keyword sqlKeyword decrypted default defaults deferred definition
389syn keyword sqlKeyword delay deleting delimited dependencies desc
390syn keyword sqlKeyword description detach deterministic directory
391syn keyword sqlKeyword disable disabled distinct do domain download
392syn keyword sqlKeyword dsetpass dttm dynamic each editproc ejb
393syn keyword sqlKeyword else elseif enable encapsulated encrypted end
394syn keyword sqlKeyword encoding endif engine erase error escape escapes event
395syn keyword sqlKeyword every except exception exclude exclusive exec
396syn keyword sqlKeyword existing exists expanded express
397syn keyword sqlKeyword external externlogin factor failover false
398syn keyword sqlKeyword fastfirstrow fieldproc file filler
399syn keyword sqlKeyword fillfactor finish first first_keyword
400syn keyword sqlKeyword following force foreign format
401syn keyword sqlKeyword freepage french fresh full function go global
402syn keyword sqlKeyword group handler hash having header hexadecimal
403syn keyword sqlKeyword hidden high history hold holdlock
404syn keyword sqlKeyword hours id identified identity ignore
405syn keyword sqlKeyword ignore_dup_key ignore_dup_row immediate
406syn keyword sqlKeyword in inactive inactivity incremental index info
407syn keyword sqlKeyword inline inner inout insensitive inserting
408syn keyword sqlKeyword instead integrated
409syn keyword sqlKeyword internal into introduced iq is isolation jar java
410syn keyword sqlKeyword jconnect jdk join kb key keep kerberos language last
411syn keyword sqlKeyword last_keyword lateral left level like
412syn keyword sqlKeyword limit local location log
413syn keyword sqlKeyword logging login logscan long low lru main
414syn keyword sqlKeyword match materialized max maximum membership
415syn keyword sqlKeyword minutes mirror mode modify monitor mru
416syn keyword sqlKeyword name named national native natural new next no
417syn keyword sqlKeyword noholdlock nolock nonclustered none not
418syn keyword sqlKeyword notify null nulls of off old on
419syn keyword sqlKeyword only optimization optimizer option
420syn keyword sqlKeyword or order others out outer over
421syn keyword sqlKeyword package packetsize padding page pages
422syn keyword sqlKeyword paglock parallel part partition partner password path
423syn keyword sqlKeyword pctfree plan preceding precision prefetch prefix
424syn keyword sqlKeyword preserve preview primary
425syn keyword sqlKeyword prior priqty private privileges procedure profile
426syn keyword sqlKeyword public publication publish publisher
427syn keyword sqlKeyword quote quotes range readcommitted readonly
428syn keyword sqlKeyword readpast readuncommitted readwrite rebuild
429syn keyword sqlKeyword received recompile recover recursive references
430syn keyword sqlKeyword referencing refresh relative relocate
431syn keyword sqlKeyword rename repeatable repeatableread
432syn keyword sqlKeyword replicate rereceive resend reserve reset
433syn keyword sqlKeyword resizing resolve resource respect
434syn keyword sqlKeyword restrict result retain
435syn keyword sqlKeyword returns right
436syn keyword sqlKeyword rollup root row rowlock rows save
437syn keyword sqlKeyword schedule schema scripted scroll seconds secqty
438syn keyword sqlKeyword send sensitive sent serializable
439syn keyword sqlKeyword server server session sets
440syn keyword sqlKeyword share simple since site size skip
441syn keyword sqlKeyword snapshot soapheader some sorted_data
442syn keyword sqlKeyword sqlcode sqlid sqlstate stacker stale statement
443syn keyword sqlKeyword statistics status stogroup store
444syn keyword sqlKeyword strip subpages subscribe subscription
445syn keyword sqlKeyword subtransaction synchronization
446syn keyword sqlKeyword syntax_error table tablock
447syn keyword sqlKeyword tablockx tb temp template temporary then
448syn keyword sqlKeyword ties timezone to top tracing
449syn keyword sqlKeyword transaction transactional tries true
450syn keyword sqlKeyword tsequal type tune uncommitted unconditionally
451syn keyword sqlKeyword unenforced unique union unknown unload
452syn keyword sqlKeyword updating updlock upgrade upload use user
453syn keyword sqlKeyword using utc utilities validproc
454syn keyword sqlKeyword value values varchar variable
455syn keyword sqlKeyword varying vcat verify view virtual wait
456syn keyword sqlKeyword warning web when where window with with_auto
457syn keyword sqlKeyword with_auto with_cube with_rollup without
458syn keyword sqlKeyword with_lparen within word work workload writefile
459syn keyword sqlKeyword writers writeserver xlock zeros
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]460" XML function support
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]461syn keyword sqlFunction openxml xmlelement xmlforest xmlgen xmlconcat xmlagg
462syn keyword sqlFunction xmlattributes
463syn keyword sqlKeyword raw auto elements explicit
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]464" HTTP support
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]465syn keyword sqlKeyword authorization secure url service
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]466" HTTP 9.0.2 new procedure keywords
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]467syn keyword sqlKeyword namespace certificate clientport proxy
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]468" OLAP support 9.0.0
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]469syn keyword sqlKeyword covar_pop covar_samp corr regr_slope regr_intercept
470syn keyword sqlKeyword regr_count regr_r2 regr_avgx regr_avgy
471syn keyword sqlKeyword regr_sxx regr_syy regr_sxy
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]472
473" Alternate keywords
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]474syn keyword sqlKeyword character dec options proc reference
475syn keyword sqlKeyword subtrans tran syn keyword
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]476
477
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]478syn keyword sqlOperator in any some all between exists
479syn keyword sqlOperator like escape not is and or
480syn keyword sqlOperator intersect minus
481syn keyword sqlOperator prior distinct
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]482
483syn keyword sqlStatement allocate alter backup begin call case
484syn keyword sqlStatement checkpoint clear close commit configure connect
485syn keyword sqlStatement create deallocate declare delete describe
486syn keyword sqlStatement disconnect drop execute exit explain fetch
487syn keyword sqlStatement for forward from get goto grant help if include
488syn keyword sqlStatement input insert install leave load lock loop
489syn keyword sqlStatement message open output parameter parameters passthrough
490syn keyword sqlStatement prepare print put raiserror read readtext release
491syn keyword sqlStatement remote remove reorganize resignal restore resume
492syn keyword sqlStatement return revoke rollback savepoint select
493syn keyword sqlStatement set setuser signal start stop synchronize
494syn keyword sqlStatement system trigger truncate unload update
495syn keyword sqlStatement validate waitfor whenever while writetext
496
497
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]498syn keyword sqlType char long varchar text
499syn keyword sqlType bigint decimal double float int integer numeric
500syn keyword sqlType smallint tinyint real
501syn keyword sqlType money smallmoney
502syn keyword sqlType bit
503syn keyword sqlType date datetime smalldate time timestamp
504syn keyword sqlType binary image varbinary uniqueidentifier
505syn keyword sqlType xml unsigned
506" New types 10.0.0
507syn keyword sqlType varbit nchar nvarchar
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]508
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]509syn keyword sqlOption Allow_nulls_by_default
510syn keyword sqlOption Ansi_blanks
511syn keyword sqlOption Ansi_close_cursors_on_rollback
512syn keyword sqlOption Ansi_integer_overflow
513syn keyword sqlOption Ansi_permissions
514syn keyword sqlOption Ansi_update_constraints
515syn keyword sqlOption Ansinull
516syn keyword sqlOption Assume_distinct_servers
517syn keyword sqlOption Auditing
518syn keyword sqlOption Auditing_options
519syn keyword sqlOption Auto_commit
520syn keyword sqlOption Auto_refetch
521syn keyword sqlOption Automatic_timestamp
522syn keyword sqlOption Background_priority
523syn keyword sqlOption Bell
524syn keyword sqlOption Blob_threshold
525syn keyword sqlOption Blocking
526syn keyword sqlOption Blocking_timeout
527syn keyword sqlOption Chained
528syn keyword sqlOption Char_OEM_Translation
529syn keyword sqlOption Checkpoint_time
530syn keyword sqlOption Cis_option
531syn keyword sqlOption Cis_rowset_size
532syn keyword sqlOption Close_on_endtrans
533syn keyword sqlOption Command_delimiter
534syn keyword sqlOption Commit_on_exit
535syn keyword sqlOption Compression
536syn keyword sqlOption Connection_authentication
537syn keyword sqlOption Continue_after_raiserror
538syn keyword sqlOption Conversion_error
539syn keyword sqlOption Cooperative_commit_timeout
540syn keyword sqlOption Cooperative_commits
541syn keyword sqlOption Database_authentication
542syn keyword sqlOption Date_format
543syn keyword sqlOption Date_order
544syn keyword sqlOption Debug_messages
545syn keyword sqlOption Dedicated_task
546syn keyword sqlOption Default_timestamp_increment
547syn keyword sqlOption Delayed_commit_timeout
548syn keyword sqlOption Delayed_commits
549syn keyword sqlOption Delete_old_logs
550syn keyword sqlOption Describe_Java_Format
551syn keyword sqlOption Divide_by_zero_error
552syn keyword sqlOption Echo
553syn keyword sqlOption Escape_character
554syn keyword sqlOption Exclude_operators
555syn keyword sqlOption Extended_join_syntax
556syn keyword sqlOption External_remote_options
557syn keyword sqlOption Fire_triggers
558syn keyword sqlOption First_day_of_week
559syn keyword sqlOption Float_as_double
560syn keyword sqlOption For_xml_null_treatment
561syn keyword sqlOption Force_view_creation
562syn keyword sqlOption Global_database_id
563syn keyword sqlOption Headings
564syn keyword sqlOption Input_format
565syn keyword sqlOption Integrated_server_name
566syn keyword sqlOption Isolation_level
567syn keyword sqlOption ISQL_command_timing
568syn keyword sqlOption ISQL_escape_character
569syn keyword sqlOption ISQL_field_separator
570syn keyword sqlOption ISQL_log
571syn keyword sqlOption ISQL_plan
572syn keyword sqlOption ISQL_plan_cursor_sensitivity
573syn keyword sqlOption ISQL_plan_cursor_writability
574syn keyword sqlOption ISQL_quote
575syn keyword sqlOption Java_heap_size
576syn keyword sqlOption Java_input_output
577syn keyword sqlOption Java_namespace_size
578syn keyword sqlOption Java_page_buffer_size
579syn keyword sqlOption Lock_rejected_rows
580syn keyword sqlOption Log_deadlocks
581syn keyword sqlOption Log_detailed_plans
582syn keyword sqlOption Log_max_requests
583syn keyword sqlOption Login_mode
584syn keyword sqlOption Login_procedure
585syn keyword sqlOption Max_cursor_count
586syn keyword sqlOption Max_hash_size
587syn keyword sqlOption Max_plans_cached
588syn keyword sqlOption Max_recursive_iterations
589syn keyword sqlOption Max_statement_count
590syn keyword sqlOption Max_work_table_hash_size
591syn keyword sqlOption Min_password_length
592syn keyword sqlOption Nearest_century
593syn keyword sqlOption Non_keywords
594syn keyword sqlOption NULLS
595syn keyword sqlOption ODBC_describe_binary_as_varbinary
596syn keyword sqlOption ODBC_distinguish_char_and_varchar
597syn keyword sqlOption On_Charset_conversion_failure
598syn keyword sqlOption On_error
599syn keyword sqlOption On_tsql_error
600syn keyword sqlOption Optimistic_wait_for_commit
601syn keyword sqlOption Optimization_goal
602syn keyword sqlOption Optimization_level
603syn keyword sqlOption Optimization_logging
604syn keyword sqlOption Optimization_workload
605syn keyword sqlOption Output_format
606syn keyword sqlOption Output_length
607syn keyword sqlOption Output_nulls
608syn keyword sqlOption Percent_as_comment
609syn keyword sqlOption Pinned_cursor_percent_of_cache
610syn keyword sqlOption Precision
611syn keyword sqlOption Prefetch
612syn keyword sqlOption Preserve_source_format
613syn keyword sqlOption Prevent_article_pkey_update
614syn keyword sqlOption Qualify_owners
615syn keyword sqlOption Query_plan_on_open
616syn keyword sqlOption Quiet
617syn keyword sqlOption Quote_all_identifiers
618syn keyword sqlOption Quoted_identifier
619syn keyword sqlOption Read_past_deleted
620syn keyword sqlOption Recovery_time
621syn keyword sqlOption Remote_idle_timeout
622syn keyword sqlOption Replicate_all
623syn keyword sqlOption Replication_error
624syn keyword sqlOption Replication_error_piece
625syn keyword sqlOption Return_date_time_as_string
626syn keyword sqlOption Return_java_as_string
627syn keyword sqlOption RI_Trigger_time
628syn keyword sqlOption Rollback_on_deadlock
629syn keyword sqlOption Row_counts
630syn keyword sqlOption Save_remote_passwords
631syn keyword sqlOption Scale
632syn keyword sqlOption Screen_format
633syn keyword sqlOption Sort_Collation
634syn keyword sqlOption SQL_flagger_error_level
635syn keyword sqlOption SQL_flagger_warning_level
636syn keyword sqlOption SQLConnect
637syn keyword sqlOption SQLStart
638syn keyword sqlOption SR_Date_Format
639syn keyword sqlOption SR_Time_Format
640syn keyword sqlOption SR_TimeStamp_Format
641syn keyword sqlOption Statistics
642syn keyword sqlOption String_rtruncation
643syn keyword sqlOption Subscribe_by_remote
644syn keyword sqlOption Subsume_row_locks
645syn keyword sqlOption Suppress_TDS_debugging
646syn keyword sqlOption TDS_Empty_string_is_null
647syn keyword sqlOption Temp_space_limit_check
648syn keyword sqlOption Thread_count
649syn keyword sqlOption Thread_stack
650syn keyword sqlOption Thread_swaps
651syn keyword sqlOption Time_format
652syn keyword sqlOption Time_zone_adjustment
653syn keyword sqlOption Timestamp_format
654syn keyword sqlOption Truncate_date_values
655syn keyword sqlOption Truncate_timestamp_values
656syn keyword sqlOption Truncate_with_auto_commit
657syn keyword sqlOption Truncation_length
658syn keyword sqlOption Tsql_hex_constant
659syn keyword sqlOption Tsql_variables
660syn keyword sqlOption Update_statistics
661syn keyword sqlOption User_estimates
662syn keyword sqlOption Verify_all_columns
663syn keyword sqlOption Verify_threshold
664syn keyword sqlOption Wait_for_commit
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000[diff] [blame]665
666" Strings and characters:
667syn region sqlString start=+"+ end=+"+ contains=@Spell
668syn region sqlString start=+'+ end=+'+ contains=@Spell
669
670" Numbers:
671syn match sqlNumber "-\=\<\d*\.\=[0-9_]\>"
672
673" Comments:
674syn region sqlDashComment start=/--/ end=/$/ contains=@Spell
675syn region sqlSlashComment start=/\/\// end=/$/ contains=@Spell
676syn region sqlMultiComment start="/\*" end="\*/" contains=sqlMultiComment,@Spell
677syn cluster sqlComment contains=sqlDashComment,sqlSlashComment,sqlMultiComment,@Spell
678syn sync ccomment sqlComment
679syn sync ccomment sqlDashComment
680syn sync ccomment sqlSlashComment
681
682" Define the default highlighting.
683" For version 5.7 and earlier: only when not done already
684" For version 5.8 and later: only when an item doesn't have highlighting yet
685if version >= 508 || !exists("did_sql_syn_inits")
686 if version < 508
687 let did_sql_syn_inits = 1
688 command -nargs=+ HiLink hi link <args>
689 else
690 command -nargs=+ HiLink hi link <args>
691 endif
692
693 HiLink sqlDashComment Comment
694 HiLink sqlSlashComment Comment
695 HiLink sqlMultiComment Comment
696 HiLink sqlNumber Number
697 HiLink sqlOperator Operator
698 HiLink sqlSpecial Special
699 HiLink sqlKeyword Keyword
700 HiLink sqlStatement Statement
701 HiLink sqlString String
702 HiLink sqlType Type
703 HiLink sqlFunction Function
704 HiLink sqlOption PreProc
705
706 delcommand HiLink
707endif
708
709let b:current_syntax = "sqlanywhere"
710
Bram Moolenaar446cb832008-06-24 21:56:24 +0000[diff] [blame]711" vim:sw=4: