Specifying the Source Table in SQL Mode

Restriction: This topic applies to Windows environments only.

When in SQL mode, the Export window permits direct entry of an SQL SELECT statement in the Query area to specify the table and columns to be exported. You can include a WHERE condition to limit the number of records that are selected for export.

Note:


SQL Mode button
Click the SQL Mode button on the toolbar to change from Design Mode to SQL Mode.

If you enter table, column, or WHERE condition information while in Design Mode, and then switch to SQL Mode, the SELECT statement will be generated for you. You can modify it as desired and export the table, or copy the SQL statement to a text editor.

Likewise, you can copy an SQL statement from the SQL Edit window or your text editor and paste it into the Query field on the Export window.

Note:

If you modify the SELECT statement in certain ways (add a JOIN, for example) you will not be able to switch to Design Mode.

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

To specify and export a source table using SQL mode:

  1. Click in the Query display area of the Export window to position your cursor in the text entry box.
  2. Type an SQL SELECT statement. Enter a WHERE clause if desired. Alternatively, you can copy a select statement from another SQLWizard window or from a text editor, and paste it into the Query display area of the Export window.
  3. Click the Run command from the Export menu.
    Note:


    Run button
    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.