(ODBC Manager Library)
Description: Called to display a window showing current ODBC driver statistics for both the main driver and any user-selected IO device addresses
Returns: Nothing
Usage: Steady State
Format: \ODBCManager\StatsWin( Enable, X, Y, ConnectionName)
Parameters: Enable { Boolean } { required } { no default: }
Set to true to display the statistics window
X { numeric } { required } { no default: }
The screen X position of the window
Y { numeric } { required } { no default: }
The screen Y position of the window
ConnectionName { text } { required } { no default: }
The name of the database connection to be shown.
Comments: This module is a member of the ODBCManager Library, and must therefore be prefaced by \ODBCManager\, as shown in "Format" above.
The statistics shown in the window include the following:
|
|
|
|
Data Source |
DSN |
|
db State |
dbState |
|
Last Execution Time |
ExecTime |
|
Last Execution Date |
ExecDate |
|
Connection Time |
Condt |
|
Execution Time |
Cmddt |
|
Sem Q Time |
Qdt |
|
Average Execution Time |
ACmddt |
|
Average Sem Q Time |
AQdt |
|
Execution Count |
ExecCount |
|
Error Count |
ErrCount |
|
Recovery Count |
RecoveryCount |
|
db Open Count |
OpenCount |
|
db Close Count |
CloseCount |
|
Semaphore Count |
SemCount |
|
Error Code |
Error |
|
Error |
Error |
|
Error Time |
ErrorTime |
|
Error Date |
ErrorDate |
|
Error Query |
ErrorQuery |
|
ODBC Error Code |
ODBCErrorCode |
|
ODBC Error Current |
ODBCErrorMsg |
|
ODBC SQL State |
ODBCSqlState |
|
Last Error Code |
LastError |
|
Last Error |
LastError |
|
Last Error Query |
LastErrorQuery |
|
Last ODBC Error Code |
LastODBCErrorCode |
|
Last ODBC Error Current |
LastODBCErrorMsg |
|
Last ODBC SQL State |
LastODBCSqlState |