SQL/MX Glossary

Glossary
HP NonStop SQL/MX Glossary—523732-002
Glossary-16
inner query
inner query. A subquery nested within a statement or another subquery. See also outer
query and subquery.
inner table. In the evaluation of a join, the table that the executor accesses after the outer
table.
INOUT parameter mode. The mode of a parameter that passes data to and accepts data
from a user-defined routine. Contrast with IN parameter mode and OUT parameter
mode.
Insert/update/delete. A group of three operations that are used to change data in SQL/MX
tables.
integrity constraint. A condition that must be met before rows can be inserted or columns
updated in the table for which the constraint is defined. This declarative condition helps
to maintain data integrity. See also constraint and data integrity.
INTERVAL data type. A data type for year-month and day-time values that represents
intervals of time. INTERVAL data consists of formatted values for one or more fields:
either YEAR, MONTH, and DAY or HOUR, MINUTE, and SECOND.
INTERVAL expression. An SQL value expression built from operands such as interval
literals, column names with datetime or interval values, datetime or interval value
functions, host variables or any set functions, scalar subqueries, CASE expressions, or
CAST specifications that return interval values.
INTERVAL literal. A literal that has the INTERVAL data type.
INTERVAL qualifier. See range of INTERVAL fields.
isolation level. A transaction level of data concurrency that is either read uncommitted,
read committed, repeatable read, or serializable. You can set the isolation level of a
transaction explicitly by using a SET TRANSACTION statement, by including an
access clause in SQL statements, or by using defaults.
iterator. A Java object that retrieves rows from the result table of a query in an SQLJ
program. An iterator is similar to a cursor, except that an iterator can be passed as a
parameter to a Java method. See also named iterator and positioned iterator.
IUD. Insert/update/delete. This abbreviation is often used to group together these three
operations that change data in SQL/MX tables. See also Insert/update/delete.
J
Java class. A building block of a Java program that consists of a class declaration, variable
(or field) declarations, and methods. A Java class serves as a template for Java
objects.