Source Table Information (Design Mode)

This section of the Export window is where you specify exactly what you want to export. You can export an entire table, selected columns, or selected data.

Table Name Enter the name of the XDB Server table that you want to extract data from. Use the Browse button to select a table from the Open dialog box.
Not Included/Included Lists The Not Included and Included lists allow you to choose the columns of the source table that you want to export. Only the columns appearing in the Included list when you run the export will be transferred to the target file. Double click a column name to move it to the other list.

You can also re-arrange the order of the columns. For example, if your source table has columns called FIRSTNAME and LASTNAME in that order, you can switch the order to LASTNAME FIRSTNAME in the exported data. After selecting the columns you want to include in the exported data, click a name to highlight it, then move it up or down the Included list until the column names are in the order you want.

WHERE Condition You can limit the amount of data that will be exported by entering an SQL WHERE clause. For example, when exporting data from the TUTORIAL.TUTORIAL.EMPLOYEE table, you can export information about employees who live in Maryland by entering ST="MD" in the WHERE Condition box. You do not have to type the word WHERE.
Note:

When the SQL format is selected, the WHERE Condition field is available only when INSERT mode is selected.