Using &NDB Verbs › Put It All Together—Unload or Reload an NDB › Define an Unload File

Previous Topic: Put It All Together—Unload or Reload an NDB

Next Topic: Open the Database and Output Unload File

Define an Unload File

A file to hold the unloaded data is needed. This example uses a VSAM ESDS. The following definition could be used:

DEFINE CLUSTER (NAME(NDB.UNLOAD) -
   NIXD                          -
   RECORSIZE(40 500)             -
   CISZ(4096))

This data set must be allocated to your product region:

ALLOC DD=UNLOAD DSN=NDB.UNLOAD

The data set must be made available to NCL, via the UDBCTL statement. When an empty ESDS is opened, a dummy record is written. Our reload program must skip this record.

UDBCTL OPEN=UNLOAD ID=* BUFND=5

The unload can now be performed.