15.1.9 Formula for size of memory required during block transfer or array FETCH

To determine the size of the memory required for block transfer or array FETCH, use the formulas below.

ConditionValue specified in the PDBLKBUFFSIZE operand
Omitted or 01 or greater
An array-type embedded variable is specified in the INTO clause of the FETCH statementFormula 1
An array-type embedded variable is not specified in the INTO clause of the FETCH statementPDBLKF operand is omitted or is set to 1--Formula 2
PDBLKF operand is set to 2 or greaterFormula 1
Legend:
--: Not applicable
Formula 1
[Figure]{864 + 16 x a + (6 x a + 2 x d + b) x c} [Figure] 1,024[Figure] (kilobytes)

a: Number of retrieved items specified in the SELECT clause

b: Data length per row in the retrieval results obtained by the FETCH statement (sum of the maximum length of each column, in bytes)

c: Value of the PDBLKF operand or number of arrays

d: Number of selection formulas with BINARY type specified in the search item specified in the SELECT clause

Formula 2
MAX(X1,X2) (kilobytes)

X1: [Figure](864 + 22 x a + 2 x c + b) [Figure] 1,024[Figure]

X2: Value of the PDBLKBUFFSIZE operand

a: Number of retrieved items specified in the SELECT clause

b: Data length per row in the retrieval results obtained by the FETCH statement (sum of the length of each column that is actually obtained, in bytes)

c: Number of selection formulas with BINARY type specified in the search item specified in the SELECT clause