Fujitsu 5.0L10 User Manual

Related term: 

Reference mode 

   

 

The UPDATE statement is a SQL data manipulation statement used to update data in table rows. 

   

 

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. 

   

 

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. 

   

 

In an SQL data manipulation statement, the WHERE clause is a search condition that specifies rows to be 
manipulated. 

   

 

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 

   

 

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