ODBC Server Installation and Management Manual
Managing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
4-38
Logging to a Terminal
Logging to a Terminal
If you want to log to a terminal, set the LOG_TO_TERMINAL trace option to Y. When
tracing is enabled (by setting the TRACE_MODE_ON option), using the
LOG_TO_TERMINAL option causes the trace information to be sent to the terminal
used to start the SCS process.
Displaying Trace Options
You can display the trace options currently in effect after a client has logged on the
client by use of the pass-through statement SHOW:
SELECT "tdm: show *"
The following is an example of the output of this statement:
Show Value Current Setting
---------------------------- --------------------------------------
USER_NAME SQL_DAVE
PROFILE_NAME DEFAULT
DATABASE_NAME MASTER
SQL_MAX_STATEMENT_CACHE 0
SQL_ACCESS_MODE RW
SQL_CURSOR_MODE RW
SQL_DIALECT TSQL
SQL_MAX_ROWS 0
SQL_MAX_STATEMENT_COST 0
SQL_TXN_ISOLATION 1
SQL_UNSUPPORTED ERROR
TRACE_MODE_ON YES
LOG_TABLENAME TESS_PUMA_DCTEST.LOG
LOG_TO_TERMINAL NO
INPUT_STREAM YES
OUTPUT_STREAM NO
NSSQL YES
TRACE_ERROR NO
CACHE_STATISTICS NO
SP_READ NO
SP_WRITE NO
Developing Custom Applications
The NonStop ODBC Server catalog tables are normal SQL tables, which are
themselves registered in the NonStop ODBC Server catalog tables. Therefore, it is
possible to access the catalog tables directly from a client by using a third-party tool or
by developing custom applications or scripts.
You should not develop applications or use tools to update the NonStop ODBC Server
catalog tables directly, however. The reason for this is that the integrity rules defined
Note. Yo u must pause the terminal used for displaying the trace before starting the trace;
otherwise, the NonStop ODBC Server hangs, waiting to output trace information. In addition,
you should not send trace output to a workstation running an application sending requests to
NonStop ODBC Server. For example, in a Windows environment, you should not use one TTE
window for tracing and another to run Microsoft Access to send requests to the NonStop
ODBC Server.