SQL/MP Glossary

Glossary
Compaq NonStop™ SQL/MP Glossary—429832-001
Glossary-5
command interpreter
command interpreter. A process that manages interactive communication between the user
and the operating system, such as a TACL process.
compilation unit. All the data declarations and units of code specified for processing by one
run of a host language compiler.
concurrency. Access to the same data at the same time by two or more processes.
concurrent access. The ability of two or more processes to gain access to the same data at
the same time. See also browse access
and stable access.
consistency. See data consistency
.
constraint. An object that helps protect the integrity of data in a table by specifying a
condition or conditions that all the values in a particular column of the table must
satisfy. Unlike other SQL objects, a constraint has only an SQL name, not an operating
system name, and a constraint does not have a file label.
context of an SQLCI session. The collection of attributes that define the current default
catalog, message file, national character set, node, volume, subvolume, security,
PARAMs, and DEFINEs.
conversational interface. See SQLCI (SQL conversational interface)
.
correlated subquery. A subquery that references values retrieved by the outer query. A
correlated subquery requires repeated evaluation of the subquery for each row satisfying
the outer query. Contrast with noncorrelated subquery
.
correlation name. An alias associated with a table (or view) in an SQL statement and used to
distinguish the table from another table that has the same SQL identifier, to qualify an
ambiguous column reference, to distinguish separate uses of the same table, or to make
the query shorter. See also explicit correlation name
and implicit correlation name.
cursor. A named pointer used by an application program to indicate the current or next row
within a set of rows selected by an SQL query.
cursor name. An SQL identifier used to identify a cursor. A cursor name can be qualified by
a program name in COBOL85 programs.
cursor position. The current position of a cursor at, before, or after a row in a set of selected
rows.
cursor stability. The level of consistency that stable access provides. Contrast with
repeatable read
. See also stable access.
C-series node. A node running a C-series release version of the operating system.
data administrator. The person who specifies what data is needed by a business or
organization; the liaison between the business or organization user and the database
administrator.