16.1.8 Formula for size of memory required during BLOB data retrieval or updating (HiRDB/Single Server)

Use the following formula to determine the size of the memory required during BLOB data retrieval or updating.

Formula
a + b + 17 (KB)

a: Maximum value from the following formula for BLOB input variables or output variables specified in one SQL statement:

[Figure]{
c
[Figure](actual length of BLOB input variable i1 + 118) +
i=1
d
[Figure](specified length of BLOB output variable j2 + 86)
j=1
}[Figure]1024[Figure]
1 This is the actual length of BLOB data passed as embedded variables from the UAP to the HiRDB server.
2 This is the declared length of the UAP embedded BLOB data type variables received from the UAP and returned from HiRDB to the UAP. If it is an INSERT or SELECT statement, the BLOB type reflected from the SELECT side is an output variable.

b: Maximum value from the following formula for a combination of SQL statements performing join retrieval with simultaneously open cursors:

[Figure]{
e
[Figure]{
i=1
d
[Figure](defined length of BLOB output variable j + 18)}
j=1
} [Figure]1024[Figure]

c: Number of input variables

d: Number of output variables

e: Number of simultaneously open cursors