16.2.9 Formula for size of memory required during BLOB data retrieval or updating (back-end server or dictionary server)

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

Formula
a + b
(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 i* + 118 + 70[Figure]number of output variables)
i=1
}[Figure]1024[Figure]
* This is the actual length of BLOB data passed as embedded variables from the UAP to the HiRDB server.

This is the actual length of BLOB data passed as embedded variables from the UAP to the HiRDB server.

d
[Figure]{280 + 184[Figure](number of tables specified in SQLi + 1)}
i=1

c: Number of input variables

d: Number of cursors