Fujitsu 5.0L10 Manual Do Utilizador

Connection refers to the relationship that connects a client to a server. A connection is made by specifying a 
CONNECT statement in an application program. Conversely, a DISCONNECT statement cuts off the connection. 

   

 

A cursor is an indicator that indicates a row to be manipulated. A cursor is defined by a cursor declaration statement. 
The OPEN and CLOSE statements start and stop cursor operations, respectively. The FETCH statement moves the 
cursor. 

   

 

A cursor SQL statement is a data manipulation SQL statements that uses a cursor to specify rows to be manipulated. 

   

 

A data manipulation SQL is an SQL statement used to reference, add, delete, or update a database. 

   

 

A constituent element of a storage structure. The data part contains storage data corresponding to the table data 
(SEQUENTIAL structure or OBJECT structure) or data made up of index keys and table cluster keys (BTREE 
structure). 
Related term: 

Index part 

   

 

Expresses the storage structure for a table (base table). In addition to the information expressed in a DSO, a DSI 
expresses a mapping to a database space. The relationship between a DSO and a DSI can be one-to-one or 
one-to-many. A one-to-many relationship occurs only when a split table operation is applied. 
Related terms: 

Storage structure, DSO 

   

 

Storing the initial data in empty base tables immediately after database definition. SymfoWARE/RDB utilities are used. 

   

 

Many database can be created as units of administration and design on one server system. To identify each database 
uniquely, each is assigned a unique name (database name) on the server system. 

   

 

203