In Design mode, you choose an XDB Server table and the fields you want to include or exclude in the Source Table Information section of the Export window. You can add a WHERE condition to limit the data that will be exported from the table. If you do not specify a WHERE condition, all rows in the table will be exported.
Instructions on how to choose a source table using Design mode are provided below.
To specify source table information and export using Design Mode:
SQLWizard displays the Open dialog box. (Alternatively, you can type a fully qualified table name and skip to Step 3.)
The selected table name appears in the Table field as a three-part name. If you have not already entered a destination file name in the Source File Information area at the top of the Export window, a default target file name is entered for you. The default name uses the first eight characters of the table name and the extension for the format that has been specified.
From the Catalog Browser dialog box, click the
Table tab and drag a table name to the
Table field on the Export window.
To move a column from one list to the other, click its name to highlight it, then click the appropriate arrow button to move it to the other list. Alternatively, double click a column name to move it to the other list.
To select multiple contiguous items on a list, hold down the Shift key while clicking on the first and last entry of the desired list of items. To select multiple non-contiguous items, hold down the Ctrl key while clicking on each name you want to select. When the selected items are highlighted, click the appropriate arrow button to move the highlighted items to the other list. To move all columns from one list to the other, click the appropriate double-arrow button.
To move a column within the Selected list, click its name to highlight it, then click the Up or Down button as desired.
To specify a WHERE condition, type a standard SQL WHERE clause. You do not need to type the word where.
Click the
Run button on the toolbar to start the export process.
SQLWizard displays the progress of the export operation in the status bar. When the export is complete, the status bar reports the number of records exported.