TSQL_VARIABLES option [TSQL]

Function

Controls whether the @ sign can be used as a prefix for Embedded SQL host variable names.

Allowed values

ON, OFF

ON for Open Client and JDBC connections

Default

OFF

Description

When this option is set to ON, you can use the @ sign instead of the colon as a prefix for host variable names in Embedded SQL. This is implemented primarily for the Open Server Gateway.