8. SQL Statements : SET : Usage in OpenAPI, ODBC, JDBC, and .NET
 
Share this page                  
Usage in OpenAPI, ODBC, JDBC, and .NET
Note:  In OpenAPI, ODBC, JDBC, and .NET interfaces, the following SET commands are not supported:
SET CONNECTION NONE | connection_name
SET [NO]PRINTQRY
Note:  The following SET commands are supported through interface-specific mechanisms:
SET AUTOCOMMIT ON|OFF uses IIapi_autocommit().
SET SESSION [READ ONLY | READ WRITE] uses IIapi_setConnectParam(), IIapi_modifyConnect(), and/or IIapi_setEnvParam() in OpenAPI.
SET TRANSACTION uses IIapi_setConnectParam(), IIapi_modifyConnect(), and/or IIapi_setEnvParam() in OpenAPI.
All other SET statements can be sent as SQL.