CLEAR_CONNECTION_OPTION

Applies to: SQLFlex

This command will clear any or all connections options that were set using SET_CONNECTION_OPTION. Passing the keyword ALL will remove all custom set connection options while passing a string value will clear just that option passed for the next login call. Connection options that CANNOT be cleared: Database, Server, FailoverPartner, MarsConn, uid, pwd, Trusted_Connection, wsid, app, AutoTranslate, Timeout.

Syntax

CLEAR_CONNECTION_OPTION ALL | {option}

Parameter

Description

option

The connection option to clear

Example

CLEAR_CONNECTION_OPTION "ApplicationIntent"