Reference Manual
   CHAPTER 9. SQL Statements     

SET DESCRIPTOR statement [ESQL]

Function 

Describes the variables in a SQL descriptor area, and places data into the descriptor area.

Syntax 

SET DESCRIPTOR descriptor-name
...{ COUNT = { integer | hostvar } | VALUE n assignment [,...] }

Parameters 

assignment:
{ TYPE | SCALE | PRECISION | LENGTH | INDICATOR }
... = { integer | hostvar }
| DATA = hostvar

Permissions 

None.

Side effects 

None.

See also 

ALLOCATE DESCRIPTOR statement

DEALLOCATE DESCRIPTOR statement

The SQL descriptor area (SQLDA)

Description 

The SET DESCRIPTOR statement is used to describe the variables in a descriptor area, and to place data into the descriptor area.

The SET ... COUNT statement sets the number of described variables within the descriptor area. The value for count must not exceed the number of variables specified when the descriptor area was allocated.

The value n specifies the variable in the descriptor area upon which the assignment(s) will be performed.

Type checking is performed when doing SET ... DATA, 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.

Standards and compatibility 

• SQL/92     Intermediate level feature.

• Sybase     Supported by Open Client/Open Server.

Example 

• For an example, see ALLOCATE DESCRIPTOR statement.