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:
- In the Preferences window: Click and expand the Data
Management node.
- Click DB2 Options.
- 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.
- Optional: For all databases, set options for
the maximum number of rows to retrieve and display.
- Expand the SQL Development node.
- Click SQL Results View Options and
specify a maximum display row count.
- Click OK.
Results
The next time you extract or load data from a database, your
options are used.