ODBC Server Reference Manual

Glossary
HP NonStop ODBC Server Reference Manual—429151-002
Glossary-14
trace statements [NonStop ODBC Server]
trace statements [NonStop ODBC Server]. The statements provided with the trace feature.
The trace statements are ALTER, CLEAR_LOG, DISPLAY_LOG, DROP_LOG, SAVE,
SET, SHOW, and SHOW_LOGS.
transaction [standard SQL]. A series of changes to one or more database tables that
transforms the data from one consistent state to another. TRANSACT-SQL supports
transactions; CORE SQL does not.
See also system-defined transaction [standard SQL] and user-defined transaction
[standard SQL].
Transaction Management Facility (TMF) subsystem [HP]. A product that helps to
maintain database consistency and protects the database against damage due to
system or media failures.
Transact-SQL (TSQL) [ODBC/SQL Server]. The SQL Server enhanced version of SQL.
The NonStop ODBC Server supports standard SQL; most enhancements are not
supported.
TSQL. See Transact-SQL (TSQL) [ODBC/SQL Server].
unaudited table. See nonaudited table [NonStop SQL/MP].
user catalog [NonStop SQL/MP]. A catalog that is not a system catalog. A user catalog is
created when you execute a CREATE CATALOG statement.
See also catalog [NonStop SQL/MP] and system catalog [NonStop SQL/MP].
user-defined transaction [standard SQL]. A transaction initiated with a BEGIN
TRANSACTION statement (in NonStop SQL/MP, the statement is BEGIN WORK).
See also transaction [standard SQL] and system-defined transaction [standard SQL].
utility statement. See catalog utilities [NonStop ODBC Server].
variable [SQL Server]. An entity that can assume any of a set of values. Local variables are
user-defined with the DECLARE statement; global variables are system-defined.
See also global variable [SQL Server] and local variable [SQL Server].
vector aggregate [SQL Server]. A value that results from using an aggregate function with
a GROUP BY clause.
The NonStop ODBC Server does not support vector aggregates or the GROUP BY
clause.
See also scalar aggregate function [ODBC/SQL Server] .
wild-card character [standard SQL]. A special character, the underscore (_) or the percent
sign (%), used with the LIKE keyword to stand for one or any number of characters in
pattern matching.