Setting preferences for extract and load

You can set preferences in the Preferences window for how DB2® data is extracted and loaded, or how many rows are retrieved and displayed.

Procedure

To set preferences for extract and load:

  1. In the Preferences window: Click Windows > Preferences and expand the Data Management node.
  2. Click DB2 Options.
  3. Select or clear the Use DB2 commands to load and extract tables check box to specify how data is extracted and loaded. If you do not select this option, SQL queries are used. Using DB2 commands (LOAD and EXPORT) improves performance. However, you can only use DB2 commands when you are working with local databases. That is, the database must be on the same computer as the workbench.
  4. Optional: For all databases, set options for the maximum number of rows to retrieve and display.
    1. Expand the SQL Development node.
    2. Click SQL Results View Options and specify a maximum display row count.
  5. Click OK.

Results

The next time you extract or load data from a database, your options are used.

Feedback