SQL/MP Glossary

Glossary
Compaq NonStop™ SQL/MP Glossary—429832-001
Glossary-29
SQL statistics area
SQL statistics area. See SQLSA (SQL statistics area).
SQL string. A character string embedded in a host program, or entered dynamically at run
time, that consists of a single SQL statement or a single preprocessor or compiler
directive. When embedded, an SQL string begins with the keywords EXEC SQL.
SQL system catalog format version. See system catalog format version
.
SQL system catalog version. See system catalog version
.
SQL system version. See software version
.
SQLCA (SQL communications area). An area, allocated by applications containing
embedded SQL statements, in which the NonStop SQL/MP executor stores information
about the success or failure of an SQL statement after its execution. The SQLCA
contains any error codes and messages and, for DML statements, specifies the number
of rows changed by the statement.
SQLCAT. See catalog manager
.
SQLCI (SQL conversational interface). A line-oriented terminal interface that enables a
user to enter NonStop SQL/MP statements and commands, format and run reports, and
operate database utilities. Contrast with programmatic SQL
.
SQLCOBOL. See SQL preprocessor
.
SQLCOMP. See SQL compiler
.
SQLDA (SQL descriptor area). An area allocated by an application to store information
about input parameters and output variables in dynamic SQL statements.
SQLSA (SQL statistics area). An area, reserved for each process, in which the
NonStop SQL/MP executor stores statistics about an SQL statement following its
execution. The SQLSA contains the number of tables and rows accessed by the
statement.
SQLUTIL. The NonStop SQL/MP component that contains the SQL utility programs.
stable access. An access option for transaction consistency that ensures that no other user can
access data locked by a transaction or indicated by the current position of a cursor,
except with browse access. With stable 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 completes. Of the access
options, stable access provides a medium level of consistency and concurrency. Contrast
with browse access
and repeatable access. See also cursor stability.
static SQL compilation. See explicit SQL compilation
.
stored command. A command that SQLCI saves for future access during a session.