1
2" Vim syntax file
3" Language:    SQL, Adaptive Server Anywhere
4" Maintainer:  David Fishburn <fishburn at ianywhere dot com>
5" Last Change: Tue 29 Jan 2008 12:54:19 PM Eastern Standard Time
6" Version:     10.0.1
7
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
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
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
55
56" 9.0.1 functions
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
65
66" string functions
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
71
72" property functions
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
78
79" sa_ procedures
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
196
197" sp_ procedures
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
326
327" server functions
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
354
355" http functions
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
360
361" http functions 9.0.1
362syn keyword sqlFunction	 http_encode http_decode
363syn keyword sqlFunction	 html_encode html_decode
364
365" keywords
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
460" XML function support
461syn keyword sqlFunction	 openxml xmlelement xmlforest xmlgen xmlconcat xmlagg
462syn keyword sqlFunction	 xmlattributes
463syn keyword sqlKeyword	 raw auto elements explicit
464" HTTP support
465syn keyword sqlKeyword	 authorization secure url service
466" HTTP 9.0.2 new procedure keywords
467syn keyword sqlKeyword	 namespace certificate clientport proxy
468" OLAP support 9.0.0
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
472
473" Alternate keywords
474syn keyword sqlKeyword	 character dec options proc reference
475syn keyword sqlKeyword	 subtrans tran syn keyword
476
477
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
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
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
508
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
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
711" vim:sw=4:
712