To determine the size of the memory required for block transfer or array FETCH, use the formulas below.
Condition | Value specified in the PDBLKBUFFSIZE operand | ||
---|---|---|---|
Omitted or 0 | 1 or greater | ||
An array-type embedded variable is specified in the INTO clause of the FETCH statement | Formula 1 | ||
An array-type embedded variable is not specified in the INTO clause of the FETCH statement | PDBLKF operand is omitted or is set to 1 | ![]() | Formula 2 |
PDBLKF operand is set to 2 or greater | Formula 1 |
![]() ![]() ![]() ![]() ![]() ![]() ![]() (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
MAX(X1,X2) (kilobytes) |
X1: (864 + 22
a + 2
c + b)
1024
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