Appendix E. Creation of Input Data Files for the Database Load Utility

The following types of files can be input to the database load utility (pdload):

File typeRecord lengthDAT formatBinary format or fixed-size data formatFixed-size data format
Regular fileAnyYYY
FIFOAny#1YYN
Fixed-length blocked tape512-byteY#2NN
Variable-length blocked tape32KB(any length for last block)YYY
EasyMT tapeAny#3YYY

Y: Can be input.

N: Cannot be input.

#1: The maximum record length is 32 KB in the normal DAT format, and is the value of the maxreclen operand in the source statement in the extended DAT format.

#2: The end of the tape is padded with 0x00 at a 512-byte boundary.

#3: The data length equals the record length, except for EasyMT.

Because the procedures for creating the following three types of files are complicated, this appendix explains the procedures:

Organization of this section
E.1 Creating an input file on fixed-length blocked tape
E.2 Creating an input file on variable-length blocked tape
E.3 Creating an input file on EasyMT tape