ODBC Server Reference Manual

HP NonStop ODBC Server Reference Manual—429151-002
Glossary-1
Glossary
This glossary defines terms used in this manual. Because this manual discusses
several products, the glossary indicates which of the following products or categories
are associated with each term:
•
NonStop ODBC Server
•
NonStop SQL/MP
•
ODBC
•
SQL Server
•
Both NonStop SQL/MP and ODBC/SQL Server
•
Standard SQL
•
HP
•
Industry-standard term
aggregate function [standard SQL]. A function that generates a summary value from a
group of values in a specified column. The aggregate functions in both HP NonStop
SQL/MP and SQL Server are AVG, SUM, MIN, MAX, and COUNT.
See also row aggregate function [SQL Server], scalar aggregate function [ODBC/SQL
Server], and vector aggregate [SQL Server].
alias [SQL Server]. A temporary name give to a table (in the FROM clause) when it is joined
with itself in a self join. The temporary table names are then used to qualify the column
names in the join.
In NonStop SQL/MP, aliases are called correlation names.
See also correlation name [NonStop SQL/MP].
application program interface (API) [industry-standard term]. The set of functions or
procedures that permits user programs to communicate with a host operating system.
audited table [NonStop SQL/MP]. A table flagged for auditing by the Transaction
Management Facility (TMF). TMF monitors all transactions against an audited table in
preparation for transaction backout, autorollback, or rollforward recovery.
See also nonaudited table [NonStop SQL/MP] and Transaction Management Facility
(TMF) subsystem [HP].
batch [SQL Server]. One or more TRANSACT-SQL statements terminated by an end-of-
batch signal, which submits them to SQL Server for processing.
browse access [NonStop SQL/MP]. The access option for transaction consistency that
provides immediate access to data, but the data could be inconsistent because it might
be changing in an incomplete transaction. With this access, a process does not acquire