ODBC Server Reference Manual

Glossary
HP NonStop ODBC Server Reference Manual—429151-002
Glossary-13
system-defined transaction [standard SQL]
See also catalog [NonStop SQL/MP], CATALOGS table [NonStop SQL/MP], and user
catalog [NonStop SQL/MP].
system-defined transaction [standard SQL]. A transaction initiated by the system to
protect the consistency of the database.
See also transaction [standard SQL] and user-defined transaction [standard SQL].
system procedures [SQL Server]. Special stored procedures that SQL Server supplies to
retrieve information from system tables or to update information in system tables.
The NonStop ODBC Server does not support system procedures.
See also system tables [SQL Server].
system services [HP]. The tasks performed on behalf of the user or user programs by the
operating system, including formatting, process control, I/O support, performance
measurement, NonStop process-pair support, standard security, and transaction
management.
system tables [SQL Server]. The tables that compose the data dictionary. The system
tables keep track of information about SQL Server as a whole and about each user
database. The master database contains some system tables that are not in user
databases.
TCP/IP (Transport Communication Protocol/Internet Protocol) [industry-standard
term]. A set of data communications protocols at the transport (TCP) and network (IP)
layers that conform to U.S. Department of Defense standards.
temporary table [SQL Server]. A table that exists only during the current work session. A
temporary table disappears either when it is dropped or at the end of the session. You
specify a temporary table by beginning the table name with a pound symbol (#).
The NonStop ODBC Server supports temporary tables.
TMF. See Transaction Management Facility (TMF) subsystem [HP].
trace feature [NonStop ODBC Server]. A utility the NonStop ODBC Server provides for
recording information such as statements executed, NonStop SQL/MP statements
generated, and output and error messages returned.
trace flag [NonStop ODBC Server]. The flags you set to control the trace information that
the NonStop ODBC Server logs. The trace flags are MODE, LOG_TABLE,
LOG_TERM, IN_STREAM, OUT_STREAM, NSSQL, TSQL, PROD, and ERROR.
trace log [NonStop ODBC Server]. The information the NonStop ODBC Server generates
when you set trace flags. Trace logs are stored in SQL tables.
See also log table [NonStop ODBC Server].