Fujitsu J2X0-1634-01EN Manual Do Utilizador

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

   

 

A column name is the name assigned to a column, defined in the schema definition. The column name is used in SQL 
statements for data manipulation to specify a column to be processed. 

   

 

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 

   

 

The comparison predicate is a search condition specified using the comparison operators =, <, <=, >, >=, and <>. 

   

 

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. 

   

 

Correlation names are table names used by SQL statements for data manipulation to manipulate data. A correlation 
name is valid only for the SQL statement for which it is specified. 

   

 

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 statement 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 data base. 

208