Filter
Top Products
an SQL statement is executed, the status code for the execution result is stored in the status variable.
Storage structure
A database structure along with logical structure and physical structure. Storage structure physically locates data
logically expressed as rows and columns of tables in a database as storage data. A storage structure is expressed
using DSO and DSI. The storage structures for base tables are RANDOM structures and SEQUENTIAL structures;
BTREE structures are the storage structures for indexes.
Related terms: physical structure and logical structure
Storage structure definition
The definition of mappings between tables and database spaces. The two kinds of storage structure definition are
data structure organization (DSO) definition and data structure instance (DSI) definition.
Subquery
A subquery is a specification used in an IN, comparison, quantified, or EXISTS predicate. The specification format is
the same as that for a query specification. However, only one column must be specified for the derived table.
Table
In a relational database, data is represented using two-dimensional tables consisting of rows and columns. The two
kinds of tables are base tables and view tables.
Table declaration
A table declaration declares the schema in which a table is located. If a table declaration is specified, the schema
name need not be specified for a table in data manipulation statements. Using a table declaration simplifies the
specification of table names. Using a table declaration also helps to make an application program independent of a
data base.
Table expression
In single row SELECT statements and query specifications, the part that specifies the table, row, and group for which
data is to be manipulated is the table expression. A table expression may contain the FROM, WHERE, GROUP BY,
and HAVING clauses.
Table name
A name attached to a table. Table names are set in schema definitions. Table names are used to specify the tables to
be made the subjects of operations in SQL statements that manipulate data.
217