Import and Export Overview

SAP Sybase IQ lets you import data from flat files or directly from database tables. You can also enter specified values directly into the database. You can export data to other formats from the Interactive SQL utility and the IQ data extraction facility.

SAP Sybase IQ tables are logical tables; they do not contain data. All information needed to resolve queries, including data, is contained in the SAP Sybase IQ indexes. When you insert data into the columns in an IQ table, you do not actually add data to columns in the table, but rather to the column indexes. Build indexes by inserting data on a table-by-table basis.

• Import and Export Method Selection
  SAP Sybase IQ offers you a choice of methods for adding, changing, or deleting data.
• Input and Output Data Formats
  The LOAD TABLE statement imports data from files row by row. Both ASCII and binary input files are supported, with either fixed-length fields or variable-length fields ended by a delimiter.
• Permissions for Modifying Data
  You can execute data modification statements only if you have the proper permissions on the database tables you want to modify.
• Schedule Database Updates
  Multiple users can query a database table, and can update the database concurrently.