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:

{ c (actual length of BLOB input variable i# + 118 + 70 number of output variables) i=1 } 1,024

#: 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 {280 + 184 (number of tables specified in SQLi + 1)} i=1

c: Number of input variables

d: Number of cursors