Data Unload Wizard (DB2 LUW)

From DBArtisan
Jump to: navigation, search

Go Up to Data Unload

DBArtisan offers a simple, wizard that lets you export table data. After defining the data export operation, you have the opportunity to save the job definition for future reuse.

Starting the Export Wizard

  1. Connect to the datasource containing the data to be unloaded and ensure that it is the selected datasource. For details, see Connected/Selected Datasource options.
  2. Select Utilities > Data Unload. The Data Export Wizard opens.
  3. The options offered depend on the selections you make. Use the following table as a guide t completing the pages of the wizard.

New or playback action

Do you wish to initiate a new export operation or ‘play back’ a previously saved operation? New Export Operation - Select to define a new data unload operation. Previous Export Operation - Select to use a previously defined schema extraction operation. Then in the Export Definition File Name box type the location and name of the job file or click the browse button.

Datasource and format selection

What datasource has the data you wish to export? - Lets you click the list and select the datasource. Specify the format for the data export file(s) to be generated. - Lets you click the list and select the file format. Option Button - Available if you select a delimited option. How would you like to specify the data to export? - Enter a SELECT statement. Select tables/views from a list (one export file per table/view).

SELECT statement and LOB options

Specify the data to be extracted from the database by entering a SELECT statement - Enter the statement that will retrieve the row(s) or column(s) you want from one or more tables. Statements can be complicated. Go to do a search on SELECT for help. Would you like to store large objects (LOBs) in separate files? - When you choose to store LOBs in separate files, you will be given the chance to store them in files outside the database tablespaces. When you choose not to store your LOBs in separate files, they will exist in a table row in the database.

Lob file details

If you specified that LOBs are to be stored in separate files, the following options are provided: List paths where the LOB files are to be stored - Add, Edit, or Remove files where you want LOBs to be stored. List LOB file names - Add, Edit, or Remove LOB file names.

Table selection details

Owner - Lets you select the tables and/or views you want to export or click the Check All button. Count Rows - Lets you update the table row counts. Check All - Lets you select all tables or views. Uncheck All - Lets you deselect all tables or views.

Output options

Select a directory for export files (including and LOB files) - Type the location and name of the export file or click the Browse button. Specify a path and name for the message file - Type the location and name of the message file or click the Browse button. Do you wish to re-use this data unload operation? - To re-use this data unload operation, in type the location and name of the data unload definition file or find the file by clicking the Browse button. DBArtisan writes a migrate definition file using the *.unload file extension that includes your job definition.

Options review

Review the data export operation description to verify its accuracy. If you need to make any changes, click Back to scroll back to the appropriate panels of the wizard to make your corrections.

4. When ready, click Execute.