Compiled SQL design

The compiled SQL uses "PreparedStatement"and enabled by setting the "Compiled SQL Statement" dataset property to True. The compiled SQL should be supported by each JDBC database.

The way of compiled SQL design with OZ parameter depends on the value of "use script" and "Compiled SQL Statement" dataset property.

Use script = "False", Compiled SQL Statement = "True"/"False"

Use #OZParam.parametername# or '#OZParam.parametername#' as a variable in the SQL statement.

•numeric type

SELECT * FROM tablename

WHERE fieldname = #OZParam.parametername#

•non-numeric type

SELECT * FROM tablename

WHERE fieldname = '#OZParam.parametername#'

Use script = "True", Compiled SQL Statement = "True"

Use #OZParam.parametername# or '#OZParam.parametername#' in the SQL statement text string.

•numeric type

string sql;

sql = "SELECT * FROM tablename WHERE fieldname = #OZParam.parametername#";

setQueryString(sql);

•non-numeric type

string sql;

sql = "SELECT * FROM tablename WHERE fieldname = '#OZParam.parametername#' ";

setQueryString(sql);

Use script = "True", Compiled SQL Statement = "False"

Use #OZParam.parametername# or '#OZParam.parametername#' as a variable in the SQL statement. For non-numeric OZ parameter, the single quotation mark should be included in the double quotation marks.

•numeric type

string sql;

sql = "SELECT * FROM tablename WHERE fieldname = " + #OZParam.parametername#;

setQueryString(sql);

•non-numeric type

string sql;

sql = "SELECT * FROM tablename WHERE fieldname = " + "'" + #OZParam.parametername# + "'";

setQueryString(sql);