Fujitsu 5.0L10 User Manual

an SQL statement is executed, the status code for the execution result is stored in the status variable. 

   

 

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. 

   

 

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 

   

 

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. 

   

 

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. 

   

 

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. 

   

 

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. 

   

 

Constraints on tables are unique constraints (UNIQUE or PRIMARY KEY) 
Related terms: 

Unique constraint 

   

 

216