diff options
Diffstat (limited to 'syntax/sqlanywhere.vim')
| -rw-r--r-- | syntax/sqlanywhere.vim | 909 |
1 files changed, 0 insertions, 909 deletions
diff --git a/syntax/sqlanywhere.vim b/syntax/sqlanywhere.vim deleted file mode 100644 index f380906f..00000000 --- a/syntax/sqlanywhere.vim +++ /dev/null @@ -1,909 +0,0 @@ -if !exists('g:polyglot_disabled') || index(g:polyglot_disabled, 'vim') == -1 - -" Vim syntax file -" Language: SQL, Adaptive Server Anywhere -" Maintainer: David Fishburn <dfishburn dot vim at gmail dot com> -" Last Change: 2013 May 13 -" Version: 16.0.0 - -" Description: Updated to Adaptive Server Anywhere 16.0.0 -" Updated to Adaptive Server Anywhere 12.0.1 (including spatial data) -" Updated to Adaptive Server Anywhere 11.0.1 -" Updated to Adaptive Server Anywhere 10.0.1 -" Updated to Adaptive Server Anywhere 9.0.2 -" Updated to Adaptive Server Anywhere 9.0.1 -" Updated to Adaptive Server Anywhere 9.0.0 -" -" quit when a syntax file was already loaded -if exists("b:current_syntax") - finish -endif - -syn case ignore - -" The SQL reserved words, defined as keywords. - -syn keyword sqlSpecial false null true - -" common functions -syn keyword sqlFunction abs argn avg bintohex bintostr -syn keyword sqlFunction byte_length byte_substr char_length -syn keyword sqlFunction compare count count_big datalength date -syn keyword sqlFunction date_format dateadd datediff datename -syn keyword sqlFunction datepart day dayname days debug_eng -syn keyword sqlFunction dense_rank density dialect difference -syn keyword sqlFunction dow estimate estimate_source evaluate -syn keyword sqlFunction experience_estimate explanation -syn keyword sqlFunction get_identity graphical_plan -syn keyword sqlFunction graphical_ulplan greater grouping -syn keyword sqlFunction hextobin hextoint hour hours identity -syn keyword sqlFunction ifnull index_estimate inttohex isdate -syn keyword sqlFunction isencrypted isnull isnumeric -syn keyword sqlFunction lang_message length lesser like_end -syn keyword sqlFunction like_start list long_ulplan lookup max -syn keyword sqlFunction min minute minutes month monthname -syn keyword sqlFunction months newid now nullif number -syn keyword sqlFunction percent_rank plan quarter rand rank -syn keyword sqlFunction regexp_compile regexp_compile_patindex -syn keyword sqlFunction remainder rewrite rowid second seconds -syn keyword sqlFunction short_ulplan similar sortkey soundex -syn keyword sqlFunction stddev stack_trace str string strtobin strtouuid stuff -syn keyword sqlFunction subpartition substr substring sum switchoffset sysdatetimeoffset -syn keyword sqlFunction textptr todate todatetimeoffset today totimestamp traceback transactsql -syn keyword sqlFunction ts_index_statistics ts_table_statistics -syn keyword sqlFunction tsequal ulplan user_id user_name utc_now -syn keyword sqlFunction uuidtostr varexists variance watcomsql -syn keyword sqlFunction weeks wsql_state year years ymd - -" 9.0.1 functions -syn keyword sqlFunction acos asin atan atn2 cast ceiling convert cos cot -syn keyword sqlFunction char_length coalesce dateformat datetime degrees exp -syn keyword sqlFunction floor getdate insertstr -syn keyword sqlFunction log log10 lower mod pi power -syn keyword sqlFunction property radians replicate round sign sin -syn keyword sqlFunction sqldialect tan truncate truncnum -syn keyword sqlFunction base64_encode base64_decode -syn keyword sqlFunction hash compress decompress encrypt decrypt - -" 11.0.1 functions -syn keyword sqlFunction connection_extended_property text_handle_vector_match -syn keyword sqlFunction read_client_file write_client_file - -" 12.0.1 functions -syn keyword sqlFunction http_response_header - -" string functions -syn keyword sqlFunction ascii char left ltrim repeat -syn keyword sqlFunction space right rtrim trim lcase ucase -syn keyword sqlFunction locate charindex patindex replace -syn keyword sqlFunction errormsg csconvert - -" property functions -syn keyword sqlFunction db_id db_name property_name -syn keyword sqlFunction property_description property_number -syn keyword sqlFunction next_connection next_database property -syn keyword sqlFunction connection_property db_property db_extended_property -syn keyword sqlFunction event_parmeter event_condition event_condition_name - -" sa_ procedures -syn keyword sqlFunction sa_add_index_consultant_analysis -syn keyword sqlFunction sa_add_workload_query -syn keyword sqlFunction sa_app_deregister -syn keyword sqlFunction sa_app_get_infoStr -syn keyword sqlFunction sa_app_get_status -syn keyword sqlFunction sa_app_register -syn keyword sqlFunction sa_app_registration_unlock -syn keyword sqlFunction sa_app_set_infoStr -syn keyword sqlFunction sa_audit_string -syn keyword sqlFunction sa_check_commit -syn keyword sqlFunction sa_checkpoint_execute -syn keyword sqlFunction sa_conn_activity -syn keyword sqlFunction sa_conn_compression_info -syn keyword sqlFunction sa_conn_deregister -syn keyword sqlFunction sa_conn_info -syn keyword sqlFunction sa_conn_properties -syn keyword sqlFunction sa_conn_properties_by_conn -syn keyword sqlFunction sa_conn_properties_by_name -syn keyword sqlFunction sa_conn_register -syn keyword sqlFunction sa_conn_set_status -syn keyword sqlFunction sa_create_analysis_from_query -syn keyword sqlFunction sa_db_info -syn keyword sqlFunction sa_db_properties -syn keyword sqlFunction sa_disable_auditing_type -syn keyword sqlFunction sa_disable_index -syn keyword sqlFunction sa_disk_free_space -syn keyword sqlFunction sa_enable_auditing_type -syn keyword sqlFunction sa_enable_index -syn keyword sqlFunction sa_end_forward_to -syn keyword sqlFunction sa_eng_properties -syn keyword sqlFunction sa_event_schedules -syn keyword sqlFunction sa_exec_script -syn keyword sqlFunction sa_flush_cache -syn keyword sqlFunction sa_flush_statistics -syn keyword sqlFunction sa_forward_to -syn keyword sqlFunction sa_get_dtt -syn keyword sqlFunction sa_get_histogram -syn keyword sqlFunction sa_get_request_profile -syn keyword sqlFunction sa_get_request_profile_sub -syn keyword sqlFunction sa_get_request_times -syn keyword sqlFunction sa_get_server_messages -syn keyword sqlFunction sa_get_simulated_scale_factors -syn keyword sqlFunction sa_get_workload_capture_status -syn keyword sqlFunction sa_index_density -syn keyword sqlFunction sa_index_levels -syn keyword sqlFunction sa_index_statistics -syn keyword sqlFunction sa_internal_alter_index_ability -syn keyword sqlFunction sa_internal_create_analysis_from_query -syn keyword sqlFunction sa_internal_disk_free_space -syn keyword sqlFunction sa_internal_get_dtt -syn keyword sqlFunction sa_internal_get_histogram -syn keyword sqlFunction sa_internal_get_request_times -syn keyword sqlFunction sa_internal_get_simulated_scale_factors -syn keyword sqlFunction sa_internal_get_workload_capture_status -syn keyword sqlFunction sa_internal_index_density -syn keyword sqlFunction sa_internal_index_levels -syn keyword sqlFunction sa_internal_index_statistics -syn keyword sqlFunction sa_internal_java_loaded_classes -syn keyword sqlFunction sa_internal_locks -syn keyword sqlFunction sa_internal_pause_workload_capture -syn keyword sqlFunction sa_internal_procedure_profile -syn keyword sqlFunction sa_internal_procedure_profile_summary -syn keyword sqlFunction sa_internal_read_backup_history -syn keyword sqlFunction sa_internal_recommend_indexes -syn keyword sqlFunction sa_internal_reset_identity -syn keyword sqlFunction sa_internal_resume_workload_capture -syn keyword sqlFunction sa_internal_start_workload_capture -syn keyword sqlFunction sa_internal_stop_index_consultant -syn keyword sqlFunction sa_internal_stop_workload_capture -syn keyword sqlFunction sa_internal_table_fragmentation -syn keyword sqlFunction sa_internal_table_page_usage -syn keyword sqlFunction sa_internal_table_stats -syn keyword sqlFunction sa_internal_virtual_sysindex -syn keyword sqlFunction sa_internal_virtual_sysixcol -syn keyword sqlFunction sa_java_loaded_classes -syn keyword sqlFunction sa_jdk_version -syn keyword sqlFunction sa_locks -syn keyword sqlFunction sa_make_object -syn keyword sqlFunction sa_pause_workload_capture -syn keyword sqlFunction sa_proc_debug_attach_to_connection -syn keyword sqlFunction sa_proc_debug_connect -syn keyword sqlFunction sa_proc_debug_detach_from_connection -syn keyword sqlFunction sa_proc_debug_disconnect -syn keyword sqlFunction sa_proc_debug_get_connection_name -syn keyword sqlFunction sa_proc_debug_release_connection -syn keyword sqlFunction sa_proc_debug_request -syn keyword sqlFunction sa_proc_debug_version -syn keyword sqlFunction sa_proc_debug_wait_for_connection -syn keyword sqlFunction sa_procedure_profile -syn keyword sqlFunction sa_procedure_profile_summary -syn keyword sqlFunction sa_read_backup_history -syn keyword sqlFunction sa_recommend_indexes -syn keyword sqlFunction sa_recompile_views -syn keyword sqlFunction sa_remove_index_consultant_analysis -syn keyword sqlFunction sa_remove_index_consultant_workload -syn keyword sqlFunction sa_reset_identity -syn keyword sqlFunction sa_resume_workload_capture -syn keyword sqlFunction sa_server_option -syn keyword sqlFunction sa_set_simulated_scale_factor -syn keyword sqlFunction sa_setremoteuser -syn keyword sqlFunction sa_setsubscription -syn keyword sqlFunction sa_start_recording_commits -syn keyword sqlFunction sa_start_workload_capture -syn keyword sqlFunction sa_statement_text -syn keyword sqlFunction sa_stop_index_consultant -syn keyword sqlFunction sa_stop_recording_commits -syn keyword sqlFunction sa_stop_workload_capture -syn keyword sqlFunction sa_sync -syn keyword sqlFunction sa_sync_sub -syn keyword sqlFunction sa_table_fragmentation -syn keyword sqlFunction sa_table_page_usage -syn keyword sqlFunction sa_table_stats -syn keyword sqlFunction sa_update_index_consultant_workload -syn keyword sqlFunction sa_validate -syn keyword sqlFunction sa_virtual_sysindex -syn keyword sqlFunction sa_virtual_sysixcol - -" sp_ procedures -syn keyword sqlFunction sp_addalias -syn keyword sqlFunction sp_addauditrecord -syn keyword sqlFunction sp_adddumpdevice -syn keyword sqlFunction sp_addgroup -syn keyword sqlFunction sp_addlanguage -syn keyword sqlFunction sp_addlogin -syn keyword sqlFunction sp_addmessage -syn keyword sqlFunction sp_addremotelogin -syn keyword sqlFunction sp_addsegment -syn keyword sqlFunction sp_addserver -syn keyword sqlFunction sp_addthreshold -syn keyword sqlFunction sp_addtype -syn keyword sqlFunction sp_adduser -syn keyword sqlFunction sp_auditdatabase -syn keyword sqlFunction sp_auditlogin -syn keyword sqlFunction sp_auditobject -syn keyword sqlFunction sp_auditoption -syn keyword sqlFunction sp_auditsproc -syn keyword sqlFunction sp_bindefault -syn keyword sqlFunction sp_bindmsg -syn keyword sqlFunction sp_bindrule -syn keyword sqlFunction sp_changedbowner -syn keyword sqlFunction sp_changegroup -syn keyword sqlFunction sp_checknames -syn keyword sqlFunction sp_checkperms -syn keyword sqlFunction sp_checkreswords -syn keyword sqlFunction sp_clearstats -syn keyword sqlFunction sp_column_privileges -syn keyword sqlFunction sp_columns -syn keyword sqlFunction sp_commonkey -syn keyword sqlFunction sp_configure -syn keyword sqlFunction sp_cursorinfo -syn keyword sqlFunction sp_databases -syn keyword sqlFunction sp_datatype_info -syn keyword sqlFunction sp_dboption -syn keyword sqlFunction sp_dbremap -syn keyword sqlFunction sp_depends -syn keyword sqlFunction sp_diskdefault -syn keyword sqlFunction sp_displaylogin -syn keyword sqlFunction sp_dropalias -syn keyword sqlFunction sp_dropdevice -syn keyword sqlFunction sp_dropgroup -syn keyword sqlFunction sp_dropkey -syn keyword sqlFunction sp_droplanguage -syn keyword sqlFunction sp_droplogin -syn keyword sqlFunction sp_dropmessage -syn keyword sqlFunction sp_dropremotelogin -syn keyword sqlFunction sp_dropsegment -syn keyword sqlFunction sp_dropserver -syn keyword sqlFunction sp_dropthreshold -syn keyword sqlFunction sp_droptype -syn keyword sqlFunction sp_dropuser -syn keyword sqlFunction sp_estspace -syn keyword sqlFunction sp_extendsegment -syn keyword sqlFunction sp_fkeys -syn keyword sqlFunction sp_foreignkey -syn keyword sqlFunction sp_getmessage -syn keyword sqlFunction sp_help -syn keyword sqlFunction sp_helpconstraint -syn keyword sqlFunction sp_helpdb -syn keyword sqlFunction sp_helpdevice -syn keyword sqlFunction sp_helpgroup -syn keyword sqlFunction sp_helpindex -syn keyword sqlFunction sp_helpjoins -syn keyword sqlFunction sp_helpkey -syn keyword sqlFunction sp_helplanguage -syn keyword sqlFunction sp_helplog -syn keyword sqlFunction sp_helpprotect -syn keyword sqlFunction sp_helpremotelogin -syn keyword sqlFunction sp_helpsegment -syn keyword sqlFunction sp_helpserver -syn keyword sqlFunction sp_helpsort -syn keyword sqlFunction sp_helptext -syn keyword sqlFunction sp_helpthreshold -syn keyword sqlFunction sp_helpuser -syn keyword sqlFunction sp_indsuspect -syn keyword sqlFunction sp_lock -syn keyword sqlFunction sp_locklogin -syn keyword sqlFunction sp_logdevice -syn keyword sqlFunction sp_login_environment -syn keyword sqlFunction sp_modifylogin -syn keyword sqlFunction sp_modifythreshold -syn keyword sqlFunction sp_monitor -syn keyword sqlFunction sp_password -syn keyword sqlFunction sp_pkeys -syn keyword sqlFunction sp_placeobject -syn keyword sqlFunction sp_primarykey -syn keyword sqlFunction sp_procxmode -syn keyword sqlFunction sp_recompile -syn keyword sqlFunction sp_remap -syn keyword sqlFunction sp_remote_columns -syn keyword sqlFunction sp_remote_exported_keys -syn keyword sqlFunction sp_remote_imported_keys -syn keyword sqlFunction sp_remote_pcols -syn keyword sqlFunction sp_remote_primary_keys -syn keyword sqlFunction sp_remote_procedures -syn keyword sqlFunction sp_remote_tables -syn keyword sqlFunction sp_remoteoption -syn keyword sqlFunction sp_rename -syn keyword sqlFunction sp_renamedb -syn keyword sqlFunction sp_reportstats -syn keyword sqlFunction sp_reset_tsql_environment -syn keyword sqlFunction sp_role -syn keyword sqlFunction sp_server_info -syn keyword sqlFunction sp_servercaps -syn keyword sqlFunction sp_serverinfo -syn keyword sqlFunction sp_serveroption -syn keyword sqlFunction sp_setlangalias -syn keyword sqlFunction sp_setreplicate -syn keyword sqlFunction sp_setrepproc -syn keyword sqlFunction sp_setreptable -syn keyword sqlFunction sp_spaceused -syn keyword sqlFunction sp_special_columns -syn keyword sqlFunction sp_sproc_columns -syn keyword sqlFunction sp_statistics -syn keyword sqlFunction sp_stored_procedures -syn keyword sqlFunction sp_syntax -syn keyword sqlFunction sp_table_privileges -syn keyword sqlFunction sp_tables -syn keyword sqlFunction sp_tsql_environment -syn keyword sqlFunction sp_tsql_feature_not_supported -syn keyword sqlFunction sp_unbindefault -syn keyword sqlFunction sp_unbindmsg -syn keyword sqlFunction sp_unbindrule -syn keyword sqlFunction sp_volchanged -syn keyword sqlFunction sp_who -syn keyword sqlFunction xp_scanf -syn keyword sqlFunction xp_sprintf - -" server functions -syn keyword sqlFunction col_length -syn keyword sqlFunction col_name -syn keyword sqlFunction index_col -syn keyword sqlFunction object_id -syn keyword sqlFunction object_name -syn keyword sqlFunction proc_role -syn keyword sqlFunction show_role -syn keyword sqlFunction xp_cmdshell -syn keyword sqlFunction xp_msver -syn keyword sqlFunction xp_read_file -syn keyword sqlFunction xp_real_cmdshell -syn keyword sqlFunction xp_real_read_file -syn keyword sqlFunction xp_real_sendmail -syn keyword sqlFunction xp_real_startmail -syn keyword sqlFunction xp_real_startsmtp -syn keyword sqlFunction xp_real_stopmail -syn keyword sqlFunction xp_real_stopsmtp -syn keyword sqlFunction xp_real_write_file -syn keyword sqlFunction xp_scanf -syn keyword sqlFunction xp_sendmail -syn keyword sqlFunction xp_sprintf -syn keyword sqlFunction xp_startmail -syn keyword sqlFunction xp_startsmtp -syn keyword sqlFunction xp_stopmail -syn keyword sqlFunction xp_stopsmtp -syn keyword sqlFunction xp_write_file - -" http functions -syn keyword sqlFunction http_header http_variable -syn keyword sqlFunction next_http_header next_http_response_header next_http_variable -syn keyword sqlFunction sa_set_http_header sa_set_http_option -syn keyword sqlFunction sa_http_variable_info sa_http_header_info - -" http functions 9.0.1 -syn keyword sqlFunction http_encode http_decode -syn keyword sqlFunction html_encode html_decode - -" XML function support -syn keyword sqlFunction openxml xmlelement xmlforest xmlgen xmlconcat xmlagg -syn keyword sqlFunction xmlattributes - -" Spatial Compatibility Functions -syn keyword sqlFunction ST_BdMPolyFromText -syn keyword sqlFunction ST_BdMPolyFromWKB -syn keyword sqlFunction ST_BdPolyFromText -syn keyword sqlFunction ST_BdPolyFromWKB -syn keyword sqlFunction ST_CPolyFromText -syn keyword sqlFunction ST_CPolyFromWKB -syn keyword sqlFunction ST_CircularFromTxt -syn keyword sqlFunction ST_CircularFromWKB -syn keyword sqlFunction ST_CompoundFromTxt -syn keyword sqlFunction ST_CompoundFromWKB -syn keyword sqlFunction ST_GeomCollFromTxt -syn keyword sqlFunction ST_GeomCollFromWKB -syn keyword sqlFunction ST_GeomFromText -syn keyword sqlFunction ST_GeomFromWKB -syn keyword sqlFunction ST_LineFromText -syn keyword sqlFunction ST_LineFromWKB -syn keyword sqlFunction ST_MCurveFromText -syn keyword sqlFunction ST_MCurveFromWKB -syn keyword sqlFunction ST_MLineFromText -syn keyword sqlFunction ST_MLineFromWKB -syn keyword sqlFunction ST_MPointFromText -syn keyword sqlFunction ST_MPointFromWKB -syn keyword sqlFunction ST_MPolyFromText -syn keyword sqlFunction ST_MPolyFromWKB -syn keyword sqlFunction ST_MSurfaceFromTxt -syn keyword sqlFunction ST_MSurfaceFromWKB -syn keyword sqlFunction ST_OrderingEquals -syn keyword sqlFunction ST_PointFromText -syn keyword sqlFunction ST_PointFromWKB -syn keyword sqlFunction ST_PolyFromText -syn keyword sqlFunction ST_PolyFromWKB -" Spatial Structural Methods -syn keyword sqlFunction ST_CoordDim -syn keyword sqlFunction ST_CurveN -syn keyword sqlFunction ST_Dimension -syn keyword sqlFunction ST_EndPoint -syn keyword sqlFunction ST_ExteriorRing -syn keyword sqlFunction ST_GeometryN -syn keyword sqlFunction ST_GeometryType -syn keyword sqlFunction ST_InteriorRingN -syn keyword sqlFunction ST_Is3D -syn keyword sqlFunction ST_IsClosed -syn keyword sqlFunction ST_IsEmpty -syn keyword sqlFunction ST_IsMeasured -syn keyword sqlFunction ST_IsRing -syn keyword sqlFunction ST_IsSimple -syn keyword sqlFunction ST_IsValid -syn keyword sqlFunction ST_NumCurves -syn keyword sqlFunction ST_NumGeometries -syn keyword sqlFunction ST_NumInteriorRing -syn keyword sqlFunction ST_NumPoints -syn keyword sqlFunction ST_PointN -syn keyword sqlFunction ST_StartPoint -"Spatial Computation -syn keyword sqlFunction ST_Length -syn keyword sqlFunction ST_Area -syn keyword sqlFunction ST_Centroid -syn keyword sqlFunction ST_Area -syn keyword sqlFunction ST_Centroid -syn keyword sqlFunction ST_IsWorld -syn keyword sqlFunction ST_Perimeter -syn keyword sqlFunction ST_PointOnSurface -syn keyword sqlFunction ST_Distance -" Spatial Input/Output -syn keyword sqlFunction ST_AsBinary -syn keyword sqlFunction ST_AsGML -syn keyword sqlFunction ST_AsGeoJSON -syn keyword sqlFunction ST_AsSVG -syn keyword sqlFunction ST_AsSVGAggr -syn keyword sqlFunction ST_AsText -syn keyword sqlFunction ST_AsWKB -syn keyword sqlFunction ST_AsWKT -syn keyword sqlFunction ST_AsXML -syn keyword sqlFunction ST_GeomFromBinary -syn keyword sqlFunction ST_GeomFromShape -syn keyword sqlFunction ST_GeomFromText -syn keyword sqlFunction ST_GeomFromWKB -syn keyword sqlFunction ST_GeomFromWKT -syn keyword sqlFunction ST_GeomFromXML -" Spatial Cast Methods -syn keyword sqlFunction ST_CurvePolyToPoly -syn keyword sqlFunction ST_CurveToLine -syn keyword sqlFunction ST_ToCircular -syn keyword sqlFunction ST_ToCompound -syn keyword sqlFunction ST_ToCurve -syn keyword sqlFunction ST_ToCurvePoly -syn keyword sqlFunction ST_ToGeomColl -syn keyword sqlFunction ST_ToLineString -syn keyword sqlFunction ST_ToMultiCurve -syn keyword sqlFunction ST_ToMultiLine -syn keyword sqlFunction ST_ToMultiPoint -syn keyword sqlFunction ST_ToMultiPolygon -syn keyword sqlFunction ST_ToMultiSurface -syn keyword sqlFunction ST_ToPoint -syn keyword sqlFunction ST_ToPolygon -syn keyword sqlFunction ST_ToSurface - -" Array functions 16.x -syn keyword sqlFunction array array_agg array_max_cardinality trim_array -syn keyword sqlFunction error_line error_message error_procedure -syn keyword sqlFunction error_sqlcode error_sqlstate error_stack_trace - - -" keywords -syn keyword sqlKeyword absolute accent access account action active activate add address admin -syn keyword sqlKeyword aes_decrypt after aggregate algorithm allow_dup_row allow allowed alter -syn keyword sqlKeyword always and angular ansi_substring any as append apply -syn keyword sqlKeyword arbiter array asc ascii ase -syn keyword sqlKeyword assign at atan2 atomic attended -syn keyword sqlKeyword audit auditing authentication authorization axis -syn keyword sqlKeyword autoincrement autostop batch bcp before -syn keyword sqlKeyword between bit_and bit_length bit_or bit_substr bit_xor -syn keyword sqlKeyword blank blanks block -syn keyword sqlKeyword both bottom unbounded breaker bufferpool -syn keyword sqlKeyword build bulk by byte bytes cache calibrate calibration -syn keyword sqlKeyword cancel capability cardinality cascade cast -syn keyword sqlKeyword catalog catch ceil change changes char char_convert -syn keyword sqlKeyword check checkpointlog checksum class classes client cmp -syn keyword sqlKeyword cluster clustered collation -syn keyword sqlKeyword column columns -syn keyword sqlKeyword command comments committed commitid comparisons -syn keyword sqlKeyword compatible component compressed compute computes -syn keyword sqlKeyword concat configuration confirm conflict connection -syn keyword sqlKeyword console consolidate consolidated -syn keyword sqlKeyword constraint constraints content -syn keyword sqlKeyword convert coordinate coordinator copy count count_set_bits -syn keyword sqlKeyword crc createtime critical cross cube cume_dist -syn keyword sqlKeyword current cursor data data database -syn keyword sqlKeyword current_timestamp current_user cycle -syn keyword sqlKeyword databases datatype dba dbfile -syn keyword sqlKeyword dbspace dbspaces dbspacename debug decoupled -syn keyword sqlKeyword decrypted default defaults default_dbspace deferred -syn keyword sqlKeyword definer definition -syn keyword sqlKeyword delay deleting delimited dependencies desc -syn keyword sqlKeyword description deterministic directory -syn keyword sqlKeyword disable disabled disallow distinct disksandbox disk_sandbox -syn keyword sqlKeyword dn do domain download duplicate -syn keyword sqlKeyword dsetpass dttm dynamic each earth editproc effective ejb -syn keyword sqlKeyword elimination ellipsoid else elseif -syn keyword sqlKeyword email empty enable encapsulated encrypted encryption end -syn keyword sqlKeyword encoding endif engine environment erase error errors escape escapes event -syn keyword sqlKeyword event_parameter every exception exclude excluded exclusive exec -syn keyword sqlKeyword existing exists expanded expiry express exprtype extended_property -syn keyword sqlKeyword external externlogin factor failover false -syn keyword sqlKeyword fastfirstrow feature fieldproc file files filler -syn keyword sqlKeyword fillfactor final finish first first_keyword first_value -syn keyword sqlKeyword flattening -syn keyword sqlKeyword following force foreign format forjson forxml forxml_sep fp frame -syn keyword sqlKeyword free freepage french fresh full function -syn keyword sqlKeyword gb generic get_bit go global grid -syn keyword sqlKeyword group handler hash having header hexadecimal -syn keyword sqlKeyword hidden high history hg hng hold holdlock host -syn keyword sqlKeyword hours http_body http_session_timeout id identified identity ignore -syn keyword sqlKeyword ignore_dup_key ignore_dup_row immediate -syn keyword sqlKeyword in inactiv inactive inactivity included increment incremental -syn keyword sqlKeyword index index_enabled index_lparen indexonly info information -syn keyword sqlKeyword inheritance inline inner inout insensitive inserting -syn keyword sqlKeyword instead -syn keyword sqlKeyword internal intersection into introduced inverse invoker -syn keyword sqlKeyword iq is isolation -syn keyword sqlKeyword jar java java_location java_main_userid java_vm_options -syn keyword sqlKeyword jconnect jdk join json kb key keys keep language last -syn keyword sqlKeyword last_keyword last_value lateral latitude -syn keyword sqlKeyword ld ldap left len linear lf ln level like -syn keyword sqlKeyword limit local location log -syn keyword sqlKeyword logging logical login logscan long longitude low lru ls -syn keyword sqlKeyword main major manage manual mark master -syn keyword sqlKeyword match matched materialized max maxvalue maximum mb measure median membership -syn keyword sqlKeyword merge metadata methods migrate minimum minor minutes minvalue mirror -syn keyword sqlKeyword mode modify monitor move mru multiplex -syn keyword sqlKeyword name named namespaces national native natural new next nextval -syn keyword sqlKeyword ngram no noholdlock nolock nonclustered none normal not -syn keyword sqlKeyword notify null nullable_constant nulls -syn keyword sqlKeyword object objects oem_string of off offline offset olap -syn keyword sqlKeyword old on online only openstring operator -syn keyword sqlKeyword optimization optimizer option -syn keyword sqlKeyword or order ordinality organization others out outer over owner -syn keyword sqlKeyword package packetsize padding page pages -syn keyword sqlKeyword paglock parallel parameter parent part partial -syn keyword sqlKeyword partition partitions partner password path pctfree -syn keyword sqlKeyword permissions perms plan planar policy polygon populate port postfilter preceding -syn keyword sqlKeyword precisionprefetch prefilter prefix preserve preview previous -syn keyword sqlKeyword primary prior priority priqty private privilege privileges procedure profile profiling -syn keyword sqlKeyword property_is_cumulative property_is_numeric public publication publish publisher -syn keyword sqlKeyword quiesce quote quotes range readclientfile readcommitted reader readfile readonly -syn keyword sqlKeyword readpast readuncommitted readwrite rebuild -syn keyword sqlKeyword received recompile recover recursive references -syn keyword sqlKeyword referencing regex regexp regexp_substr relative relocate -syn keyword sqlKeyword rename repeatable repeatableread replicate replication -syn keyword sqlKeyword requests request_timeout required rereceive resend reserve reset -syn keyword sqlKeyword resizing resolve resource respect restart -syn keyword sqlKeyword restrict result retain retries -syn keyword sqlKeyword returns reverse right role roles -syn keyword sqlKeyword rollup root row row_number rowlock rows rowtype -syn keyword sqlKeyword sa_index_hash sa_internal_fk_verify sa_internal_termbreak -syn keyword sqlKeyword sa_order_preserving_hash sa_order_preserving_hash_big sa_order_preserving_hash_prefix -syn keyword sqlKeyword sa_file_free_pages sa_internal_type_from_catalog sa_internal_valid_hash -syn keyword sqlKeyword sa_internal_validate_value sa_json_element -syn keyword sqlKeyword scale schedule schema scope script scripted scroll search seconds secqty security -syn keyword sqlKeyword semi send sensitive sent sequence serializable -syn keyword sqlKeyword server severity session set_bit set_bits sets -syn keyword sqlKeyword shapefile share side simple since site size skip -syn keyword sqlKeyword snap snapshot soapheader soap_header -syn keyword sqlKeyword spatial split some sorted_data -syn keyword sqlKeyword sql sqlcode sqlid sqlflagger sqlstate sqrt square -syn keyword sqlKeyword stacker stale state statement statistics status stddev_pop stddev_samp -syn keyword sqlKeyword stemmer stogroup stoplist storage store -syn keyword sqlKeyword strip stripesizekb striping subpages subscribe subscription -syn keyword sqlKeyword subtransaction suser_id suser_name suspend synchronization -syn keyword sqlKeyword syntax_error table tables tablock -syn keyword sqlKeyword tablockx target tb temp template temporary term then ties -syn keyword sqlKeyword timezone timeout tls to to_char to_nchar tolerance top -syn keyword sqlKeyword trace traced_plan tracing -syn keyword sqlKeyword transfer transform transaction transactional treat tries -syn keyword sqlKeyword true try tsequal type tune uncommitted unconditionally -syn keyword sqlKeyword unenforced unicode unique unistr unit unknown unlimited unload -syn keyword sqlKeyword unpartition unquiesce updatetime updating updlock upgrade upload -syn keyword sqlKeyword upper usage use user -syn keyword sqlKeyword using utc utilities validproc -syn keyword sqlKeyword value values varchar variable -syn keyword sqlKeyword varying var_pop var_samp vcat verbosity -syn keyword sqlKeyword verify versions view virtual wait -syn keyword sqlKeyword warning wd web when where with with_auto -syn keyword sqlKeyword with_auto with_cube with_rollup without -syn keyword sqlKeyword with_lparen within word work workload write writefile -syn keyword sqlKeyword writeclientfile writer writers writeserver xlock -syn keyword sqlKeyword war xml zeros zone -" XML -syn keyword sqlKeyword raw auto elements explicit -" HTTP support -syn keyword sqlKeyword authorization secure url service next_soap_header -" HTTP 9.0.2 new procedure keywords -syn keyword sqlKeyword namespace certificate certificates clientport proxy trusted_certificates_file -" OLAP support 9.0.0 -syn keyword sqlKeyword covar_pop covar_samp corr regr_slope regr_intercept -syn keyword sqlKeyword regr_count regr_r2 regr_avgx regr_avgy -syn keyword sqlKeyword regr_sxx regr_syy regr_sxy - -" Alternate keywords -syn keyword sqlKeyword character dec options proc reference -syn keyword sqlKeyword subtrans tran syn keyword - -" Login Mode Options -syn keyword sqlKeywordLogin standard integrated kerberos LDAPUA -syn keyword sqlKeywordLogin cloudadmin mixed - -" Spatial Predicates -syn keyword sqlKeyword ST_Contains -syn keyword sqlKeyword ST_ContainsFilter -syn keyword sqlKeyword ST_CoveredBy -syn keyword sqlKeyword ST_CoveredByFilter -syn keyword sqlKeyword ST_Covers -syn keyword sqlKeyword ST_CoversFilter -syn keyword sqlKeyword ST_Crosses -syn keyword sqlKeyword ST_Disjoint -syn keyword sqlKeyword ST_Equals -syn keyword sqlKeyword ST_EqualsFilter -syn keyword sqlKeyword ST_Intersects -syn keyword sqlKeyword ST_IntersectsFilter -syn keyword sqlKeyword ST_IntersectsRect -syn keyword sqlKeyword ST_OrderingEquals -syn keyword sqlKeyword ST_Overlaps -syn keyword sqlKeyword ST_Relate -syn keyword sqlKeyword ST_Touches -syn keyword sqlKeyword ST_Within -syn keyword sqlKeyword ST_WithinFilter -" Spatial Set operations -syn keyword sqlKeyword ST_Affine -syn keyword sqlKeyword ST_Boundary -syn keyword sqlKeyword ST_Buffer -syn keyword sqlKeyword ST_ConvexHull -syn keyword sqlKeyword ST_ConvexHullAggr -syn keyword sqlKeyword ST_Difference -syn keyword sqlKeyword ST_Intersection -syn keyword sqlKeyword ST_IntersectionAggr -syn keyword sqlKeyword ST_SymDifference -syn keyword sqlKeyword ST_Union -syn keyword sqlKeyword ST_UnionAggr -" Spatial Bounds -syn keyword sqlKeyword ST_Envelope -syn keyword sqlKeyword ST_EnvelopeAggr -syn keyword sqlKeyword ST_Lat -syn keyword sqlKeyword ST_LatMax -syn keyword sqlKeyword ST_LatMin -syn keyword sqlKeyword ST_Long -syn keyword sqlKeyword ST_LongMax -syn keyword sqlKeyword ST_LongMin -syn keyword sqlKeyword ST_M -syn keyword sqlKeyword ST_MMax -syn keyword sqlKeyword ST_MMin -syn keyword sqlKeyword ST_Point -syn keyword sqlKeyword ST_X -syn keyword sqlKeyword ST_XMax -syn keyword sqlKeyword ST_XMin -syn keyword sqlKeyword ST_Y -syn keyword sqlKeyword ST_YMax -syn keyword sqlKeyword ST_YMin -syn keyword sqlKeyword ST_Z -syn keyword sqlKeyword ST_ZMax -syn keyword sqlKeyword ST_ZMin -" Spatial Collection Aggregates -syn keyword sqlKeyword ST_GeomCollectionAggr -syn keyword sqlKeyword ST_LineStringAggr -syn keyword sqlKeyword ST_MultiCurveAggr -syn keyword sqlKeyword ST_MultiLineStringAggr -syn keyword sqlKeyword ST_MultiPointAggr -syn keyword sqlKeyword ST_MultiPolygonAggr -syn keyword sqlKeyword ST_MultiSurfaceAggr -syn keyword sqlKeyword ST_Perimeter -syn keyword sqlKeyword ST_PointOnSurface -" Spatial SRS -syn keyword sqlKeyword ST_CompareWKT -syn keyword sqlKeyword ST_FormatWKT -syn keyword sqlKeyword ST_ParseWKT -syn keyword sqlKeyword ST_TransformGeom -syn keyword sqlKeyword ST_GeometryTypeFromBaseType -syn keyword sqlKeyword ST_SnapToGrid -syn keyword sqlKeyword ST_Transform -syn keyword sqlKeyword ST_SRID -syn keyword sqlKeyword ST_SRIDFromBaseType -syn keyword sqlKeyword ST_LoadConfigurationData -" Spatial Indexes -syn keyword sqlKeyword ST_LinearHash -syn keyword sqlKeyword ST_LinearUnHash - -syn keyword sqlOperator in any some all between exists -syn keyword sqlOperator like escape not is and or -syn keyword sqlOperator minus -syn keyword sqlOperator prior distinct unnest - -syn keyword sqlStatement allocate alter attach backup begin break call case catch -syn keyword sqlStatement checkpoint clear close comment commit configure connect -syn keyword sqlStatement continue create deallocate declare delete describe -syn keyword sqlStatement detach disconnect drop except execute exit explain fetch -syn keyword sqlStatement for forward from get goto grant help if include -syn keyword sqlStatement input insert install intersect leave load lock loop -syn keyword sqlStatement message open output parameters passthrough -syn keyword sqlStatement prepare print put raiserror read readtext refresh release -syn keyword sqlStatement remote remove reorganize resignal restore resume -syn keyword sqlStatement return revoke rollback save savepoint select -syn keyword sqlStatement set setuser signal start stop synchronize -syn keyword sqlStatement system trigger truncate try union unload update -syn keyword sqlStatement validate waitfor whenever while window writetext - - -syn keyword sqlType char nchar long varchar nvarchar text ntext uniqueidentifierstr xml -syn keyword sqlType bigint bit decimal double varbit -syn keyword sqlType float int integer numeric -syn keyword sqlType smallint tinyint real -syn keyword sqlType money smallmoney -syn keyword sqlType date datetime datetimeoffset smalldatetime time timestamp -syn keyword sqlType binary image varray varbinary uniqueidentifier -syn keyword sqlType unsigned -" Spatial types -syn keyword sqlType st_geometry st_point st_curve st_surface st_geomcollection -syn keyword sqlType st_linestring st_circularstring st_compoundcurve -syn keyword sqlType st_curvepolygon st_polygon -syn keyword sqlType st_multipoint st_multicurve st_multisurface -syn keyword sqlType st_multilinestring st_multipolygon - -syn keyword sqlOption Allow_nulls_by_default -syn keyword sqlOption Allow_read_client_file -syn keyword sqlOption Allow_snapshot_isolation -syn keyword sqlOption Allow_write_client_file -syn keyword sqlOption Ansi_blanks -syn keyword sqlOption Ansi_close_cursors_on_rollback -syn keyword sqlOption Ansi_permissions -syn keyword sqlOption Ansi_substring -syn keyword sqlOption Ansi_update_constraints -syn keyword sqlOption Ansinull -syn keyword sqlOption Auditing -syn keyword sqlOption Auditing_options -syn keyword sqlOption Auto_commit_on_create_local_temp_index -syn keyword sqlOption Background_priority -syn keyword sqlOption Blocking -syn keyword sqlOption Blocking_others_timeout -syn keyword sqlOption Blocking_timeout -syn keyword sqlOption Chained -syn keyword sqlOption Checkpoint_time -syn keyword sqlOption Cis_option -syn keyword sqlOption Cis_rowset_size -syn keyword sqlOption Close_on_endtrans -syn keyword sqlOption Collect_statistics_on_dml_updates -syn keyword sqlOption Conn_auditing -syn keyword sqlOption Connection_authentication -syn keyword sqlOption Continue_after_raiserror -syn keyword sqlOption Conversion_error -syn keyword sqlOption Cooperative_commit_timeout -syn keyword sqlOption Cooperative_commits -syn keyword sqlOption Database_authentication -syn keyword sqlOption Date_format -syn keyword sqlOption Date_order -syn keyword sqlOption db_publisher -syn keyword sqlOption Debug_messages -syn keyword sqlOption Dedicated_task -syn keyword sqlOption Default_dbspace -syn keyword sqlOption Default_timestamp_increment -syn keyword sqlOption Delayed_commit_timeout -syn keyword sqlOption Delayed_commits -syn keyword sqlOption Divide_by_zero_error -syn keyword sqlOption Escape_character -syn keyword sqlOption Exclude_operators -syn keyword sqlOption Extended_join_syntax -syn keyword sqlOption Extern_login_credentials -syn keyword sqlOption Fire_triggers -syn keyword sqlOption First_day_of_week -syn keyword sqlOption For_xml_null_treatment -syn keyword sqlOption Force_view_creation -syn keyword sqlOption Global_database_id -syn keyword sqlOption Http_session_timeout -syn keyword sqlOption Http_connection_pool_basesize -syn keyword sqlOption Http_connection_pool_timeout -syn keyword sqlOption Integrated_server_name -syn keyword sqlOption Isolation_level -syn keyword sqlOption Java_class_path -syn keyword sqlOption Java_location -syn keyword sqlOption Java_main_userid -syn keyword sqlOption Java_vm_options -syn keyword sqlOption Lock_rejected_rows -syn keyword sqlOption Log_deadlocks -syn keyword sqlOption Login_mode -syn keyword sqlOption Login_procedure -syn keyword sqlOption Materialized_view_optimization -syn keyword sqlOption Max_client_statements_cached -syn keyword sqlOption Max_cursor_count -syn keyword sqlOption Max_hash_size -syn keyword sqlOption Max_plans_cached -syn keyword sqlOption Max_priority -syn keyword sqlOption Max_query_tasks -syn keyword sqlOption Max_recursive_iterations -syn keyword sqlOption Max_statement_count -syn keyword sqlOption Max_temp_space -syn keyword sqlOption Min_password_length -syn keyword sqlOption Min_role_admins -syn keyword sqlOption Nearest_century -syn keyword sqlOption Non_keywords -syn keyword sqlOption Odbc_describe_binary_as_varbinary -syn keyword sqlOption Odbc_distinguish_char_and_varchar -syn keyword sqlOption Oem_string -syn keyword sqlOption On_charset_conversion_failure -syn keyword sqlOption On_tsql_error -syn keyword sqlOption Optimization_goal -syn keyword sqlOption Optimization_level -syn keyword sqlOption Optimization_workload -syn keyword sqlOption Pinned_cursor_percent_of_cache -syn keyword sqlOption Post_login_procedure -syn keyword sqlOption Precision -syn keyword sqlOption Prefetch -syn keyword sqlOption Preserve_source_format -syn keyword sqlOption Prevent_article_pkey_update -syn keyword sqlOption Priority -syn keyword sqlOption Progress_messages -syn keyword sqlOption Query_mem_timeout -syn keyword sqlOption Quoted_identifier -syn keyword sqlOption Read_past_deleted -syn keyword sqlOption Recovery_time -syn keyword sqlOption Remote_idle_timeout -syn keyword sqlOption Replicate_all -syn keyword sqlOption Request_timeout -syn keyword sqlOption Reserved_keywords -syn keyword sqlOption Return_date_time_as_string -syn keyword sqlOption Rollback_on_deadlock -syn keyword sqlOption Row_counts -syn keyword sqlOption Scale -syn keyword sqlOption Secure_feature_key -syn keyword sqlOption Sort_collation -syn keyword sqlOption Sql_flagger_error_level -syn keyword sqlOption Sql_flagger_warning_level -syn keyword sqlOption String_rtruncation -syn keyword sqlOption st_geometry_asbinary_format -syn keyword sqlOption st_geometry_astext_format -syn keyword sqlOption st_geometry_asxml_format -syn keyword sqlOption st_geometry_describe_type -syn keyword sqlOption st_geometry_interpolation -syn keyword sqlOption st_geometry_on_invalid -syn keyword sqlOption Subsume_row_locks -syn keyword sqlOption Suppress_tds_debugging -syn keyword sqlOption Synchronize_mirror_on_commit -syn keyword sqlOption Tds_empty_string_is_null -syn keyword sqlOption Temp_space_limit_check -syn keyword sqlOption Time_format -syn keyword sqlOption Time_zone_adjustment -syn keyword sqlOption Timestamp_format -syn keyword sqlOption Timestamp_with_time_zone_format -syn keyword sqlOption Truncate_timestamp_values -syn keyword sqlOption Tsql_outer_joins -syn keyword sqlOption Tsql_variables -syn keyword sqlOption Updatable_statement_isolation -syn keyword sqlOption Update_statistics -syn keyword sqlOption Upgrade_database_capability -syn keyword sqlOption User_estimates -syn keyword sqlOption Uuid_has_hyphens -syn keyword sqlOption Verify_password_function -syn keyword sqlOption Wait_for_commit -syn keyword sqlOption Webservice_namespace_host -syn keyword sqlOption Webservice_sessionid_name - -" Strings and characters: -syn region sqlString start=+"+ end=+"+ contains=@Spell -syn region sqlString start=+'+ end=+'+ contains=@Spell - -" Numbers: -syn match sqlNumber "-\=\<\d*\.\=[0-9_]\>" - -" Comments: -syn region sqlDashComment start=/--/ end=/$/ contains=@Spell -syn region sqlSlashComment start=/\/\// end=/$/ contains=@Spell -syn region sqlMultiComment start="/\*" end="\*/" contains=sqlMultiComment,@Spell -syn cluster sqlComment contains=sqlDashComment,sqlSlashComment,sqlMultiComment,@Spell -syn sync ccomment sqlComment -syn sync ccomment sqlDashComment -syn sync ccomment sqlSlashComment - -hi def link sqlDashComment Comment -hi def link sqlSlashComment Comment -hi def link sqlMultiComment Comment -hi def link sqlNumber Number -hi def link sqlOperator Operator -hi def link sqlSpecial Special -hi def link sqlKeyword Keyword -hi def link sqlStatement Statement -hi def link sqlString String -hi def link sqlType Type -hi def link sqlFunction Function -hi def link sqlOption PreProc - -let b:current_syntax = "sqlanywhere" - -" vim:sw=4: - -endif |