ONLY TABLES

Define the tables to be unloaded for the specified table space. You can specify an explicit list that is separated by commas, or supply a file that contains such a list. An example of a file that contains a list of tables is shown below:

# List of tables
EMPLOYEE #Employee table
I910.SALES #Sales table

Use the # character to add a comment to the file.

ONLY TABLES

Syntax: ONLY TABLES ( tablename | qualifier.tablename , tablename | qualifier.tablename , ... ); ONLY TABLES IN "filename"
Variable: A table name, a fully qualified table name, or the filename that contains the list of tables.
Default: ALL
Example: ONLY TABLES (EMPLOYEE, I910.SALES)

Restriction:

You can not specify the ONLY TABLES option if you have specified SELECT blocks in the UNLOAD block.