basis/xmode/modes/sql-loader.xml

   1 <?xml version="1.0"?>
   2 <!DOCTYPE MODE SYSTEM "xmode.dtd">
   3 <MODE>
   4         <PROPS>
   5                 <PROPERTY NAME="commentStart" VALUE="/*" />
   6                 <PROPERTY NAME="commentEnd" VALUE="*/" />
   7                 <PROPERTY NAME="lineComment" VALUE="--" />
   8         </PROPS>
   9         <RULES IGNORE_CASE="TRUE" HIGHLIGHT_DIGITS="TRUE">
  10                 <SPAN TYPE="COMMENT1">
  11                         <BEGIN>/*</BEGIN>
  12                         <END>*/</END>
  13                 </SPAN>
  14                 <SPAN TYPE="LITERAL1">
  15                         <BEGIN>'</BEGIN>
  16                         <END>'</END>
  17                 </SPAN>
  18                 <SPAN DELEGATE="pl-sql::MAIN">
  19                         <BEGIN>"</BEGIN>
  20                         <END>"</END>
  21                 </SPAN>
  22                 <EOL_SPAN TYPE="COMMENT1">--</EOL_SPAN>
  23                 <SEQ TYPE="OPERATOR">+</SEQ>
  24                 <SEQ TYPE="OPERATOR">-</SEQ>
  25                 <SEQ TYPE="OPERATOR">/</SEQ>
  26                 <SEQ TYPE="OPERATOR">*</SEQ>
  27                 <SEQ TYPE="OPERATOR">=</SEQ>
  28                 <SEQ TYPE="OPERATOR">&gt;</SEQ>
  29                 <SEQ TYPE="OPERATOR">&lt;</SEQ>
  30                 <SEQ TYPE="OPERATOR">%</SEQ>
  31                 <SEQ TYPE="OPERATOR">&amp;</SEQ>
  32                 <SEQ TYPE="OPERATOR">|</SEQ>
  33                 <SEQ TYPE="OPERATOR">^</SEQ>
  34                 <SEQ TYPE="OPERATOR">~</SEQ>
  35                 <SEQ TYPE="OPERATOR">!=</SEQ>
  36                 <SEQ TYPE="OPERATOR">!&gt;</SEQ>
  37                 <SEQ TYPE="OPERATOR">!&lt;</SEQ>
  38                 <SEQ TYPE="OPERATOR">:=</SEQ>
  39
  40                 <KEYWORDS>
  41                         <!-- reserved words -->
  42                         <KEYWORD1>LOAD</KEYWORD1>
  43                         <KEYWORD1>DATA</KEYWORD1>
  44                         <KEYWORD1>INFILE</KEYWORD1>
  45                         <KEYWORD1>BADFILE</KEYWORD1>
  46                         <KEYWORD1>DISCARDFILE</KEYWORD1>
  47                         <KEYWORD1>INTO</KEYWORD1>
  48                         <KEYWORD1>TABLE</KEYWORD1>
  49                         <KEYWORD1>FIELDS</KEYWORD1>
  50                         <KEYWORD1>TERMINATED</KEYWORD1>
  51                         <KEYWORD1>BY</KEYWORD1>
  52                         <KEYWORD1>OPTIONALLY</KEYWORD1>
  53                         <KEYWORD1>ENCLOSED</KEYWORD1>
  54                         <KEYWORD1>EXTERNAL</KEYWORD1>
  55                         <KEYWORD1>TRAILING</KEYWORD1>
  56                         <KEYWORD1>NULLCOLS</KEYWORD1>
  57                         <KEYWORD1>NULLIF</KEYWORD1>
  58                         <KEYWORD1>DATA</KEYWORD1>
  59                         <KEYWORD1>BLANKS</KEYWORD1>
  60                         <KEYWORD1>INSERT</KEYWORD1>
  61                         <KEYWORD1>INTO</KEYWORD1>
  62                         <KEYWORD1>POSITION</KEYWORD1>
  63                         <KEYWORD1>WHEN</KEYWORD1>
  64                         <KEYWORD1>APPEND</KEYWORD1>
  65                         <KEYWORD1>REPLACE</KEYWORD1>
  66                         <KEYWORD1>EOF</KEYWORD1>
  67                         <KEYWORD1>LOBFILE</KEYWORD1>
  68                         <KEYWORD1>TRUNCATE</KEYWORD1>
  69                         <KEYWORD1>COLUMN</KEYWORD1>
  70
  71             <!--function-->
  72                         <KEYWORD1>COUNT</KEYWORD1>
  73                         <KEYWORD1>AND</KEYWORD1>
  74                         <KEYWORD1>SDF</KEYWORD1>
  75                         <KEYWORD1>OR</KEYWORD1>
  76                         <KEYWORD1>SYSDATE</KEYWORD1>
  77
  78                         <!-- data types -->
  79                         <KEYWORD1>binary</KEYWORD1>
  80                         <KEYWORD1>bit</KEYWORD1>
  81                         <KEYWORD1>blob</KEYWORD1>
  82                         <KEYWORD1>boolean</KEYWORD1>
  83                         <KEYWORD1>char</KEYWORD1>
  84                         <KEYWORD1>character</KEYWORD1>
  85                         <KEYWORD1>constant</KEYWORD1>
  86                         <KEYWORD1>date</KEYWORD1>
  87                         <KEYWORD1>datetime</KEYWORD1>
  88                         <KEYWORD1>decimal</KEYWORD1>
  89                         <KEYWORD1>double</KEYWORD1>
  90                         <KEYWORD1>filler</KEYWORD1>
  91                         <KEYWORD1>float</KEYWORD1>
  92                         <KEYWORD1>image</KEYWORD1>
  93                         <KEYWORD1>int</KEYWORD1>
  94                         <KEYWORD1>integer</KEYWORD1>
  95                         <KEYWORD1>money</KEYWORD1>
  96                         <!-- KEYWORD1>name</KEYWORD1 -->
  97                         <KEYWORD1>numeric</KEYWORD1>
  98                         <KEYWORD1>nchar</KEYWORD1>
  99                         <KEYWORD1>nvarchar</KEYWORD1>
 100                         <KEYWORD1>ntext</KEYWORD1>
 101                         <KEYWORD1>object</KEYWORD1>
 102                         <KEYWORD1>pls_integer</KEYWORD1>
 103                         <KEYWORD1>raw</KEYWORD1>
 104                         <KEYWORD1>real</KEYWORD1>
 105                         <KEYWORD1>smalldatetime</KEYWORD1>
 106                         <KEYWORD1>smallint</KEYWORD1>
 107                         <KEYWORD1>smallmoney</KEYWORD1>
 108                         <KEYWORD1>sequence</KEYWORD1>
 109                         <KEYWORD1>text</KEYWORD1>
 110                         <KEYWORD1>timestamp</KEYWORD1>
 111                         <KEYWORD1>tinyint</KEYWORD1>
 112                         <KEYWORD1>uniqueidentifier</KEYWORD1>
 113                         <KEYWORD1>varbinary</KEYWORD1>
 114                         <KEYWORD1>varchar</KEYWORD1>
 115                         <KEYWORD1>varchar2</KEYWORD1>
 116                         <KEYWORD1>varray</KEYWORD1>
 117                         <KEYWORD1>zoned</KEYWORD1>
 118                 </KEYWORDS>
 119         </RULES>
 120 </MODE>
 121
 122