SQL/MP Glossary

Glossary
Compaq NonStop™ SQL/MP Glossary—429832-001
Glossary-27
similarity information
similarity information. Information about an SQL object that the SQL compiler stores in the
program file. During subsequent recompilations, NonStop SQL/MP can use the
information to perform a similarity check. See also similarity check.
simple fileset list. A list of one or more filesets. Contrast with qualified fileset list
.
simple hash join. A hash join method in which the inner table is read into a memory-resident
hash table. The order of the outer table is preserved. See also hybrid hash join
.
single-byte character. A character that requires only one byte for storage.
single-byte character set. A character set consisting of characters that require only one byte
each for storage.
single-byte column. A column that has an associated single-byte character set.
software version. The version assigned to a particular release of the NonStop SQL/MP
product. All NonStop SQL/MP components on the same node must have the same
software version. The software version can be obtained by issuing the GET VERSION
OF SYSTEM command from SQLCI or from embedded SQL statements.
sort merge join. A join method that first sorts the base tables by join attributes, then merges
the sorted tables, and returns rows for matching attribute values.
SQL (Structured Query Language). A relational database language used to define,
manipulate, and control databases. SQL statements can be embedded in programs or
entered as commands through SQLCI.
SQL catalog format version. See catalog format version
.
SQL catalog manager. See catalog manager
.
SQL catalog version. See catalog version
.
SQL communications area. See SQLCA (SQL communications area)
.
SQL compile. To use the SQL compiler to generate an SQL program file.
SQL compile time. The time when a program is explicitly compiled by the SQL compiler
(SQLCOMP). Contrast with SQL load time
and SQL statement execution time.
SQL compiler. The NonStop SQL/MP component that compiles a set of SQL source
statements extracted from a source program by the SQL preprocessor or host language
compiler, generates SQL object code for each statement, forms a plan for executing each
statement against the database, and stores the code and plan in an SQL object program.
The SQL compiler also processes SQL statements entered through SQLCI.
SQL compiler interface. See SCI (SQL compiler interface)
.