<!DOCTYPE Highlight>
<Highlight wildcards="*.sql" name="DB2/SQL">

 <Items>
  <Text                style=""   color="#000000" />
  <Keyword             style=""   color="#0000ff" />
  <String              style=""   color="#008000" />
  <Char                style=""   color="#ff00ff" />
  <Memo                style="i"  color="#ff0000" />
  <EscapedChar   style=""  color="#F08050" />
 </Items>

 <Break>

  <normal>
   <citem item="" regexp="--.*"        mode="until, include" lineEndContent="normal" />
   <citem item="" regexp="/\*"         mode="until, include" lineEndContent="multiLineComment" />
   <citem item="" regexp="'"           mode="until, include" lineEndContent="string2" />
   <citem item="" regexp="$"           mode="until" />
  </normal>

  <string1>
   <citem item="" regexp="([^&quot;\\]|\\.)+" />
   <citem item="" regexp="&quot;" mode="until, exclude, allowfull" />
   <citem item="" regexp="&quot;" lineEndContent="normal" />
  </string1>

  <string2>
   <citem item="" regexp="([^'\\]|\\.)+" />
   <citem item="" regexp="'" mode="until, exclude, allowfull" />
   <citem item="" regexp="'" lineEndContent="normal" />
  </string2>

  <multiLineComment>
   <citem item="" regexp="\*/" mode="until, exclude, allowfull"/>
   <citem item="" regexp="\*/" lineEndContent="normal" />
  </multiLineComment>

 </Break>

 <Contents>

  <normal>
   <citem item="Text" regexp="\s+" />

   <citem item="Keyword" regexp="\w+" keyword="
 all 
 and 
 as 
 asc 
 begin 
 blob 
 by 
 database 
 call 
 char 
 char 
 check 
 commit 
 concat 
 create 
 current 
 date 
 decimal 
 default 
 delete 
 desc 
 distinct 
 drop 
 encrypt 
 fetch 
 for 
 foreign 
 from 
 grant 
 group 
 in 
 index 
 insert 
 int 
 integer 
 into 
 is 
 key 
 like 
 limit 
 new 
 not 
 null 
 of 
 on 
 only 
 or 
 order 
 primary 
 read 
 references 
 reorg 
 revoke 
 rollback 
 select 
 set 
 smallint 
 table 
 time 
 timestamp 
 to 
 transaction 
 update 
 upsert 
 using 
 values 
 varchar 
 where 
 with 
  acquire 
 add 
 after 
 alias 
 allocate 
 allow 
 alter 
 any 
 asutime 
 audit 
 authorization 
 aux 
 auxiliary 
 avg 
 before 
 between 
 binary 
 bufferpool 
 called 
 capture 
 cascaded 
 case 
 cast 
 ccsid 
 character 
 close 
 cluster 
 collection 
 collid 
 column 
 comment 
 condition 
 connect 
 connection 
 constraint 
 contains 
 continue 
 count 
 count_big 
 cross
 current_date 
 current_lc_path 
 current_path 
 current_server 
 current_time 
 current_timestamp 
 current_timezone 
 current_user 
 cursor 
 data 
 database 
 day 
 days 
 dba 
 dbinfo 
 dbspace 
 db2general 
 db2sql 
 declare 
 descriptor 
 deterministic 
 disallow 
 disconnect 
 do 
 double 
 dssize 
 dynamic 
 editproc 
 else 
 elseif 
 end 
 end-exec 
 erase 
 escape 
 except 
 exception 
 exclusive 
 execute 
 exists 
 exit 
 explain 
 external 
 fenced 
 fieldproc 
 file 
 final 
 free 
 full 
 function 
 general 
 generated 
 go 
 goto 
 grant 
 graphic 
 handler 
 having 
 hour 
 hours 
 identified 
 if 
 immediate 
 indicator 
 inner 
 inout 
 insensitive 
 integrity 
 intersect 
 isobid 
 isolation 
 java 
 join 
 label 
 language 
 lc_ctype 
 leave 
 left 
 linktype 
 local 
 locale 
 locator 
 locators 
 lock 
 locksize 
 long 
 loop 
 max 
 microsecond 
 microseconds 
 min 
 minute 
 minutes 
 mode 
 modifies 
 month 
 months 
 name 
 named 
 nheader
 no 
 nodename 
 nodenumber 
 nulls 
 numparts 
 obid 
 open 
 optimization 
 optimize  
 option 
 out 
 outer 
 package 
 page 
 pages 
 parameter 
 part 
 partition 
 path 
 pctfree 
 pctindex 
 piecesize 
 plan 
 position 
 precision 
 prepare 
 priqty 
 private 
 privileges 
 procedure 
 program 
 psid 
 public 
 queryno 
 reads 
 recovery 
 release 
 rename 
 repeat 
 reset 
 resource 
 restrict 
 result 
 return 
 returns 
 revoke 
 right 
 row 
 rows 
 rrn 
 run 
 schedule 
 schema 
 scratchpad 
 second 
 seconds 
 secqty 
 security 
 share 
 simple 
 some 
 source 
 specific 
 sql 
 standard 
 static 
 statistics 
 stay 
 stogroup 
 stores 
 storpool 
 style 
 subpages 
 substring 
 sum 
 synonym 
 tablespace 
 then 
 to 
 transaction 
 trigger 
 trim 
 type 
 undo 
 union 
 unique 
 until 
 usage 
 user 
 using 
 validproc  
 variable 
 variant 
 vcat 
 view 
 volumes 
 when 
 while 
 wlm 
 work 
 write 
 year 
 years 
 absolute 
 action 
 are 
 assertion 
 at 
 bit_length 
 both 
 catalog 
 char_length 
 character_length 
 coalesce 
 collate 
 collation 
 constraints 
 convert 
 corresponding 
 deallocate 
 dec 
 deferrable 
 deferred 
 describe 
 diagnostics 
 domain 
 exec 
 extract 
 false 
 first 
 float
 found 
 full 
 get 
 global 
 identity 
 initially 
 input 
 interval 
 last 
 leading 
 level 
 lower 
 match 
 module 
 names 
 national 
 natural 
 nchar 
 next 
 nullif 
 numeric 
 octet_length 
 output 
 overlaps 
 pad 
 partial 
 preserve 
 prior 
 real 
 relative 
 scroll 
 section 
 session 
 session_user 
 size 
 space 
 sqlcode 
 sqlerror 
 sqlstate 
 system_user 
 temporary 
 timezone_hour 
 timezone_minute 
 trailing 
 translation 
 true 
 unknown 
 upper 
 value 
 varying 
 whenever 
 zone 
" caseSensitive="false"/>

   <citem item="Memo" regexp="--.*" />
   <citem item="Memo" regexp="/\*" lineEndContent="multiLineComment" />

   <citem item="String"  regexp="&quot;" lineEndContent="string1" />
   <citem item="String" regexp="'"      lineEndContent="string2" />

   <citem item="Text" regexp="[\w_]+" lineEndContent="normal" />
   <citem item="Text" regexp="\s+"    lineEndContent="normal" />
   <citem item="Text" regexp="\W"     lineEndContent="normal" />
  </normal>

  <string1>
   <citem item="String"    regexp="[^&quot;\\]+" />
   <citem item="Char"      regexp="\\." />
   <citem item="String"    regexp="&quot;" lineEndContent="normal" />
  </string1>

  <string2>
   <citem item="String"    regexp="[^'\\]+" />
   <citem item="Char"      regexp="\\." />
   <citem item="String"    regexp="'" lineEndContent="normal" />
  </string2>

  <multiLineComment>
   <citem item="Memo" regexp="\*/" mode="until, exclude, allowfull"/>
   <citem item="Memo" regexp="\*/" lineEndContent="normal" />
  </multiLineComment>

 </Contents>

</Highlight>