Using the VALUE Clause

Use the VALUE clause to assign values from host variables into fields of a system-descriptor area. You can assign values for items for which you are providing a description (such as parameters in a WHERE clause), or you can modify values for items after you use a DESCRIBE statement to fill the fields for an UPDATE or INSERT statement.

Use the Item Descriptor portion of the SET DESCRIPTOR statement to set value for an individual field in a system-descriptor area.

Item Descriptor:
 
|--+-+-TYPE------+--=--+-literal_int_var-+---------------------+--|
   | +-LENGTH----+     '-literal_int-----'                     |
   | +-PRECISION-+                                             |
   | +-SCALE-----+                                             |
   | +-NULLABLE--+                                             |
   | +-INDICATOR-+                                             |
   | +-ITYPE-----+                                             |
   | '-ILENGTH---'                                             |
   |                                    (1)                    |
   +-+-DATA--+--=--+-| Literal Number |--------+---------------+
   | '-IDATA-'     |                      (2)  |               |
   |               +-| Literal DATETIME |------+               |
   |               |                      (3)  |               |
   |               +-| Literal INTERVAL |------+               |
   |               |                   (4)     |               |
   |               +-| Quoted String |---------+               |
   |               '-input_var-----------------'               |
   |                                                    (4)    |
   +-+-NAME-------------------+--=--+-| Quoted String |------+-+
   | |  (5)                   |     '-input_var--------------' |
   | +--------EXTYPENAME------+                                |
   | |  (5)                   |                                |
   | '--------EXTYPEOWNERNAME-'                                |
   |  (5)                                                      |
   '--------+-SOURCEID----------+--=--+-literal_int_var-+------'
            +-SOURCETYPE--------+     '-literal_int-----'
            +-EXTYPEID----------+
            +-EXTYPELENGTH------+
            '-EXTYPEOWNERLENGTH-'

Notes:

See page Literal Number
See page Literal DATETIME
See page Literal INTERVAL
See page Quoted String
Dynamic Server only

Element	Description	Restrictions	Syntax
input_var	Host variable storing data for the specified item descriptor field	Must be appropriate for the specified field	Language-specific
literal_int	Integer value ( > 0 ) assigned to the specified item descriptor field	Restrictions depend on the keyword to the left of = symbol	Literal Number, p. Literal Number
literal_int_var	Variable having literal_int value	Same as for literal_int	Language-specific

For information on codes that are valid for the TYPE or ITYPE fields and their meanings, see Setting the TYPE or ITYPE Field.

For the restrictions that apply to other field types, see the individual headings for field types under Using the VALUE Clause.