DIRECT YES:
When we use DIRECT YES option, BMC Unload Plus utility (ADUUMAIN) reads data directly from the table space data set or image copy data set and uses a SELECT-like syntax for data selection.
We can unload all data from a table-space without requiring written SELECT statements.
The data can be sorted by clustering key or partitioning key.
DIRECT NO:
When we use DIRECT NO option, BMC Unload Plus utility uses DB2 dynamic SQL to process the SELECT statement.
Data type conversions can be performed using DIRECT NO (which is not available with DIRECT YES).