In addition to the standard View menu commands, the following commands become available when an Export window is active:
Design Export | Displays the standard Export window, allowing you to interactively select a table to export, specify a file to receive the exported data, specify various format-specific options, and specify a WHERE condition. An alternate Export window view is available if you select the SQL command from the View menu. |
SQL | Provides an alternate view of your Export specifications, allowing you enter an SQL SELECT statement instead of using the standard Export window to specify the source table and WHERE condition. |
Target File | Allows you to view the data as it appears in the file to which you exported data. |
Batch Export Commands | Opens a window showing the Batch Export commands that would be generated from the information currently appearing on the Export window. This is the command list that would be saved if you use the Save or Save As command. It can later be run as a Batch Export file. |
Batch Import Commands | Opens a window showing the Batch Import commands that would be generated from the information currently appearing on the Export window. This is the command list that would be saved if you use the Save or Save As command and saved the file as an Import (*.imp) file. Generating a batch import file at the time you are exporting data can help you when you plan to import the data onto another XDB Server. You would take the exported data file and the corresponding batch import file to the other XDB Server. Then use batch import on that machine to transfer the data onto that XDB Server. |