SQL/MX Glossary

Glossary
HP NonStop SQL/MX Glossary—523732-002
Glossary-10
distributed database
distributed database. A database whose objects reside on more than one node in a
network of nodes and whose objects can be accessed from any node in the network.
distributed transaction. A transaction that accesses data located on multiple nodes of a
network, or one that accesses data by means of requesters or servers at multiple
nodes of a network.
distribution service. When used in SQL/MX error messages, refers to the SQL/MX file
system.
DML. Data Manipulation Language. The set of data manipulation statements within the SQL
language.
DML statement. A statement used to select, update, insert, or delete rows in one or more
tables. Contrast with DCL statement and DDL statement.
dynamic input parameter. A question mark (?) in a dynamic SQL statement that serves as
a placeholder for a value substituted when the statement executes within a host
language program. An SQL statement that uses dynamic input parameters can be
compiled without the actual input values.
dynamic SQL. A programming technique that enables an application program to construct,
compile, and execute an SQL statement that is unknown until the program is
executing. Dynamic SQL supports interactive statements entered at the command line.
Contrast with static SQL.
E
ELF. See executable and linking format (ELF).
embedded module definition. Contains SQL/MX-specific information for each embedded
SQL statement of a program. For an embedded SQL program in C or COBOL, the
embedded module definition results by default from language compiling a module
definition source and linking it into a self-contained application executable. For an
SQLJ program, the embedded module definition results by default from customizing a
profile (.ser file) and is stored in the extended profile. The embedded module
definition is input for the module compiler. For details, see the SQL/MX Programming
Manual for C and COBOL or the SQL/MX Programming Manual for Java. Contrast with
module definition file (MDF).
embedded SQL. SQL statements in a host language program.
embedded SQL program. See SQL program
.
enqueue. To insert entries into a queue by using an INSERT statement.
entry-sequenced file. A file in which each new record is stored at the logical end of the file
in chronological sequence. The primary key is a system-generated record address.