SQL/MP Glossary

Glossary
Compaq NonStop™ SQL/MP Glossary—429832-001
Glossary-13
Guardian operating system
Guardian operating system. An environment available for interactive or programmatic use
with the Compaq NonStop Kernel Operating System. Processes that run in the Guardian
environment use the Guardian system procedure calls as their application program
interface; interactive users of the Guardian environment use the Compaq Tandem
Advanced Command Language (TACL) or another Compaq product’s command
interpreter. Contrast with Open System Services (OSS)
.
hash join. A join algorithm that replaces a sort with a faster hash operation to help improve
the performance of joins in which a merge join requires sorting a participating table.
Execution of a hash join reads the inner table of a join into memory, builds a hash access
path on the join attribute, and then performs a nested join. A hash join can use parallel
execution.
heading. A column attribute that specifies one or more lines of text to appear at the top of a
column in a report.
high PIN. A process identification number (PIN) in the range 256 PINs or greater.
host identifier. A name used in a host program to identify a program element such as a data
item, paragraph, or section.
host language. Any programming language whose statements can be combined with SQL
statements in the same source program. NonStop SQL/MP supports C, COBOL85,
Pascal, and TAL as host languages.
host language compiler. The C, COBOL85, Pascal, or TAL compiler.
host language compiler SQL version. See HSV (host language compiler SQL version)
.
host object SQL version. See HOSV (host object SQL version)
.
host program. A source program that contains both host language statements and embedded
SQL statements.
host variable. A variable declared in a host program that can be used by both host language
statements and embedded SQL statements in the same source program. A host variable
provides communications between the two types of statements. A host variable has an
SQL data type and can have an associated character set and collation.
HOSV (host object SQL version). A version that indicates the version of SQL information
in an SQL program file and the oldest version of the SQL compiler that can compile the
SQL program. The HOSV is stored in the SQL program file by the host language
compiler or by the SQL preprocessor. See also software version
and version number.
HSV (host language compiler SQL version). A version that NonStop SQL/MP assigns to a
host language compiler to indicate the NonStop SQL/MP software with which the
compiler is compatible. See also software version
and version number.