CurrentSQLID IBM data server driver configuration keyword
Specifies the ID used in a SET CURRENT SQLID statement sent to the DBMS upon a successful connection.
- Equivalent CLI keyword
- CurrentSQLID
- Equivalent IBM® Data Server Provider for .NET connection string keyword
- CurrentSQLID
- Equivalent IBM Data Server Driver for JDBC and SQLJ property
- currentSQLID
- db2dsdriver.cfg configuration syntax
<parameter name="CurrentSQLID" value="current_sqlid"/>- Default setting:
- No statement is issued.
- Usage notes:
Upon a successful connection, if the CurrentSQLID keyword is set, a SET CURRENT SQLID statement is sent to the DBMS. The CurrentSQLID keyword allows user and application to name SQL objects without having to qualify them by a schema name. On servers other than Db2® for z/OS®, setting CurrentSQLID keyword is equivalent to setting CurrentSchema keyword.