Using Host Variables

Host variables in SQL directly reference fields in the parameter struct or return value struct.

The rules for using host variables are as follows:

• host variables must be prefixed with a colon (:);
• host variables are case sensitive.

For example:

:surname

• if a field in the parameter struct or return value struct is a result of aggregation then the role name of aggregation is used for host variable.

For example:

:dtls (see One-to-One Aggregation)