The CURRENT CLIENT_ACCTNG special register specifies a
VARCHAR(255) value that contains the value of the accounting string
from the client information specified for
the current
connection.
The default value of this register is the empty string.
The value of the accounting string can be changed through three interfaces.
- The Set
Client Information (SQLESETI) API can change the client special
register.
- In CLI, SQLSetConnectAttr() can be used to set the SQL_ATTR_INFO_ACCTSTR
connection attribute.
In ODBC, SQLSetConnectAttr() can be used to set
the ODBC_ATTR_INFO_ACCTSTR connection attribute.
- In JDBC, the setClientInfo connection method can be used to set
the ClientAccounting connection property.
Example
Get the current value of the accounting
string for this connection
VALUES CURRENT CLIENT_ACCTNG
INTO :ACCT_STRING