You can set preferences for how DB2® data
is extracted and loaded and for how many rows are retrieved and displayed.
Procedure
To set preferences for extracting and loading data:
- On the main menu, 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 use DB2 commands only 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, the
preferences that you specified are used.