Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


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
CHARACTER 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

Standard Compliance

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



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