Fujitsu J2X0-1634-01EN Manual Do Utilizador

A target specification is used to fetch values stored in a database to an application program. The target specification is 
specified as a variable. 

   

 

A trigger definition defines the data manipulation (insertion) of a table linked to the data manipulation (insertion, 
deletion, update) of another table. 

   

 

A constraint on a table or column. This constraint requires that a table cannot have multiple rows having the same 
value in a column or combination of columns. 

   

 

In an SQL data manipulation statement, a cursor that can be used to update and delete is called an updatable cursor. 
The cursor declaration specifies whether a cursor is updatable. For example, if a table specified in the FROM clause 
of a query specification satisfies just one condition, the cursor is an updatable cursor. 

Related term: read-only cursor 

   

 

The UPDATE statement is an SQL data manipulation statement used to update data in rows of tables. 

   

 

A value expression is a column specification, variable specification, set function, or literal, or a specification in which 
arithmetic operators (+, -, *, and /) are used to combine these items. 

   

 

A value specification, specified from an application program, specifies a value to be stored in, or compared with, a 
value stored in a data base. A value specification can be specified with a variable specification, literal (numeric, 
character-string, or national-language character-string), the keyword USER, or a dynamic parameter specification.   

   

 

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

 

218