! Syntax highlighting patterns for Sybase SQL
!
! Version: 0.1, March 8, 2000
! Maintainer: Andrew Hood <ahood@westpac.com.au>
! Original author: Andrew Hood <ahood@westpac.com.au>
!
! INTRODUCTION
!
! These patterns use the new regular expressions as available in NEdit version
! 5.1 and up. They will not work in older versions of NEdit. The patterns are
! based on Sybase 11.0.3 and there is no guarantee that they'll work correctly
! for other versions (there even is no guarantee they'll work correctly for this
! version:). The references for the syntax are:
!
! Sybase SQL Server(tm) Reference Manual
!   Document ID: 32401-01-1100, 32401-01-1100
!
! INSTALLATION
!
! Load this pattern by starting nedit with:
!
!       nedit -import <name of this file>
!
! Then, check that the patterns were loaded correctly, and choose Save Defaults
! from the Preferences menu.  The new patterns will now be incorporated into
! your own .nedit file, so the next time you start NEdit, you will no longer
! need to use -import. These comments will not appear in your ~/.nedit
!

nedit.fileVersion: 5.1
nedit.highlightPatterns: 	SQL:1:0{\n\
		keywords:"(?i(end if;|<(create|replace|begin|end|function|return|fetch|open|close|is|notfound|cursor|if|else|then|is|in|when|others|grant|on|to|exception|show|out|pragma|as|package|select|insert|delete|update|declare)>))":::Preprocessor1::\n\
		comment1:"--":"$"::Comment::\n\
		comment2:"/\\*":"\\*/"::Comment::\n\
		data types:"<(?i((char|nchar|nvarchar|varchar|varchar2)\\([0-9]*\\)|binary|bit|boolean|box|datetime|float|image|int[0-9]*|money|number\\([0-9]*\\)|point|real|smalldatetime|smallint|smallmoney|sysname|text|timestamp|tinyint|varbinary))>":::Storage Type::\n\
		sqstring:"'":"'"::String::\n\
		dqstring:"""":""""::String::\n\
		systemfunctions:"""<(?i(col_name|col_length|data_pgs|datalength|db_id|db_name|host_id|host_name|index_col|isnull|object_id|object_name|reserved_pgs|rowcnt|suser_id|suser_namem|used_pgs|user_id|user_name|valid_name))\\s*(?=[(])>":::Subroutine::\n\
		mathfunctions:"<(?i(abs|acos|asin|atan|atn2|ceiling|cos|cot|degrees|exp|floor|log|log10|pi|power|radians|rand|round|sign|sin|sqrt|tan))>\\s*(?=[(])":::Subroutine1::\n\
		stringfunctions:"<(?i(ascii|char|charindex|char_length|difference|lower|ltrim|patindex|replicate|reverse|right|rtrim|soundex|space|str|stuff|substring|textptr|textvalid|upper))>\\s*(?=[(])":::Subroutine1::\n\
		datefunctions:"<(?i(convert|getdate|datename|datepart|datediff|dateadd))>\\s*(?=[(])":::Subroutine1::\n\
		reservedwords:",|%|\\<|\\>|:=|=|<(?i(add|all|allow_dup_row|alter|after|and|any|as|asc|avg|begin|between|break|browse|bulk|by|char_convert|checkalloc|checkcatalog|checkdb|checkpoint|checktable|clustered|commit|compute|confirm|continue|cntrltype|contiguous|controlrow|convert|count|create|database|dbcc|dbrepair|declare|default|delete|desc|disk|distinct|drop|dummy|dump|else|end|errlvl|errorexit|except|exec|execute|exists|exit|fast|fillfactor|fix|fix_text|for|from|full|global|goto|grant|group|having|holdlock|if|ignore_dup_key|ignore_dup_row|in|index|indexalloc|init|insert|intersect|into|is|kill|like|lineno|load|max|min|mirror|mirrorexit|mode|name|nofix|no_log|nonclustered|noserial|not|no_truncate|null|off|offsets|on|once|optimized|or|order|over|override|perm|permanent|physname|plan|prepare|primary|print|proc|procedure|processexit|public|raiserror|readtext|recompile|reconfigure|refit|reindex|reinit|remirror|remove|retain|return|revoke|rollback|rule|secondary|select|serial|set|setuser|shutdown|side|size|sorted_data|statistics|sum|syb_terminate|table|tablealloc|tape|temp|temporary|textsize|to|tran|transaction|trigger|truncate|truncate_only|tsequal|union|unique|update|unmirror|use|using|values|vdevno|view|vstart|waitfor|where|while|with|writes|writetext))>":::Keyword::\n\
	}
nedit.languageModes: 	SQL:.sql:"^[ \\t]*#[ \\t]*!.*(sql)":::::