File page
Output file (Not for Data Warehouse enter)
Delimited ASCII format (DEL)
Work sheet format (WSF)
Integrated exchange format (IXF)
Options
SELECT statement
Message file
OK
Show Command
Cancel
Output file (Not for Data Warehouse enter)
Type the path and name of the file that data will be exported to, or, to
search for and select the path and file name, click:
If you omit the path, the current working directory is used. If you do not specify the complete path to the file, the export process uses the current directory and the default drive as the destination.
If a file by that name already exists, the export process overwrites the contents of the file; the information is not appended.
Delimited ASCII format (DEL)
Select this radio button to specify that the data in the output file is in the delimited ASCII format (DEL).
Work sheet format (WSF)
Select this radio button to specify that the data in the output file is in work sheet format (WSF), used by products like Lotus 1-2-3 and Lotus Symphony.
Integrated exchange format (IXF)
Select this radio button to specify that the data in the output file is in the PC integrated exchange format (PC/IXF).
Options
Click on this push button to open an Options window so you can specify the options for the export file type you selected:
SELECT statement
Type the SELECT statement that extracts the data you want from the table or view you selected from the contents pane.
The default statement extracts all data. For example:
SELECT * FROM SYSIBM.SYSINDEXES
Related information
Message file
Type the name of the file that will contain warning and error messages that
occur during export. (For DB2 Universal Database only, you can search
for and select the path and file name by clicking the
push button.)
If you do not type the full path, the current directory and default drive are used. If the file already exists, the information is appended. If you do not specify a message file, an error is returned.
Large Objects page
Store large objects (LOBs) in separate files
(LOBSINFILE)
LOB paths
Add
Change
Remove
Move Up
Move Down
LOB file names
Add
Change
Remove
Move Up
Move Down
OK
Show Command
Cancel
Store large objects (LOBs) in separate files (LOBSINFILE)
Select this check box to enable the options on the Large Objects page.
LOB paths
Use this list box to specify the path, or paths, to store the LOB files specified in the LOB file names list box. When file space is exhausted on the first path, the second path is used, and so on.
To add a path to the list box, click on the Add push button. The Add window opens.
To change a path, select it from the list box and click on the Change push button. The Change window opens.
To remove a path from the list box, select it and click on the Remove push button. The path is deleted from the list.
LOB file names
Use this list box to specify the base file name or names of the LOB files. When name space is exhausted for the first name, the second name is used, and so on.
To add a file name to the list box, click on the Add push button. The Add window opens.
To change a file name, select it from the list box and click on the Change push button. The Change window opens.
To remove a file name from the list box, select it and click on the Remove push button. The file name is removed from the list.
Add
Click on this push button to add objects, such as files and columns, to the list box. The Add window opens.
Change
Click on this push button to change the object selected in the list box. The Change window opens.
Columns page
Column names
Add
Change
Remove
Move Up
Move Down
OK
Show Command
Cancel
Column names
Use this list box to specify the column names that will be used in the output file. If you do not add column names to the list box, the column names in the existing table or view are used.
To add a column name to the list box, click on the Add push button. The Add window opens.
To change a column name, select it from the list box and click on the Change push button. The Change window opens.
To remove a column name from the list box, select it and click on the Remove push button. The column name is deleted from the list.
Add
Click on this push button to add objects, such as files and columns, to the list box. The Add window opens.
Change
Click on this push button to change the object selected in the list box. The Change window opens.