ODBC Server Reference Manual

Glossary
HP NonStop ODBC Server Reference Manual—429151-002
Glossary-11
scalar aggregate function [ODBC/SQL Server]
scalar aggregate function [ODBC/SQL Server]. An aggregate function that produces a
single value from a SELECT statement that does not include a GROUP BY clause.
This result is true whether the aggregate function is operating on all the rows in a table
or on a subset of rows defined by a WHERE clause.
See also vector aggregate [SQL Server].
SCS (SQL Communications Subsystem) [NonStop ODBC Server]. A NonStop ODBC
Server software component that runs on a NonStop server and implements the
communications protocols for data transfer between a client on a PC or workstation
and a NonStop ODBC Server process on a NonStop server.
select list [standard SQL]. The columns and expressions specified in the main clause of a
SELECT statement.
server [industry-standard term]. The server in a client/server architecture. The server
stores, retrieves, and protects data. Servers can be minicomputers, microcomputers,
mainframes, workstations, or specifically developed machines. When running the
NonStop ODBC Server, a HP system becomes a server.
See also client/server architecture [industry-standard term].
session. See connection [ODBC/SQL Server].
shared lock [both NonStop SQL/MP and SQL Server]. In NonStop SQL/MP, a lock
exclusion mode that allows any number of processes to read the same data but
prevents any process from writing to the locked unit or reading it with intent to rewrite.
In SQL Server, a lock created by nonupdate (read) operations. When a shared lock is
set, other users can read the data concurrently, but no transaction can acquire an
exclusive lock on the data until all the shared locks have been released.
See also exclusive lock [both NonStop SQL/MP and SQL Server].
shorthand view [NonStop SQL/MP]. A view that can be derived from one or more tables or
views by joining tables or views, by selecting columns, by projecting rows, or by a
combination of these; a shorthand view can be read but not updated or secured.
See also protection view [NonStop SQL/MP].
simple name [NonStop SQL/MP]. See SQL identifier [NonStop SQL/MP].
SQL (Structured Query Language) [industry-standard term]. A relational database
language used to define, manipulate, and control databases. SQL is the standard
language for relational database management systems.
SQL identifier [NonStop SQL/MP]. A name used for a column, constraint, cursor,
statement, or correlation. These names are never qualified by subvolume, volume, or
system names and cannot be SQL reserved words.