R444 – SELECT uses constant value. Could use parameterised value to allow caching prepared statement (WMB)

SELECT uses constant value. Could use parameterized value to allow caching prepared statement (WMB)

Using a parameterized value during SELECT allows ACE/IIB to use a prepared statement that may be more efficient if multiple calls are required.

For example this doesn’t create a prepared statement:

SET Environment.Variables.DBResult2[] =SELECT * FROM Database.test_param_only AS S WHERE S.id = 123456;

But this does:
DECLARE lookup INTEGER;
SET lookup = 123456;
SET Environment.Variables.DBResult2[] =SELECT * FROM Database.test_param_only AS S WHERE S.id = lookup;

SELECT uses constant value. Could use parameterized value to allow caching prepared statement (WMB)
SELECT uses constant value. Could use parameterized value to allow caching prepared statement (WMB)