The USING clause is an optional clause that provides certain OpenSQL statements with dynamic capabilities. The USING clause directs OpenSQL to use the variables pointed to by the sqlvar elements of the SQLDA (or other host variables) when executing the statement.

The USING clause has the following syntax:

For details about the EXECUTE statement, see How to Execute a Dynamic Non‑select Statement (see page How to Execute a Dynamic Nonselect Statement). For details about the EXECUTE IMMEDIATE statement, see How to Execute a Dynamic Select Statement (see page How to Execute a Dynamic Select Statement).