8.9.10 unlduoc statement (specification of UOC storage library information)

The unlduoc statement specifies information about a UOC that is to be used for database reorganization.

Criteria
Specify the unlduoc statement when a UOC is to be used for database reorganization.
Rules
You can specify only one unlduoc statement.
Organization of this subsection
(1) Format
(2) Explanation

(1) Format

 unlduoc entry=function-name

        [bloblimit=memory-space-allocation-size]

        [fixrow={y|n}]

(2) Explanation

(a) entry=function-name

Specifies the name of function to be called in the library.

(b) bloblimit=memory-space-allocation-size

[Figure]<unsigned integer> ((1-2097152))

Specifies the maximum size in kilobytes of the memory space that is to hold the data to be passed to the UOC. If any of the following conditions is satisfied, the utility holds in memory all data to be passed to the UOC:

If there are multiple columns that satisfy these conditions, this operand applies to all such columns.

Criteria
Specify this option when any of the following conditions is satisfied:
  • When the table contains columns of an abstract data type and a constructor parameter reverse creation function corresponding to the unld_func statement is specified, the return value of the specified function has the large object data type.
  • A memory shortage may occur if the memory space is allocated for data based on the defined column lengths.
  • The real data is clearly smaller than the defined column lengths.
Rules
  1. For a column of the large object data type or if a defined column length is less than the memory space allocation size, the column length defined for that column becomes the memory space allocation size.
  2. An error results if data exceeds the specified size (if the defined column length is less than the specified value or there is data that exceeds the defined column length).
(c) fixrow={y|n}

If a FIX table is to be processed, pdrorg specifies the storage method for the data to be passed to the UOC. Specifying y for a non-FIX table results in an error.

y:
Passes data in the order the columns are defined (consecutively). Specify y if you want to output all the data passed by pdrorg in the batch mode (you cannot directly reference any data type that requires alignment guarantee).
n:
Corrects the data start address according to the boundary of the data type and then passes the data. Specify n if you want to directly reference data (you can directly reference data without having to copy it to a separate area because the start address of the data type that requires alignment guarantee has already been corrected).