ODBC Server Reference Manual

Glossary
HP NonStop ODBC Server Reference Manual—429151-002
Glossary-3
client, DBLIB/TSQL [NonStop ODBC Server]
architecture enables users to access shared data and resources. Clients and servers
run on a local area network.
client, DBLIB/TSQL [NonStop ODBC Server]. A type of client that uses the
Microsoft/Sybase TRANSACT-SQL (TSQL) dialect and makes DBLIB function calls. It
is a client for SQL Server and the HP SQL Server Gateway product.
client, ODBC/CORE [NonStop ODBC Server]. A type of client that uses the ODBC CORE
SQL dialect and makes ODBC CLI function calls. This is the basic ODBC client
application intended for maximum interoperability and portability.
client, ODBC/TSQL [NonStop ODBC Server]. A type of client that uses the TRANSACT-
SQL dialect, but makes ODBC CLI function calls. The expected use for this client is as
part of a migration path for applications moving from DBLIB to ODBC.
clustered index [SQL Server]. An index in which the physical order and the logical
(indexed) order is the same.
See also clustering key [NonStop SQL/MP].
clustering key [NonStop SQL/MP]. A group of columns that forms a non unique key to
determine the physical row order or partitioning of a key-sequenced table. The
columns of the clustering key together with the system-generated SYSKEY make up
the physical primary key for the table.
See also clustered index [SQL Server].
column alias [SQL Server]. A column heading, specified in the SELECT statement, that
replaces the default column heading (the column name).
See also column heading [NonStop SQL/MP].
column heading [NonStop SQL/MP]. A heading, specified in the SELECT statement, that
replaces the default column heading (the column name).
See also column alias [SQL Server].
communication driver [industry-standard term]. A unit of library code that is needed, along
with the HP NonStop ODBC/MP Driver, to use a particular communication transport
protocol. A separate communication driver is needed for each vendor’s communication
transport. With the NonStop ODBC Server product, HP supplies communication drivers
for Microsoft, FTP, Novell, and Winsock TCP/IP.
connection [ODBC/SQL Server]. An instance of a specific client and a specific server
communicating for a period of time (also called a session). A connection is initiated by
the client, but can be terminated by either the client or the server.
constraint [NonStop SQL/MP]. A DDL statement that helps protect the integrity of data in a
table by specifying rules that all values in particular columns of the table must satisfy.
See also rule [SQL Server].