Fujitsu 5.0L10 Manual Do Utilizador

he operational unit that requests data processing in the client/server model. When a database is used according to the 
client/server model, the application program requesting access to the server database operates in the client. 

   

 

A model used in data processing in which the operational unit (client) that requests data processing and the 
operational unit (server) that executes data processing are established separately. 

   

 

A grouping of columns that become a key for determining the page that stores data. Data for which cluster key values 
are equal is stored in the same bucket or overflow part bucket. Cluster keys are specified in the CLUSTER option of a 
table DSO definition. If cluster keys are omitted, the primary key of the corresponding table becomes the cluster key. 

   

 

A constituent element of a table. A relational database represents data using two-dimensional tables consisting of rows 
and columns. 

   

 

Column data types and column constraints 

   

 

Column constraints include the NOT NULL constraint (NOT NULL) and unique constraints (UNIQUE, PRIMARY KEY). 
Related terms: 

Unique constraint, NOT NULL constraint 

   

 

The name attached to a column as defined in the schema. The column name is used to specify a column that is the 
subject of an operation in an SQL statement that manipulates data. 

   

 

Makes the data manipulation of a transaction being processed take effect. The data manipulation in the transaction is 
physically reflected in the database. An application program deliberately controls a commit by issuing a COMMIT 
statement. 
Related term: 

Rollback 

   

 

202