SQL/MX Glossary

Glossary
HP NonStop SQL/MX Glossary—523732-002
Glossary-33
SQL conversational interface (SQLCI)
SQL conversational interface (SQLCI). See SQLCI.
SQL declare section. A section within a C or COBOL program used to declare host
variables. An SQL declare section begins with BEGIN DECLARE SECTION and ends
with END DECLARE SECTION.
SQL descriptor area. An area that contains multiple item descriptor areas, together with a
count of the number of areas. An item descriptor area is used to store information
about each input parameter and output variable in a dynamic SQL statement in a C or
COBOL program.
SQL diagnostics area. An area that contains completion and exception information for the
execution of an embedded SQL statement in a C or COBOL program. At the beginning
of execution, the diagnostics area is emptied. When the statement executes, SQL/MX
places information about completion or exception conditions into this area.
SQL executor. See executor.
SQL identifier. A name used to identify a table, view, column, and constraint, user-defined
routine, or parameter to a user-defined routine. There are two types of identifiers:
regular and delimited. Delimited identifiers are enclosed within double quotation
characters and can include any character in the SQL-92 special character set. An
identifier of either type can contain up to 128 characters.
SQL message code. An integer that uniquely identifies an SQL/MX error or warning. The
value of this code is returned in the SQLCODE variable in an embedded SQL
application. See the SQL/MX Messages Manual for a list of SQL message codes. See
also SQLCODE.
SQL module. See module.
SQL module definition file. See module definition file (MDF).
SQL object. A database entity that is created, manipulated, or dropped by SQL statements
and that is described in system metadata tables. SQL/MP objects are tables, views,
indexes, collations, and constraints. SQL/MX objects are tables, views, indexes,
constraints, locks, triggers, the trigger’s temporary table, stored procedures, and
SQL/MP aliases.
SQL optimizer. See optimizer.
SQL parameter. A name specified in a prepared embedded SQL statement in a C or
COBOL program or in a prepared MXCI or SQLCI command for which you substitute a
value when executing the statement or command. A parameter has a data type. See
also dynamic input parameter and MXCI parameter.
SQL preprocessor. The SQL/MX component that processes a C, C++, or COBOL
language source program with embedded SQL statements for subsequent compilation
and execution. The preprocessor generates two output files: a host language program