Describes the variables in an SQL descriptor area, and places data into
the descriptor area.
Syntax
SET DESCRIPTOR descriptor-name
… { COUNT = { integer | hostvar }
| VALUE n assignment [, …] }
assignment
{ { TYPE
| SCALE
| PRECISION
| LENGTH
| INDICATOR } = { integer
| hostvar }
| DATA = hostvar }
Parameters
(back to top)
- COUNT – sets the number of described variables within
the descriptor area. The value for count cannot exceed the number of
variables specified when the descriptor area was allocated.
- VALUE – the value n specifies the variable in the
descriptor area upon which the assignments are performed.
- DATA – type checking is performed when using the DATA
clause to ensure that the variable in the descriptor area has the same type
as the host variable. If an error occurs, the code is returned in the
SQLCA.
Examples
(back to top)
- Example 1 – see ALLOCATE DESCRIPTOR
Statement [ESQL].
Standards
(back to top)
- SQL—ISO/ANSI SQL compliant.
- SAP Sybase Database product—Supported by Open
Client/Open Server.