ODBC Server Reference Manual

Glossary
HP NonStop ODBC Server Reference Manual—429151-002
Glossary-12
SQL Server
SQL Server. An SQL-based relational database management system. The server maintains
the database and handles queries to and responses from the database. Through the
server, client applications such as NExpert Object, Paradox, and SQL File can access
the database.
SQL Server Gateway [HP]. A HP product available with the C30.00 RVU that provides
connectivity between DBLIB clients on PCs or UNIX workstations to NonStop SQL/MP.
NonStop ODBC Server supports HP SQL Server Gateway clients. HP SQL Server
Gateway is superseded by the NonStop ODBC Server product on D20 and subsequent
D-Series releases.
SQL Server identifier [SQL Server]. The name of a database object. An identifier can be
from 1 to 30 characters long. The first character must be a letter, a pound symbol (#),
or an underscore (_). The remaining characters can be letters, digits, or the symbols #,
$, and _. (A table name beginning with the pound symbol (#) denotes a temporary
table.) Embedded spaces are not allowed.
SQLCI (SQL Conversational Interface). [NonStop SQL/MP]. A line-oriented terminal
interface that enables a user to enter SQL statements, format and run reports, and
operate database utilities.
stable access [NonStop SQL/MP]. The access option for transaction consistency that
guarantees that no other user can change data that is locked or indicated by the
current position of a cursor. With this access, a process tests for existing locks before
acquiring its own, then holds the locks on queried data only until the next row is read
and holds the locks on modified data until the transaction finishes. Of the NonStop
SQL/MP access options, this access provides a medium level of consistency and
concurrency.
See also browse access [NonStop SQL/MP] and repeatable access [NonStop
SQL/MP].
stand-alone mode [NonStop ODBC Server]. The mode required to enter a catalog utility
statement at a TACL prompt.
See also catalog utilities [NonStop ODBC Server].
stored procedure [both ODBC and SQL Server]. A collection of SQL statements stored
under a name, executed by invocation of that name. Stored procedures supplied by
SQL Server are called system procedures.
system [HP]. A HP system that consists of from 2 to 16 processors on a dual
communication path (DYNABUS)
A system in a network of systems is called a node.
system catalog [NonStop SQL/MP]. The catalog that describes the CATALOGS table. The
system catalog resides in an SQL subvolume of each system ($SYSTEM.SQL, by
default).