SQL Option can import and export data in a variety of formats. You can specify import and export settings by clicking New > Import or New > Export on the File menu of SQL Wizard. You can optionally save these settings in an .imp or .exp file that you can subsequently run as a batch file for routine data conversions.
Use SQL Option's import capabilities to run programs against test data prepared in another file format. For example, you could export suitable test data held in a Microsoft Access database, or a Microsoft Excel or Lotus 1-2-3 spreadsheet, to delimited or fixed-field ASCII files. You could then import these files into XDB Server.
You can import data into an XDB database from any of the following sources:
Imports data from delimited (free-format) ASCII files.
Imports data from columnar (fixed-format) ASCII files.
Imports data downloaded from IBM's DB2 using IBM's DSNTIAUL facilities.
Use SQL Option's export capabilities to transfer data from an XDB database to a mainframe DB2 database if you do not have gateway connectivity, or to create the DDL commands required to create a table.
You can export data from an XDB database into any of the following targets:
Exports data to delimited (free-format) ASCII files.
Exports data to columnar (fixed-format) ASCII files.
Exports data to DSNTIAUL files. DSNTIAUL files can be read into DB2 systems.
Generates DDL commands that can be used to re-create a table, insert data into it and create indexes on the table. COMMENT, WHERE and SYNONYM statements can be included.