Specifying the Source Table in Design Mode

Restriction: This topic applies to Windows environments only.

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.

Note: XDB Server indexes are not exported with the table. One exception to this rule is that if the table uses indexes and you export the table specifications and data to SQL Statements format, you can choose to have Export generate the SQL statement to re-create the indexes.

Instructions on how to choose a source table using Design mode are provided below.

To specify source table information and export using Design Mode:

  1. Click the Browse button in the Source Table Information section on the Export window.

    SQLWizard displays the Open dialog box. (Alternatively, you can type a fully qualified table name and skip to Step 3.)

  2. Choose the desired location, AuthID, and table; then click OK.

    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.

    Note:


    *
    From the Catalog Browser dialog box, click the Table tab and drag a table name to the Table field on the Export window.

  3. Choose which columns you want to export by moving them to the Included and Not Included lists as desired. The default is to export all columns.

    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.

  4. If desired, you can re-arrange the order of the columns. Your exported data can list the columns of information in a different order than the original table.

    To move a column within the Selected list, click its name to highlight it, then click the Up or Down button as desired.

  5. If desired, you can limit the number of records to be exported by specifying a WHERE condition. This allows you to export only those records that meet the condition. If you do not specify a WHERE condition, all rows in the specified XDB Server table will be exported.

    To specify a WHERE condition, type a standard SQL WHERE clause. You do not need to type the word where.

  6. Click the Run command from the Export menu to start the export process.
    Note:


    *
    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.