In an embedded program, constant expressions can be expressed in the select_stmt with host language string variables. If the select_stmt includes a WHERE clause, a host language string variable can be used to specify the entire WHERE clause qualification. Specify the WITH clause using a host string variable (with :hostvar).