Server User Manual

an SQL statement is executed, the status code for the execution result is stored in the status variable.
Storage data
Data that is stored in a database space. The rows and columns of tables represent the logical aspect of data, and
stored data represents the physical aspect of data.
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, SEQUENTIAL structures, and
OBJECT structures; BTREE structures are the storage structures for indexes.
Related terms:
Physical structure, logical structure
Storage structure definition
The definition of mapping between tables and database spaces. The two kinds of storage structure definition are data
structure organization (DSO) definition and data structure instance (DSI) definition.
Structure host variable
A host variable declared as the structure type is called a structure host variable. When a structure host variable is
declared, each member is handled to correspond to individual columns in a database so that multiple-column data can
be manipulated in row units. Multiple rows can also be inserted at one time. A structure host variable can be used in
combination with a pointer variable to simplify the application program and improve maintainability.
System table
A table that manages definition information for, for example, databases and schemas defined by a SymfoWARE/RDB
user. The system table is also called the RDB dictionary.
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 constraint
Constraints on tables are unique constraints (UNIQUE or PRIMARY KEY)
Related terms:
Unique constraint
216