SQLWizard Export allows you to transfer the contents of any XDB Server table or view into a file in any of the supported file formats. You can export the columns of an existing table in any order or export a subset of the columns. In addition, you can specify a WHERE condition to export only selected data from the original table. Features are available to log the export process, set your own defaults for various export options, and set up and run Batch Export commands.
Batch export is particularly useful if you repeatedly export data from the same tables. Each time you open an Export window and provide export specifications and then save the specifications to a file, you create a Batch Export file. Before using Batch Export, you should be familiar with interactive export for the type of file to which you are exporting.
The following is a list of file formats supported by SQLWizard. Depending on the format you select, you may need to specify a number of options before activating the export.
Exports data from XDB Server tables to delimited (free-format) ASCII files.
Exports data from XDB Server tables to columnar (fixed-format) ASCII files.
Exports data from XDB Server tables to DSNTIAUL files. DSNTIAUL files can be read into DB2 systems.
Generates SQL 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.