15.2.10 Formula for size of memory required during block transfer or array FETCH (front-end server)

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

ConditionValue specified in the PDBLKBUFFSIZE operand
Omitted or 01 or greater
An array-type embedded variable is specified in the INTO clause of FETCH statementFormula 1
An array-type embedded variable is not specified in the INTO clause of FETCH statementPDBLKF operand is omitted or 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] (KB)

a: Number of retrieval items specified in the SELECT clause

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

c: Value specified by the PDBLKF operand or the number of array columns

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 or retrieved items that is 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