Filter
Top Products
Related term:
Reference mode
UPDATE statement
The UPDATE statement is a SQL data manipulation statement used to update data in table rows.
Upgrade
Index update processing. In conjunction with data update, insertion, and deletion processing in a table, this process
updates indexes attached to that table to reflect the latest status. This processing is called upgrading indexes.
View definition
The definition of a view in a logical structure definition. The view definition defines the portion of the base table that
forms the view, the name of the view, and the name of each column.
WHERE clause
In an SQL data manipulation statement, the WHERE clause is a search condition that specifies rows to be
manipulated.
Work table
A temporary table the SymfoWARE/RDB system uses for manipulating data. Intermediate results often must be saved
when the SymfoWARE/RDB system executes operations on data. A table that saves intermediate results is called a
work table. A work table of up to a specified fixed amount uses virtual memory. When a work table exceeds the fixed
amount, it uses a sort work area on magnetic disk. The amount of virtual memory to use can be specified in the
application environment file.
Related terms:
Sort work area
Working sort area
A temporary area used for sorting by the SymfoWARE/RDB system. If the SymfoWARE/RDB system has to sort data
during data manipulation, loading, or unloading, it sorts this data in a work area for sorting. This work area for sorting
is called the working sort area. Up to a fixed amount of virtual storage is used for a working sort area. However, when
this amount is exceeded, a sort work area on magnetic disk is used. The amount of virtual storage to be used can be
specified in the operating environment file.
Related terms:
Sort work area
218