SET DESCRIPTOR

Set values in an SQL descriptor area.

 

where set-item-information is:

 

Usage

Embedded, Module.

Description

Fields values are assigned in the specified SQL descriptor area. The SET DESCRIPTOR statement can be used in two forms. The COUNT form sets the number of active item descriptor areas for the specified SQL descriptor. The VALUE form assigns SQL descriptor field values for the item descriptor area specified by item-number.

The descriptor-name is identified by a host variable or a literal.

See GET DESCRIPTOR for a description of the descriptor fields.

Notes

The data type of the host variables must be compatible with the data type of the associated field name.

If an item descriptor area is specified for any field other than DATA, the DATA field becomes undefined.

When the TYPE field is set, some of the other fields are implicitly set according to the table below:

Example

exec sql SET DESCRIPTOR 'descrIn' VALUE :n TYPE = :type,

                                           LENGTH = :length;

Standard Compliance