title: How to use Sybase LOAD TABLE correctly?
body: <p>I have been using ISQL (SQLAnywhere 12) to import data from CSVs into existing tables using INPUT INTO and never ran into a problem. Today I needed to import data into a table containing an auto-increment column, however, and thought I just needed to leave that column blank, so I tried it with a file containing only 1 row of data (to be safe). Turns out it imported with a 0 in the auto-increment field instead of the next integer value.</p>
  
  <p>Looking at the <a href="http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00801.1510/html/iqrefso/X315750.htm" rel="nofollow">Sybase documentation</a>, it seems like I should be using LOAD TABLE instead, but the examples look a bit complex.</p>
  
  <p>My questions are the following...</p>
  
  <ul>
  <li>The documentation says the CSV file needs to be on the database server and not the client. I do not have access to the database server itself - can I load the file from within ISQL remotely?</li>
  <li>How do I define the columns of the table I'm loading into? What if I am only loading data into a few columns and leaving the rest as NULL?</li>
  <li>To confirm, this will leave existing data in the table as-is and simply add to it using whatever is in the CSV?</li>
  </ul>
  
  <p>Many thanks in advance.</p>