15.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 x number of output variables)
i=1
}[Figure] 1,024[Figure]
#: This is the actual length of BLOB data passed as embedded variables from the UAP to the HiRDB server.

b: The result of the following formula is the largest memory value for a combination of SQL statements that search BLOB data while there are simultaneously open cursors.

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

c: Number of input variables

d: Number of cursors