basis/xmode/modes/sql-loader.xml

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