Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


SET DESCRIPTOR


Set values in an SQL descriptor area.

where set-item-information is:

Usage

Embedded.

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.

Restrictions

None.

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:

Type
Implicitly set fields
BINARY
LENGTH set to 1
BINARY VARYING
LENGTH set to 1
CHARACTER
LENGTH set to 1
VARCHAR
LENGTH set to 1
NATIONAL CHARACTER
LENGTH set to 1
NCHAR VARYING
LENGTH set to 1
DATETIME
PRECISION set to 0
DECIMAL, NUMERIC
PRECISION set to 15, SCALE set to 0
FLOAT, DOUBLE PRECISION
PRECISION set to 16
INTEGER
PRECISION set to 10
INTERVAL
DATETIME_INTERVAL_PRECISION set to 2
REAL
PRECISION set to 7
SMALLINT
PRECISION set to 5

Example

 EXEC SQL SET DESCRIPTOR :descriptor value :n type = :type,
                                            length = :length;

Standard Compliance

Standard
Compliance
Comments
X/Open-95
SQL-92
YES
Fully compliant.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX