" Vim syntax file
" Language: sqlj
" Maintainer: Andreas Fischbach <[email protected]>
" This file is based on sql.vim && java.vim (thanx)
" with a handful of additional sql words and still
" a subset of whatever standard
" Last change: 31th Dec 2001

" au BufNewFile,BufRead *.sqlj so $VIM/syntax/sqlj.vim

" Remove any old syntax stuff hanging around
if version < 600
syntax clear
elseif exists("b:current_syntax")
finish
endif

" Read the Java syntax to start with
source <sfile>:p:h/java.vim

" SQLJ extentions
" The SQL reserved words, defined as keywords.

syn case ignore
syn keyword sqljSpecial null

syn keyword sqljKeyword access add as asc by check cluster column
syn keyword sqljKeyword compress connect current decimal default
syn keyword sqljKeyword desc else exclusive file for from group
syn keyword sqljKeyword having identified immediate increment index
syn keyword sqljKeyword initial into is level maxextents mode modify
syn keyword sqljKeyword nocompress nowait of offline on online start
syn keyword sqljKeyword successful synonym table then to trigger uid
syn keyword sqljKeyword unique user validate values view whenever
syn keyword sqljKeyword where with option order pctfree privileges
syn keyword sqljKeyword public resource row rowlabel rownum rows
syn keyword sqljKeyword session share size smallint

syn keyword sqljKeyword fetch database context iterator field join
syn keyword sqljKeyword foreign outer inner isolation left right
syn keyword sqljKeyword match primary key

syn keyword sqljOperator not and or
syn keyword sqljOperator in any some all between exists
syn keyword sqljOperator like escape
syn keyword sqljOperator union intersect minus
syn keyword sqljOperator prior distinct
syn keyword sqljOperator sysdate

syn keyword sqljOperator max min avg sum count hex

syn keyword sqljStatement alter analyze audit comment commit create
syn keyword sqljStatement delete drop explain grant insert lock noaudit
syn keyword sqljStatement rename revoke rollback savepoint select set
syn keyword sqljStatement truncate update begin work

syn keyword sqljType char character date long raw mlslabel number
syn keyword sqljType rowid varchar varchar2 float integer

syn keyword sqljType byte text serial


" Strings and characters:
syn region sqljString start=+"+ skip=+\\\\\|\\"+ end=+"+
syn region sqljString start=+'+ skip=+\\\\\|\\"+ end=+'+

" Numbers:
syn match sqljNumber "-\=\<\d*\.\=[0-9_]\>"

" PreProc
syn match sqljPre "#sql"

" Comments:
syn region sqljComment start="/\*" end="\*/"
syn match sqlComment "--.*"

syn sync ccomment sqljComment

if version >= 508 || !exists("did_sqlj_syn_inits")
if version < 508
let did_sqlj_syn_inits = 1
command! -nargs=+ HiLink hi link <args>
else
command! -nargs=+ HiLink hi def link <args>
endif

" The default methods for highlighting. Can be overridden later.
HiLink sqljComment Comment
HiLink sqljKeyword sqljSpecial
HiLink sqljNumber Number
HiLink sqljOperator sqljStatement
HiLink sqljSpecial Special
HiLink sqljStatement Statement
HiLink sqljString String
HiLink sqljType Type
HiLink sqljPre PreProc

delcommand HiLink
endif

let b:current_syntax = "sqlj"