Filter
Top Products
Split condition
When a split table operation is applied, the rule for dividing data into split units is called the split condition. The split
condition specifies a list of column names representing split keys and a list of dummy values in which "?" is specified.
A split condition is specified in table DSO definition.
Related terms:
Split key, split key value
Split key
he key used to locate data by dividing it into split units when applying split table operation. This key corresponds to a
specific column (or multiple columns) of a table.
Related terms:
Split value, split condition
Split value
The value for a "?" specified in a split condition in a table DSO definition that is specified using a constant when the
table DSI is defined. This value applies to split table operation. Data stored in the defined DSI is a row in which
evaluation of the condition is true when the "?" in the split condition is replaced by the split value.
Related term:
Split key, split condition
Split table operation
SymfoWARE/RDB allows splitting a single logical base table into physically separate tables. Splitting tables speeds up
the access to a large database and ensures practicality from an operations standpoint. For example, a sales table for
all stores can be split by store. An application program can apply split table operation without giving it special
consideration. Moreover, database tuning tasks and database save operations can be performed independently and
concurrently in the split units.
SQL
SQL is a standard database language for performing database definition and data manipulation. SymfoWARE/RDB
basically conforms to the protocols of the international standards IS 9075, JIS X3005, and ANSI X3.135.
SQL embedded host program
In an application program that manipulates a data base, the parts of the program that perform database processing
are written using SQL statements. The parts of the program that perform other kinds of processing are written using a
programming language such as C language or COBOL. Application program in which SQL statements are embedded
are called SQL embedded host programs. The following terms are used for application programs that contain
embedded SQL statements:
a. SQL embedded C program
b. SQL embedded COBOL program
SQL embedded host program is the generic term for a) and b).
Status variable
The status variable, SQLSTATE, reports the processing result of an SQL statement to an application program. When
215