codekingpro/portable-devtools

1" Vim syntax file2" Language:    SQL, Adaptive Server Anywhere3" Maintainer:  David Fishburn <dfishburn dot vim at gmail dot com>4" Last Change: 2013 May 135" Version:     16.0.06 7" Description: Updated to Adaptive Server Anywhere 16.0.08"              Updated to Adaptive Server Anywhere 12.0.1 (including spatial data)9"              Updated to Adaptive Server Anywhere 11.0.110"              Updated to Adaptive Server Anywhere 10.0.111"              Updated to Adaptive Server Anywhere  9.0.212"              Updated to Adaptive Server Anywhere  9.0.113"              Updated to Adaptive Server Anywhere  9.0.014"15" quit when a syntax file was already loaded16if exists("b:current_syntax")17    finish18endif19 20syn case ignore21 22" The SQL reserved words, defined as keywords.23 24syn keyword sqlSpecial  false null true25 26" common functions27syn keyword sqlFunction  abs argn avg bintohex bintostr28syn keyword sqlFunction  byte_length byte_substr char_length29syn keyword sqlFunction  compare count count_big datalength date30syn keyword sqlFunction  date_format dateadd datediff datename31syn keyword sqlFunction  datepart day dayname days debug_eng32syn keyword sqlFunction  dense_rank density dialect difference33syn keyword sqlFunction  dow estimate estimate_source evaluate34syn keyword sqlFunction  experience_estimate explanation35syn keyword sqlFunction  get_identity graphical_plan36syn keyword sqlFunction  graphical_ulplan greater grouping37syn keyword sqlFunction  hextobin hextoint hour hours identity38syn keyword sqlFunction  ifnull index_estimate inttohex isdate39syn keyword sqlFunction  isencrypted isnull isnumeric40syn keyword sqlFunction  lang_message length lesser like_end41syn keyword sqlFunction  like_start list long_ulplan lookup max42syn keyword sqlFunction  min minute minutes month monthname43syn keyword sqlFunction  months newid now nullif number44syn keyword sqlFunction  percent_rank plan quarter rand rank45syn keyword sqlFunction  regexp_compile regexp_compile_patindex46syn keyword sqlFunction  remainder rewrite rowid second seconds47syn keyword sqlFunction  short_ulplan similar sortkey soundex48syn keyword sqlFunction  stddev stack_trace str string strtobin strtouuid stuff49syn keyword sqlFunction  subpartition substr substring sum switchoffset sysdatetimeoffset50syn keyword sqlFunction  textptr todate todatetimeoffset today totimestamp traceback transactsql51syn keyword sqlFunction  ts_index_statistics ts_table_statistics52syn keyword sqlFunction  tsequal ulplan user_id user_name utc_now53syn keyword sqlFunction  uuidtostr varexists variance watcomsql54syn keyword sqlFunction  weeks wsql_state year years ymd55 56" 9.0.1 functions57syn keyword sqlFunction	 acos asin atan atn2 cast ceiling convert cos cot58syn keyword sqlFunction	 char_length coalesce dateformat datetime degrees exp59syn keyword sqlFunction	 floor getdate insertstr60syn keyword sqlFunction	 log log10 lower mod pi power61syn keyword sqlFunction	 property radians replicate round sign sin62syn keyword sqlFunction	 sqldialect tan truncate truncnum63syn keyword sqlFunction	 base64_encode base64_decode64syn keyword sqlFunction	 hash compress decompress encrypt decrypt65 66" 11.0.1 functions67syn keyword sqlFunction	 connection_extended_property text_handle_vector_match68syn keyword sqlFunction	 read_client_file write_client_file69 70" 12.0.1 functions71syn keyword sqlFunction	 http_response_header72 73" string functions74syn keyword sqlFunction	 ascii char left ltrim repeat75syn keyword sqlFunction	 space right rtrim trim lcase ucase76syn keyword sqlFunction	 locate charindex patindex replace77syn keyword sqlFunction	 errormsg csconvert78 79" property functions80syn keyword sqlFunction	 db_id db_name property_name81syn keyword sqlFunction	 property_description property_number82syn keyword sqlFunction	 next_connection next_database property83syn keyword sqlFunction	 connection_property db_property db_extended_property84syn keyword sqlFunction	 event_parmeter event_condition event_condition_name85 86" sa_ procedures87syn keyword sqlFunction	 sa_add_index_consultant_analysis88syn keyword sqlFunction	 sa_add_workload_query89syn keyword sqlFunction  sa_app_deregister90syn keyword sqlFunction  sa_app_get_infoStr91syn keyword sqlFunction  sa_app_get_status92syn keyword sqlFunction  sa_app_register93syn keyword sqlFunction  sa_app_registration_unlock94syn keyword sqlFunction  sa_app_set_infoStr95syn keyword sqlFunction  sa_audit_string96syn keyword sqlFunction  sa_check_commit97syn keyword sqlFunction  sa_checkpoint_execute98syn keyword sqlFunction  sa_conn_activity99syn keyword sqlFunction  sa_conn_compression_info100syn keyword sqlFunction  sa_conn_deregister101syn keyword sqlFunction  sa_conn_info102syn keyword sqlFunction  sa_conn_properties103syn keyword sqlFunction  sa_conn_properties_by_conn104syn keyword sqlFunction  sa_conn_properties_by_name105syn keyword sqlFunction  sa_conn_register106syn keyword sqlFunction  sa_conn_set_status107syn keyword sqlFunction  sa_create_analysis_from_query108syn keyword sqlFunction  sa_db_info109syn keyword sqlFunction  sa_db_properties110syn keyword sqlFunction  sa_disable_auditing_type111syn keyword sqlFunction  sa_disable_index112syn keyword sqlFunction  sa_disk_free_space113syn keyword sqlFunction  sa_enable_auditing_type114syn keyword sqlFunction  sa_enable_index115syn keyword sqlFunction  sa_end_forward_to116syn keyword sqlFunction  sa_eng_properties117syn keyword sqlFunction  sa_event_schedules118syn keyword sqlFunction  sa_exec_script119syn keyword sqlFunction  sa_flush_cache120syn keyword sqlFunction  sa_flush_statistics121syn keyword sqlFunction  sa_forward_to122syn keyword sqlFunction  sa_get_dtt123syn keyword sqlFunction  sa_get_histogram124syn keyword sqlFunction  sa_get_request_profile125syn keyword sqlFunction  sa_get_request_profile_sub126syn keyword sqlFunction  sa_get_request_times127syn keyword sqlFunction  sa_get_server_messages128syn keyword sqlFunction  sa_get_simulated_scale_factors129syn keyword sqlFunction  sa_get_workload_capture_status130syn keyword sqlFunction  sa_index_density131syn keyword sqlFunction  sa_index_levels132syn keyword sqlFunction  sa_index_statistics133syn keyword sqlFunction  sa_internal_alter_index_ability134syn keyword sqlFunction  sa_internal_create_analysis_from_query135syn keyword sqlFunction  sa_internal_disk_free_space136syn keyword sqlFunction  sa_internal_get_dtt137syn keyword sqlFunction  sa_internal_get_histogram138syn keyword sqlFunction  sa_internal_get_request_times139syn keyword sqlFunction  sa_internal_get_simulated_scale_factors140syn keyword sqlFunction  sa_internal_get_workload_capture_status141syn keyword sqlFunction  sa_internal_index_density142syn keyword sqlFunction  sa_internal_index_levels143syn keyword sqlFunction  sa_internal_index_statistics144syn keyword sqlFunction  sa_internal_java_loaded_classes145syn keyword sqlFunction  sa_internal_locks146syn keyword sqlFunction  sa_internal_pause_workload_capture147syn keyword sqlFunction  sa_internal_procedure_profile148syn keyword sqlFunction  sa_internal_procedure_profile_summary149syn keyword sqlFunction  sa_internal_read_backup_history150syn keyword sqlFunction  sa_internal_recommend_indexes151syn keyword sqlFunction  sa_internal_reset_identity152syn keyword sqlFunction  sa_internal_resume_workload_capture153syn keyword sqlFunction  sa_internal_start_workload_capture154syn keyword sqlFunction  sa_internal_stop_index_consultant155syn keyword sqlFunction  sa_internal_stop_workload_capture156syn keyword sqlFunction  sa_internal_table_fragmentation157syn keyword sqlFunction  sa_internal_table_page_usage158syn keyword sqlFunction  sa_internal_table_stats159syn keyword sqlFunction  sa_internal_virtual_sysindex160syn keyword sqlFunction  sa_internal_virtual_sysixcol161syn keyword sqlFunction  sa_java_loaded_classes162syn keyword sqlFunction  sa_jdk_version163syn keyword sqlFunction  sa_locks164syn keyword sqlFunction  sa_make_object165syn keyword sqlFunction  sa_pause_workload_capture166syn keyword sqlFunction  sa_proc_debug_attach_to_connection167syn keyword sqlFunction  sa_proc_debug_connect168syn keyword sqlFunction  sa_proc_debug_detach_from_connection169syn keyword sqlFunction  sa_proc_debug_disconnect170syn keyword sqlFunction  sa_proc_debug_get_connection_name171syn keyword sqlFunction  sa_proc_debug_release_connection172syn keyword sqlFunction  sa_proc_debug_request173syn keyword sqlFunction  sa_proc_debug_version174syn keyword sqlFunction  sa_proc_debug_wait_for_connection175syn keyword sqlFunction  sa_procedure_profile176syn keyword sqlFunction  sa_procedure_profile_summary177syn keyword sqlFunction  sa_read_backup_history178syn keyword sqlFunction  sa_recommend_indexes179syn keyword sqlFunction  sa_recompile_views180syn keyword sqlFunction  sa_remove_index_consultant_analysis181syn keyword sqlFunction  sa_remove_index_consultant_workload182syn keyword sqlFunction  sa_reset_identity183syn keyword sqlFunction  sa_resume_workload_capture184syn keyword sqlFunction  sa_server_option185syn keyword sqlFunction  sa_set_simulated_scale_factor186syn keyword sqlFunction  sa_setremoteuser187syn keyword sqlFunction  sa_setsubscription188syn keyword sqlFunction  sa_start_recording_commits189syn keyword sqlFunction  sa_start_workload_capture190syn keyword sqlFunction  sa_statement_text191syn keyword sqlFunction  sa_stop_index_consultant192syn keyword sqlFunction  sa_stop_recording_commits193syn keyword sqlFunction  sa_stop_workload_capture194syn keyword sqlFunction  sa_sync195syn keyword sqlFunction  sa_sync_sub196syn keyword sqlFunction  sa_table_fragmentation197syn keyword sqlFunction  sa_table_page_usage198syn keyword sqlFunction  sa_table_stats199syn keyword sqlFunction  sa_update_index_consultant_workload200syn keyword sqlFunction  sa_validate201syn keyword sqlFunction  sa_virtual_sysindex202syn keyword sqlFunction  sa_virtual_sysixcol203 204" sp_ procedures205syn keyword sqlFunction  sp_addalias206syn keyword sqlFunction  sp_addauditrecord207syn keyword sqlFunction  sp_adddumpdevice208syn keyword sqlFunction  sp_addgroup209syn keyword sqlFunction  sp_addlanguage210syn keyword sqlFunction  sp_addlogin211syn keyword sqlFunction  sp_addmessage212syn keyword sqlFunction  sp_addremotelogin213syn keyword sqlFunction  sp_addsegment214syn keyword sqlFunction  sp_addserver215syn keyword sqlFunction  sp_addthreshold216syn keyword sqlFunction  sp_addtype217syn keyword sqlFunction  sp_adduser218syn keyword sqlFunction  sp_auditdatabase219syn keyword sqlFunction  sp_auditlogin220syn keyword sqlFunction  sp_auditobject221syn keyword sqlFunction  sp_auditoption222syn keyword sqlFunction  sp_auditsproc223syn keyword sqlFunction  sp_bindefault224syn keyword sqlFunction  sp_bindmsg225syn keyword sqlFunction  sp_bindrule226syn keyword sqlFunction  sp_changedbowner227syn keyword sqlFunction  sp_changegroup228syn keyword sqlFunction  sp_checknames229syn keyword sqlFunction  sp_checkperms230syn keyword sqlFunction  sp_checkreswords231syn keyword sqlFunction  sp_clearstats232syn keyword sqlFunction  sp_column_privileges233syn keyword sqlFunction  sp_columns234syn keyword sqlFunction  sp_commonkey235syn keyword sqlFunction  sp_configure236syn keyword sqlFunction  sp_cursorinfo237syn keyword sqlFunction  sp_databases238syn keyword sqlFunction  sp_datatype_info239syn keyword sqlFunction  sp_dboption240syn keyword sqlFunction  sp_dbremap241syn keyword sqlFunction  sp_depends242syn keyword sqlFunction  sp_diskdefault243syn keyword sqlFunction  sp_displaylogin244syn keyword sqlFunction  sp_dropalias245syn keyword sqlFunction  sp_dropdevice246syn keyword sqlFunction  sp_dropgroup247syn keyword sqlFunction  sp_dropkey248syn keyword sqlFunction  sp_droplanguage249syn keyword sqlFunction  sp_droplogin250syn keyword sqlFunction  sp_dropmessage251syn keyword sqlFunction  sp_dropremotelogin252syn keyword sqlFunction  sp_dropsegment253syn keyword sqlFunction  sp_dropserver254syn keyword sqlFunction  sp_dropthreshold255syn keyword sqlFunction  sp_droptype256syn keyword sqlFunction  sp_dropuser257syn keyword sqlFunction  sp_estspace258syn keyword sqlFunction  sp_extendsegment259syn keyword sqlFunction  sp_fkeys260syn keyword sqlFunction  sp_foreignkey261syn keyword sqlFunction  sp_getmessage262syn keyword sqlFunction  sp_help263syn keyword sqlFunction  sp_helpconstraint264syn keyword sqlFunction  sp_helpdb265syn keyword sqlFunction  sp_helpdevice266syn keyword sqlFunction  sp_helpgroup267syn keyword sqlFunction  sp_helpindex268syn keyword sqlFunction  sp_helpjoins269syn keyword sqlFunction  sp_helpkey270syn keyword sqlFunction  sp_helplanguage271syn keyword sqlFunction  sp_helplog272syn keyword sqlFunction  sp_helpprotect273syn keyword sqlFunction  sp_helpremotelogin274syn keyword sqlFunction  sp_helpsegment275syn keyword sqlFunction  sp_helpserver276syn keyword sqlFunction  sp_helpsort277syn keyword sqlFunction  sp_helptext278syn keyword sqlFunction  sp_helpthreshold279syn keyword sqlFunction  sp_helpuser280syn keyword sqlFunction  sp_indsuspect281syn keyword sqlFunction  sp_lock282syn keyword sqlFunction  sp_locklogin283syn keyword sqlFunction  sp_logdevice284syn keyword sqlFunction  sp_login_environment285syn keyword sqlFunction  sp_modifylogin286syn keyword sqlFunction  sp_modifythreshold287syn keyword sqlFunction  sp_monitor288syn keyword sqlFunction  sp_password289syn keyword sqlFunction  sp_pkeys290syn keyword sqlFunction  sp_placeobject291syn keyword sqlFunction  sp_primarykey292syn keyword sqlFunction  sp_procxmode293syn keyword sqlFunction  sp_recompile294syn keyword sqlFunction  sp_remap295syn keyword sqlFunction  sp_remote_columns296syn keyword sqlFunction  sp_remote_exported_keys297syn keyword sqlFunction  sp_remote_imported_keys298syn keyword sqlFunction  sp_remote_pcols299syn keyword sqlFunction  sp_remote_primary_keys300syn keyword sqlFunction  sp_remote_procedures301syn keyword sqlFunction  sp_remote_tables302syn keyword sqlFunction  sp_remoteoption303syn keyword sqlFunction  sp_rename304syn keyword sqlFunction  sp_renamedb305syn keyword sqlFunction  sp_reportstats306syn keyword sqlFunction  sp_reset_tsql_environment307syn keyword sqlFunction  sp_role308syn keyword sqlFunction  sp_server_info309syn keyword sqlFunction  sp_servercaps310syn keyword sqlFunction  sp_serverinfo311syn keyword sqlFunction  sp_serveroption312syn keyword sqlFunction  sp_setlangalias313syn keyword sqlFunction  sp_setreplicate314syn keyword sqlFunction  sp_setrepproc315syn keyword sqlFunction  sp_setreptable316syn keyword sqlFunction  sp_spaceused317syn keyword sqlFunction  sp_special_columns318syn keyword sqlFunction  sp_sproc_columns319syn keyword sqlFunction  sp_statistics320syn keyword sqlFunction  sp_stored_procedures321syn keyword sqlFunction  sp_syntax322syn keyword sqlFunction  sp_table_privileges323syn keyword sqlFunction  sp_tables324syn keyword sqlFunction  sp_tsql_environment325syn keyword sqlFunction  sp_tsql_feature_not_supported326syn keyword sqlFunction  sp_unbindefault327syn keyword sqlFunction  sp_unbindmsg328syn keyword sqlFunction  sp_unbindrule329syn keyword sqlFunction  sp_volchanged330syn keyword sqlFunction  sp_who331syn keyword sqlFunction  xp_scanf332syn keyword sqlFunction  xp_sprintf333 334" server functions335syn keyword sqlFunction  col_length336syn keyword sqlFunction  col_name337syn keyword sqlFunction  index_col338syn keyword sqlFunction  object_id339syn keyword sqlFunction  object_name340syn keyword sqlFunction  proc_role341syn keyword sqlFunction  show_role342syn keyword sqlFunction  xp_cmdshell343syn keyword sqlFunction  xp_msver344syn keyword sqlFunction  xp_read_file345syn keyword sqlFunction  xp_real_cmdshell346syn keyword sqlFunction  xp_real_read_file347syn keyword sqlFunction  xp_real_sendmail348syn keyword sqlFunction  xp_real_startmail349syn keyword sqlFunction  xp_real_startsmtp350syn keyword sqlFunction  xp_real_stopmail351syn keyword sqlFunction  xp_real_stopsmtp352syn keyword sqlFunction  xp_real_write_file353syn keyword sqlFunction  xp_scanf354syn keyword sqlFunction  xp_sendmail355syn keyword sqlFunction  xp_sprintf356syn keyword sqlFunction  xp_startmail357syn keyword sqlFunction  xp_startsmtp358syn keyword sqlFunction  xp_stopmail359syn keyword sqlFunction  xp_stopsmtp360syn keyword sqlFunction  xp_write_file361 362" http functions363syn keyword sqlFunction	 http_header http_variable364syn keyword sqlFunction	 next_http_header next_http_response_header next_http_variable365syn keyword sqlFunction	 sa_set_http_header sa_set_http_option366syn keyword sqlFunction	 sa_http_variable_info sa_http_header_info367 368" http functions 9.0.1369syn keyword sqlFunction	 http_encode http_decode370syn keyword sqlFunction	 html_encode html_decode371 372" XML function support373syn keyword sqlFunction	 openxml xmlelement xmlforest xmlgen xmlconcat xmlagg374syn keyword sqlFunction	 xmlattributes375 376" Spatial Compatibility Functions377syn keyword sqlFunction  ST_BdMPolyFromText378syn keyword sqlFunction  ST_BdMPolyFromWKB379syn keyword sqlFunction  ST_BdPolyFromText380syn keyword sqlFunction  ST_BdPolyFromWKB381syn keyword sqlFunction  ST_CPolyFromText382syn keyword sqlFunction  ST_CPolyFromWKB383syn keyword sqlFunction  ST_CircularFromTxt384syn keyword sqlFunction  ST_CircularFromWKB385syn keyword sqlFunction  ST_CompoundFromTxt386syn keyword sqlFunction  ST_CompoundFromWKB387syn keyword sqlFunction  ST_GeomCollFromTxt388syn keyword sqlFunction  ST_GeomCollFromWKB389syn keyword sqlFunction  ST_GeomFromText390syn keyword sqlFunction  ST_GeomFromWKB391syn keyword sqlFunction  ST_LineFromText392syn keyword sqlFunction  ST_LineFromWKB393syn keyword sqlFunction  ST_MCurveFromText394syn keyword sqlFunction  ST_MCurveFromWKB395syn keyword sqlFunction  ST_MLineFromText396syn keyword sqlFunction  ST_MLineFromWKB397syn keyword sqlFunction  ST_MPointFromText398syn keyword sqlFunction  ST_MPointFromWKB399syn keyword sqlFunction  ST_MPolyFromText400syn keyword sqlFunction  ST_MPolyFromWKB401syn keyword sqlFunction  ST_MSurfaceFromTxt402syn keyword sqlFunction  ST_MSurfaceFromWKB403syn keyword sqlFunction  ST_OrderingEquals404syn keyword sqlFunction  ST_PointFromText405syn keyword sqlFunction  ST_PointFromWKB406syn keyword sqlFunction  ST_PolyFromText407syn keyword sqlFunction  ST_PolyFromWKB408" Spatial Structural Methods409syn keyword sqlFunction  ST_CoordDim410syn keyword sqlFunction  ST_CurveN411syn keyword sqlFunction  ST_Dimension412syn keyword sqlFunction  ST_EndPoint413syn keyword sqlFunction  ST_ExteriorRing414syn keyword sqlFunction  ST_GeometryN415syn keyword sqlFunction  ST_GeometryType416syn keyword sqlFunction  ST_InteriorRingN417syn keyword sqlFunction  ST_Is3D418syn keyword sqlFunction  ST_IsClosed419syn keyword sqlFunction  ST_IsEmpty420syn keyword sqlFunction  ST_IsMeasured421syn keyword sqlFunction  ST_IsRing422syn keyword sqlFunction  ST_IsSimple423syn keyword sqlFunction  ST_IsValid424syn keyword sqlFunction  ST_NumCurves425syn keyword sqlFunction  ST_NumGeometries426syn keyword sqlFunction  ST_NumInteriorRing427syn keyword sqlFunction  ST_NumPoints428syn keyword sqlFunction  ST_PointN429syn keyword sqlFunction  ST_StartPoint430"Spatial Computation431syn keyword sqlFunction  ST_Length432syn keyword sqlFunction  ST_Area433syn keyword sqlFunction  ST_Centroid434syn keyword sqlFunction  ST_Area435syn keyword sqlFunction  ST_Centroid436syn keyword sqlFunction  ST_IsWorld437syn keyword sqlFunction  ST_Perimeter438syn keyword sqlFunction  ST_PointOnSurface439syn keyword sqlFunction  ST_Distance440" Spatial Input/Output441syn keyword sqlFunction  ST_AsBinary442syn keyword sqlFunction  ST_AsGML443syn keyword sqlFunction  ST_AsGeoJSON444syn keyword sqlFunction  ST_AsSVG445syn keyword sqlFunction  ST_AsSVGAggr446syn keyword sqlFunction  ST_AsText447syn keyword sqlFunction  ST_AsWKB448syn keyword sqlFunction  ST_AsWKT449syn keyword sqlFunction  ST_AsXML450syn keyword sqlFunction  ST_GeomFromBinary451syn keyword sqlFunction  ST_GeomFromShape452syn keyword sqlFunction  ST_GeomFromText453syn keyword sqlFunction  ST_GeomFromWKB454syn keyword sqlFunction  ST_GeomFromWKT455syn keyword sqlFunction  ST_GeomFromXML456" Spatial Cast Methods457syn keyword sqlFunction  ST_CurvePolyToPoly458syn keyword sqlFunction  ST_CurveToLine459syn keyword sqlFunction  ST_ToCircular460syn keyword sqlFunction  ST_ToCompound461syn keyword sqlFunction  ST_ToCurve462syn keyword sqlFunction  ST_ToCurvePoly463syn keyword sqlFunction  ST_ToGeomColl464syn keyword sqlFunction  ST_ToLineString465syn keyword sqlFunction  ST_ToMultiCurve466syn keyword sqlFunction  ST_ToMultiLine467syn keyword sqlFunction  ST_ToMultiPoint468syn keyword sqlFunction  ST_ToMultiPolygon469syn keyword sqlFunction  ST_ToMultiSurface470syn keyword sqlFunction  ST_ToPoint471syn keyword sqlFunction  ST_ToPolygon472syn keyword sqlFunction  ST_ToSurface473 474" Array functions 16.x475syn keyword sqlFunction	 array array_agg array_max_cardinality trim_array476syn keyword sqlFunction	 error_line error_message error_procedure477syn keyword sqlFunction	 error_sqlcode error_sqlstate error_stack_trace478 479 480" keywords481syn keyword sqlKeyword	 absolute accent access account action active activate add address admin482syn keyword sqlKeyword	 aes_decrypt after aggregate algorithm allow_dup_row allow allowed alter483syn keyword sqlKeyword	 always and angular ansi_substring any as append apply484syn keyword sqlKeyword	 arbiter array asc ascii ase485syn keyword sqlKeyword	 assign at atan2 atomic attended486syn keyword sqlKeyword	 audit auditing authentication authorization axis487syn keyword sqlKeyword	 autoincrement autostop batch bcp before488syn keyword sqlKeyword	 between bit_and bit_length bit_or bit_substr bit_xor489syn keyword sqlKeyword	 blank blanks block490syn keyword sqlKeyword	 both bottom unbounded breaker bufferpool491syn keyword sqlKeyword	 build bulk by byte bytes cache calibrate calibration492syn keyword sqlKeyword	 cancel capability cardinality cascade cast493syn keyword sqlKeyword	 catalog catch ceil change changes char char_convert494syn keyword sqlKeyword	 check checkpointlog checksum class classes client cmp495syn keyword sqlKeyword	 cluster clustered collation496syn keyword sqlKeyword	 column columns497syn keyword sqlKeyword	 command comments committed commitid comparisons498syn keyword sqlKeyword	 compatible component compressed compute computes499syn keyword sqlKeyword	 concat configuration confirm conflict connection500syn keyword sqlKeyword	 console consolidate consolidated501syn keyword sqlKeyword	 constraint constraints content502syn keyword sqlKeyword	 convert coordinate coordinator copy count count_set_bits503syn keyword sqlKeyword	 crc createtime critical cross cube cume_dist504syn keyword sqlKeyword	 current cursor data data database505syn keyword sqlKeyword	 current_timestamp current_user cycle506syn keyword sqlKeyword	 databases datatype dba dbfile507syn keyword sqlKeyword	 dbspace dbspaces dbspacename debug decoupled508syn keyword sqlKeyword	 decrypted default defaults default_dbspace deferred509syn keyword sqlKeyword	 definer definition510syn keyword sqlKeyword	 delay deleting delimited dependencies desc511syn keyword sqlKeyword	 description deterministic directory512syn keyword sqlKeyword	 disable disabled disallow distinct disksandbox disk_sandbox513syn keyword sqlKeyword	 dn do domain download duplicate514syn keyword sqlKeyword	 dsetpass dttm dynamic each earth editproc effective ejb515syn keyword sqlKeyword	 elimination ellipsoid else elseif516syn keyword sqlKeyword	 email empty enable encapsulated encrypted encryption end517syn keyword sqlKeyword	 encoding endif engine environment erase error errors escape escapes event518syn keyword sqlKeyword	 event_parameter every exception exclude excluded exclusive exec519syn keyword sqlKeyword	 existing exists expanded expiry express exprtype extended_property520syn keyword sqlKeyword	 external externlogin factor failover false521syn keyword sqlKeyword	 fastfirstrow feature fieldproc file files filler522syn keyword sqlKeyword	 fillfactor final finish first first_keyword first_value523syn keyword sqlKeyword	 flattening524syn keyword sqlKeyword	 following force foreign format forjson forxml forxml_sep fp frame525syn keyword sqlKeyword	 free freepage french fresh full function526syn keyword sqlKeyword	 gb generic get_bit go global grid527syn keyword sqlKeyword	 group handler hash having header hexadecimal528syn keyword sqlKeyword	 hidden high history hg hng hold holdlock host529syn keyword sqlKeyword	 hours http_body http_session_timeout id identified identity ignore530syn keyword sqlKeyword	 ignore_dup_key ignore_dup_row immediate531syn keyword sqlKeyword	 in inactiv inactive inactivity included increment incremental532syn keyword sqlKeyword	 index index_enabled index_lparen indexonly info information533syn keyword sqlKeyword	 inheritance inline inner inout insensitive inserting534syn keyword sqlKeyword	 instead535syn keyword sqlKeyword	 internal intersection into introduced inverse invoker536syn keyword sqlKeyword	 iq is isolation537syn keyword sqlKeyword	 jar java java_location java_main_userid java_vm_options538syn keyword sqlKeyword	 jconnect jdk join json kb key keys keep language last539syn keyword sqlKeyword	 last_keyword last_value lateral latitude540syn keyword sqlKeyword	 ld ldap left len linear lf ln level like541syn keyword sqlKeyword	 limit local location log542syn keyword sqlKeyword	 logging logical login logscan long longitude low lru ls543syn keyword sqlKeyword	 main major manage manual mark master544syn keyword sqlKeyword	 match matched materialized max maxvalue maximum mb measure median membership545syn keyword sqlKeyword	 merge metadata methods migrate minimum minor minutes minvalue mirror546syn keyword sqlKeyword	 mode modify monitor move mru multiplex547syn keyword sqlKeyword	 name named namespaces national native natural new next nextval548syn keyword sqlKeyword	 ngram no noholdlock nolock nonclustered none normal not549syn keyword sqlKeyword	 notify null nullable_constant nulls550syn keyword sqlKeyword	 object objects oem_string of off offline offset olap551syn keyword sqlKeyword	 old on online only openstring operator552syn keyword sqlKeyword	 optimization optimizer option553syn keyword sqlKeyword	 or order ordinality organization others out outer over owner554syn keyword sqlKeyword	 package packetsize padding page pages555syn keyword sqlKeyword	 paglock parallel parameter parent part partial556syn keyword sqlKeyword	 partition partitions partner password path pctfree557syn keyword sqlKeyword	 permissions perms plan planar policy polygon populate port postfilter preceding558syn keyword sqlKeyword	 precisionprefetch prefilter prefix preserve preview previous559syn keyword sqlKeyword	 primary prior priority priqty private privilege privileges procedure profile profiling560syn keyword sqlKeyword	 property_is_cumulative property_is_numeric public publication publish publisher561syn keyword sqlKeyword	 quiesce quote quotes range readclientfile readcommitted reader readfile readonly562syn keyword sqlKeyword	 readpast readuncommitted readwrite rebuild563syn keyword sqlKeyword	 received recompile recover recursive references564syn keyword sqlKeyword	 referencing regex regexp regexp_substr relative relocate565syn keyword sqlKeyword	 rename repeatable repeatableread replicate replication566syn keyword sqlKeyword	 requests request_timeout required rereceive resend reserve reset567syn keyword sqlKeyword	 resizing resolve resource respect restart568syn keyword sqlKeyword	 restrict result retain retries569syn keyword sqlKeyword	 returns reverse right role roles570syn keyword sqlKeyword	 rollup root row row_number rowlock rows rowtype571syn keyword sqlKeyword	 sa_index_hash sa_internal_fk_verify sa_internal_termbreak572syn keyword sqlKeyword	 sa_order_preserving_hash sa_order_preserving_hash_big sa_order_preserving_hash_prefix573syn keyword sqlKeyword	 sa_file_free_pages sa_internal_type_from_catalog sa_internal_valid_hash574syn keyword sqlKeyword	 sa_internal_validate_value sa_json_element575syn keyword sqlKeyword	 scale schedule schema scope script scripted scroll search seconds secqty security576syn keyword sqlKeyword	 semi send sensitive sent sequence serializable577syn keyword sqlKeyword	 server severity session set_bit set_bits sets578syn keyword sqlKeyword	 shapefile share side simple since site size skip579syn keyword sqlKeyword	 snap snapshot soapheader soap_header580syn keyword sqlKeyword	 spatial split some sorted_data581syn keyword sqlKeyword	 sql sqlcode sqlid sqlflagger sqlstate sqrt square582syn keyword sqlKeyword	 stacker stale state statement statistics status stddev_pop stddev_samp583syn keyword sqlKeyword	 stemmer stogroup stoplist storage store584syn keyword sqlKeyword	 strip stripesizekb striping subpages subscribe subscription585syn keyword sqlKeyword	 subtransaction suser_id suser_name suspend synchronization586syn keyword sqlKeyword	 syntax_error table tables tablock587syn keyword sqlKeyword	 tablockx target tb temp template temporary term then ties588syn keyword sqlKeyword	 timezone timeout tls to to_char to_nchar tolerance top589syn keyword sqlKeyword	 trace traced_plan tracing590syn keyword sqlKeyword	 transfer transform transaction transactional treat tries591syn keyword sqlKeyword	 true try tsequal type tune uncommitted unconditionally592syn keyword sqlKeyword	 unenforced unicode unique unistr unit unknown unlimited unload593syn keyword sqlKeyword	 unpartition unquiesce updatetime updating updlock upgrade upload594syn keyword sqlKeyword	 upper usage use user595syn keyword sqlKeyword	 using utc utilities validproc596syn keyword sqlKeyword	 value values varchar variable597syn keyword sqlKeyword	 varying var_pop var_samp vcat verbosity598syn keyword sqlKeyword	 verify versions view virtual wait599syn keyword sqlKeyword	 warning wd web when where with with_auto600syn keyword sqlKeyword	 with_auto with_cube with_rollup without601syn keyword sqlKeyword	 with_lparen within word work workload write writefile602syn keyword sqlKeyword	 writeclientfile writer writers writeserver xlock603syn keyword sqlKeyword	 war xml zeros zone604" XML605syn keyword sqlKeyword	 raw auto elements explicit606" HTTP support607syn keyword sqlKeyword	 authorization secure url service next_soap_header608" HTTP 9.0.2 new procedure keywords609syn keyword sqlKeyword	 namespace certificate certificates clientport proxy trusted_certificates_file610" OLAP support 9.0.0611syn keyword sqlKeyword	 covar_pop covar_samp corr regr_slope regr_intercept612syn keyword sqlKeyword	 regr_count regr_r2 regr_avgx regr_avgy613syn keyword sqlKeyword	 regr_sxx regr_syy regr_sxy614 615" Alternate keywords616syn keyword sqlKeyword	 character dec options proc reference617syn keyword sqlKeyword	 subtrans tran syn keyword618 619" Login Mode Options620syn keyword sqlKeywordLogin	 standard integrated kerberos LDAPUA621syn keyword sqlKeywordLogin	 cloudadmin mixed622 623" Spatial Predicates624syn keyword sqlKeyword   ST_Contains625syn keyword sqlKeyword   ST_ContainsFilter626syn keyword sqlKeyword   ST_CoveredBy627syn keyword sqlKeyword   ST_CoveredByFilter628syn keyword sqlKeyword   ST_Covers629syn keyword sqlKeyword   ST_CoversFilter630syn keyword sqlKeyword   ST_Crosses631syn keyword sqlKeyword   ST_Disjoint632syn keyword sqlKeyword   ST_Equals633syn keyword sqlKeyword   ST_EqualsFilter634syn keyword sqlKeyword   ST_Intersects635syn keyword sqlKeyword   ST_IntersectsFilter636syn keyword sqlKeyword   ST_IntersectsRect637syn keyword sqlKeyword   ST_OrderingEquals638syn keyword sqlKeyword   ST_Overlaps639syn keyword sqlKeyword   ST_Relate640syn keyword sqlKeyword   ST_Touches641syn keyword sqlKeyword   ST_Within642syn keyword sqlKeyword   ST_WithinFilter643" Spatial Set operations644syn keyword sqlKeyword   ST_Affine645syn keyword sqlKeyword   ST_Boundary646syn keyword sqlKeyword   ST_Buffer647syn keyword sqlKeyword   ST_ConvexHull648syn keyword sqlKeyword   ST_ConvexHullAggr649syn keyword sqlKeyword   ST_Difference650syn keyword sqlKeyword   ST_Intersection651syn keyword sqlKeyword   ST_IntersectionAggr652syn keyword sqlKeyword   ST_SymDifference653syn keyword sqlKeyword   ST_Union654syn keyword sqlKeyword   ST_UnionAggr655" Spatial Bounds656syn keyword sqlKeyword   ST_Envelope657syn keyword sqlKeyword   ST_EnvelopeAggr658syn keyword sqlKeyword   ST_Lat659syn keyword sqlKeyword   ST_LatMax660syn keyword sqlKeyword   ST_LatMin661syn keyword sqlKeyword   ST_Long662syn keyword sqlKeyword   ST_LongMax663syn keyword sqlKeyword   ST_LongMin664syn keyword sqlKeyword   ST_M665syn keyword sqlKeyword   ST_MMax666syn keyword sqlKeyword   ST_MMin667syn keyword sqlKeyword   ST_Point668syn keyword sqlKeyword   ST_X669syn keyword sqlKeyword   ST_XMax670syn keyword sqlKeyword   ST_XMin671syn keyword sqlKeyword   ST_Y672syn keyword sqlKeyword   ST_YMax673syn keyword sqlKeyword   ST_YMin674syn keyword sqlKeyword   ST_Z675syn keyword sqlKeyword   ST_ZMax676syn keyword sqlKeyword   ST_ZMin677" Spatial Collection Aggregates678syn keyword sqlKeyword   ST_GeomCollectionAggr679syn keyword sqlKeyword   ST_LineStringAggr680syn keyword sqlKeyword   ST_MultiCurveAggr681syn keyword sqlKeyword   ST_MultiLineStringAggr682syn keyword sqlKeyword   ST_MultiPointAggr683syn keyword sqlKeyword   ST_MultiPolygonAggr684syn keyword sqlKeyword   ST_MultiSurfaceAggr685syn keyword sqlKeyword   ST_Perimeter686syn keyword sqlKeyword   ST_PointOnSurface687" Spatial SRS688syn keyword sqlKeyword   ST_CompareWKT689syn keyword sqlKeyword   ST_FormatWKT690syn keyword sqlKeyword   ST_ParseWKT691syn keyword sqlKeyword   ST_TransformGeom692syn keyword sqlKeyword   ST_GeometryTypeFromBaseType693syn keyword sqlKeyword   ST_SnapToGrid694syn keyword sqlKeyword   ST_Transform695syn keyword sqlKeyword   ST_SRID696syn keyword sqlKeyword   ST_SRIDFromBaseType697syn keyword sqlKeyword   ST_LoadConfigurationData698" Spatial Indexes699syn keyword sqlKeyword   ST_LinearHash700syn keyword sqlKeyword   ST_LinearUnHash701 702syn keyword sqlOperator	 in any some all between exists703syn keyword sqlOperator	 like escape not is and or704syn keyword sqlOperator  minus705syn keyword sqlOperator  prior distinct unnest706 707syn keyword sqlStatement allocate alter attach backup begin break call case catch708syn keyword sqlStatement checkpoint clear close comment commit configure connect709syn keyword sqlStatement continue create deallocate declare delete describe710syn keyword sqlStatement detach disconnect drop except execute exit explain fetch711syn keyword sqlStatement for forward from get goto grant help if include712syn keyword sqlStatement input insert install intersect leave load lock loop713syn keyword sqlStatement message open output parameters passthrough714syn keyword sqlStatement prepare print put raiserror read readtext refresh release715syn keyword sqlStatement remote remove reorganize resignal restore resume716syn keyword sqlStatement return revoke rollback save savepoint select717syn keyword sqlStatement set setuser signal start stop synchronize718syn keyword sqlStatement system trigger truncate try union unload update719syn keyword sqlStatement validate waitfor whenever while window writetext720 721 722syn keyword sqlType	 char nchar long varchar nvarchar text ntext uniqueidentifierstr xml723syn keyword sqlType	 bigint bit decimal double varbit724syn keyword sqlType	 float int integer numeric725syn keyword sqlType	 smallint tinyint real726syn keyword sqlType	 money smallmoney727syn keyword sqlType	 date datetime datetimeoffset smalldatetime time timestamp728syn keyword sqlType	 binary image varray varbinary uniqueidentifier729syn keyword sqlType	 unsigned730" Spatial types731syn keyword sqlType	 st_geometry st_point st_curve st_surface st_geomcollection732syn keyword sqlType	 st_linestring st_circularstring st_compoundcurve733syn keyword sqlType	 st_curvepolygon st_polygon734syn keyword sqlType	 st_multipoint st_multicurve st_multisurface735syn keyword sqlType	 st_multilinestring st_multipolygon736 737syn keyword sqlOption    Allow_nulls_by_default738syn keyword sqlOption    Allow_read_client_file739syn keyword sqlOption    Allow_snapshot_isolation740syn keyword sqlOption    Allow_write_client_file741syn keyword sqlOption    Ansi_blanks742syn keyword sqlOption    Ansi_close_cursors_on_rollback743syn keyword sqlOption    Ansi_permissions744syn keyword sqlOption    Ansi_substring745syn keyword sqlOption    Ansi_update_constraints746syn keyword sqlOption    Ansinull747syn keyword sqlOption    Auditing748syn keyword sqlOption    Auditing_options749syn keyword sqlOption    Auto_commit_on_create_local_temp_index750syn keyword sqlOption    Background_priority751syn keyword sqlOption    Blocking752syn keyword sqlOption    Blocking_others_timeout753syn keyword sqlOption    Blocking_timeout754syn keyword sqlOption    Chained755syn keyword sqlOption    Checkpoint_time756syn keyword sqlOption    Cis_option757syn keyword sqlOption    Cis_rowset_size758syn keyword sqlOption    Close_on_endtrans759syn keyword sqlOption    Collect_statistics_on_dml_updates760syn keyword sqlOption    Conn_auditing761syn keyword sqlOption    Connection_authentication762syn keyword sqlOption    Continue_after_raiserror763syn keyword sqlOption    Conversion_error764syn keyword sqlOption    Cooperative_commit_timeout765syn keyword sqlOption    Cooperative_commits766syn keyword sqlOption    Database_authentication767syn keyword sqlOption    Date_format768syn keyword sqlOption    Date_order769syn keyword sqlOption    db_publisher770syn keyword sqlOption    Debug_messages771syn keyword sqlOption    Dedicated_task772syn keyword sqlOption    Default_dbspace773syn keyword sqlOption    Default_timestamp_increment774syn keyword sqlOption    Delayed_commit_timeout775syn keyword sqlOption    Delayed_commits776syn keyword sqlOption    Divide_by_zero_error777syn keyword sqlOption    Escape_character778syn keyword sqlOption    Exclude_operators779syn keyword sqlOption    Extended_join_syntax780syn keyword sqlOption    Extern_login_credentials781syn keyword sqlOption    Fire_triggers782syn keyword sqlOption    First_day_of_week783syn keyword sqlOption    For_xml_null_treatment784syn keyword sqlOption    Force_view_creation785syn keyword sqlOption    Global_database_id786syn keyword sqlOption    Http_session_timeout787syn keyword sqlOption    Http_connection_pool_basesize788syn keyword sqlOption    Http_connection_pool_timeout789syn keyword sqlOption    Integrated_server_name790syn keyword sqlOption    Isolation_level791syn keyword sqlOption    Java_class_path792syn keyword sqlOption    Java_location793syn keyword sqlOption    Java_main_userid794syn keyword sqlOption    Java_vm_options795syn keyword sqlOption    Lock_rejected_rows796syn keyword sqlOption    Log_deadlocks797syn keyword sqlOption    Login_mode798syn keyword sqlOption    Login_procedure799syn keyword sqlOption    Materialized_view_optimization800syn keyword sqlOption    Max_client_statements_cached801syn keyword sqlOption    Max_cursor_count802syn keyword sqlOption    Max_hash_size803syn keyword sqlOption    Max_plans_cached804syn keyword sqlOption    Max_priority805syn keyword sqlOption    Max_query_tasks806syn keyword sqlOption    Max_recursive_iterations807syn keyword sqlOption    Max_statement_count808syn keyword sqlOption    Max_temp_space809syn keyword sqlOption    Min_password_length810syn keyword sqlOption    Min_role_admins811syn keyword sqlOption    Nearest_century812syn keyword sqlOption    Non_keywords813syn keyword sqlOption    Odbc_describe_binary_as_varbinary814syn keyword sqlOption    Odbc_distinguish_char_and_varchar815syn keyword sqlOption    Oem_string816syn keyword sqlOption    On_charset_conversion_failure817syn keyword sqlOption    On_tsql_error818syn keyword sqlOption    Optimization_goal819syn keyword sqlOption    Optimization_level820syn keyword sqlOption    Optimization_workload821syn keyword sqlOption    Pinned_cursor_percent_of_cache822syn keyword sqlOption    Post_login_procedure823syn keyword sqlOption    Precision824syn keyword sqlOption    Prefetch825syn keyword sqlOption    Preserve_source_format826syn keyword sqlOption    Prevent_article_pkey_update827syn keyword sqlOption    Priority828syn keyword sqlOption    Progress_messages829syn keyword sqlOption    Query_mem_timeout830syn keyword sqlOption    Quoted_identifier831syn keyword sqlOption    Read_past_deleted832syn keyword sqlOption    Recovery_time833syn keyword sqlOption    Remote_idle_timeout834syn keyword sqlOption    Replicate_all835syn keyword sqlOption    Request_timeout836syn keyword sqlOption    Reserved_keywords837syn keyword sqlOption    Return_date_time_as_string838syn keyword sqlOption    Rollback_on_deadlock839syn keyword sqlOption    Row_counts840syn keyword sqlOption    Scale841syn keyword sqlOption    Secure_feature_key842syn keyword sqlOption    Sort_collation843syn keyword sqlOption    Sql_flagger_error_level844syn keyword sqlOption    Sql_flagger_warning_level845syn keyword sqlOption    String_rtruncation846syn keyword sqlOption    st_geometry_asbinary_format847syn keyword sqlOption    st_geometry_astext_format848syn keyword sqlOption    st_geometry_asxml_format849syn keyword sqlOption    st_geometry_describe_type850syn keyword sqlOption    st_geometry_interpolation851syn keyword sqlOption    st_geometry_on_invalid852syn keyword sqlOption    Subsume_row_locks853syn keyword sqlOption    Suppress_tds_debugging854syn keyword sqlOption    Synchronize_mirror_on_commit855syn keyword sqlOption    Tds_empty_string_is_null856syn keyword sqlOption    Temp_space_limit_check857syn keyword sqlOption    Time_format858syn keyword sqlOption    Time_zone_adjustment859syn keyword sqlOption    Timestamp_format860syn keyword sqlOption    Timestamp_with_time_zone_format861syn keyword sqlOption    Truncate_timestamp_values862syn keyword sqlOption    Tsql_outer_joins863syn keyword sqlOption    Tsql_variables864syn keyword sqlOption    Updatable_statement_isolation865syn keyword sqlOption    Update_statistics866syn keyword sqlOption    Upgrade_database_capability867syn keyword sqlOption    User_estimates868syn keyword sqlOption    Uuid_has_hyphens869syn keyword sqlOption    Verify_password_function870syn keyword sqlOption    Wait_for_commit871syn keyword sqlOption    Webservice_namespace_host872syn keyword sqlOption    Webservice_sessionid_name873 874" Strings and characters:875syn region sqlString		start=+"+    end=+"+ contains=@Spell876syn region sqlString		start=+'+    end=+'+ contains=@Spell877 878" Numbers:879syn match sqlNumber		"-\=\<\d*\.\=[0-9_]\>"880 881" Comments:882syn region sqlDashComment	start=/--/ end=/$/ contains=@Spell883syn region sqlSlashComment	start=/\/\// end=/$/ contains=@Spell884syn region sqlMultiComment	start="/\*" end="\*/" contains=sqlMultiComment,@Spell885syn cluster sqlComment	contains=sqlDashComment,sqlSlashComment,sqlMultiComment,@Spell886syn sync ccomment sqlComment887syn sync ccomment sqlDashComment888syn sync ccomment sqlSlashComment889 890hi def link sqlDashComment	Comment891hi def link sqlSlashComment	Comment892hi def link sqlMultiComment	Comment893hi def link sqlNumber	        Number894hi def link sqlOperator	        Operator895hi def link sqlSpecial	        Special896hi def link sqlKeyword	        Keyword897hi def link sqlStatement	Statement898hi def link sqlString	        String899hi def link sqlType	        Type900hi def link sqlFunction	        Function901hi def link sqlOption	        PreProc902 903let b:current_syntax = "sqlanywhere"904 905" vim:sw=4:906