%ProcessInstance meta-SQL element

Description

Use the %ProcessInstance meta-variable to specify the numeric (unquoted) process instance.

Note:

It is recommended not to use %ProcessInstance inside a SQL step. %ProcessInstance is always replaced by the literal value before being sent to the database; whereas, %Bind(PROCESS_INSTANCE) is passed as a bind value. So, even though the ReUse flag for all of SQLs are set, Process Instance values are sent as referrals and that forces a parse each time the SQLs are executed.