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