This example demonstrates how to use a Type 3 DSNUTILB UNLOAD file. You can use this same procedure for a Type 1 REORG UNLOAD file.
The unload file contains data from the PWXTAB3 and PWXTAB4 tables, each with its own structure. For Type 3, the underlying table is specified by the OBID in the first two bytes. The OBIDs for the tables are x’0004’ and x’0005’ respectively.
To add DB2 unload file data map:
Add a data map to map the PWXTAB3 table.
On the
Data Map
tab in the
Resource Explorer
, right-click the DTL_OBID field and click
Properties
.
In
Record ID Values
box, enter the OBID hex value of x’0004’ and click
OK
.
The icon for the DTL_OBID field appears in green, indicating that the
Record ID
filter is set for the field.
Import the next underlying table, PWXTAB4.
In
Record ID Values
box, enter the OBID hex value of x’0005’ and click
OK
.
The icon for the DTL_OBID field appears in green, indicating that the
Record ID
filter is set for the field.
To test the PWXTAB4 table, run a database row test.