title: sybase load data incorrect syntax
body: <p>This is my first attempt to load data to a sybase table from an external file. Here is my code snippet.</p>
  
  <p>I create the table as below..</p>
  
  <pre><code>IF OBJECT_ID ('dbo.TEST_DATA') IS NOT NULL
      DROP TABLE dbo.TEST_DATA
  GO
  
  CREATE TABLE dbo.TEST_DATA
      (
        NAME            CHAR (10) NOT NULL
      , ID         CHAR (4) NULL
      )   
  GO
  </code></pre>
  
  <p>This is how I try to load the data..</p>
  
  <pre><code>LOAD TABLE dbo.TEST_DATA
  ( 
  NAME,ID 
  ) 
  FROM 'C:\testdata.txt'
  DELIMITED BY ',' 
  </code></pre>
  
  <p>The data in the file is simple..</p>
  
  <pre><code>xxxxxxx,1111
  yyyyy,2222
  </code></pre>
  
  <p>When I try to load the data, it gives me "Incorrect Syntax near the keyword TABLE" error. I'm not sure what I'm missing. </p>