Use this code

DIRECT YES and DIRECT NO options in BMC unload plus

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).

Related Posts

• DB2 commands : TERM, START, STOP, DIS
• Logical Operators in DB2
• Embedded DB2 SQL in Easytrieve
• Using MAXASSIGNEDVAL from SYSIBM.SYSSEQUENCES (IBM DB2 for Z OS)
• Creating (Declaring), Inserting data into DB2 temporary tables
• Using IKJEFT01 for Binding a normal batch DB2 program
• Using IKJEFT01 for running a normal batch DB2 program
• Running DSNTIAUL using IKJEFT01 for batch unload
• Running DSNTEP2 / DSNTEP4 using IKJEFT01 for batch SQL(DB2) processing