ODBC Server Reference Manual
Glossary
HP NonStop ODBC Server Reference Manual—429151-002
Glossary-2
browse mode [SQL Server]
a lock on the data it accesses and does not test for existing locks before reading data.
Browse access can be specified only for reading data. Of the access options, this
access provides the lowest consistency but the highest concurrency. In the HP
NonStop ODBC Server, browse access is available only in pass-through mode.
See also browse mode [SQL Server], repeatable access [NonStop SQL/MP], and
stable access [NonStop SQL/MP].
browse mode [SQL Server]. A method of viewing data while performing updates. The FOR
BROWSE clause is used in a SELECT statement.
The NonStop ODBC Server does not support browse mode or the FOR BROWSE
clause.
See also browse access [NonStop SQL/MP].
call-level interface (CLI) [standard SQL]. A library of function calls that support SQL
statements. The ODBC interface is a CLI.
catalog [NonStop SQL/MP]. A set of NonStop SQL/MP tables containing the descriptions of
objects such as tables, columns, indexes, views, files, and partitions.
See also catalog table [NonStop SQL/MP] and database [industry-standard term].
catalog table [NonStop SQL/MP]. One of the tables in a catalog; each table describes
objects such as tables, columns, views, and indexes. Any authorized user can read a
catalog table, but only a NonStop SQL/MP licensed process can update a catalog
table.
CATALOGS table [NonStop SQL/MP]. A directory table in the system catalog that contains
one entry for each catalog in that system. The table name is SQL.CATALOGS.
catalog utilities [NonStop ODBC Server]. Statements provided by the NonStop ODBC
Server for maintaining customized catalogs. The utility statements can be run using the
NonStop ODBC Server or can be entered from a TACL prompt.
client [industry-standard term]. The portion of a client/server architecture that provides
application and user interface resources. Clients are usually workstations or PCs.
See also client/server architecture [industry-standard term].
client application [industry-standard term]. An application running on a client accessing
data on a server. A client application is sometimes called a client.
See also client [industry-standard term] and workstation-based tool [industry-standard
term].
client/server architecture [industry-standard term]. A computer architecture that divides
work between a client and a server. The client provides application and user interface
resources, and the server stores, retrieves, and protects data. Client/server