Show TOC

SET DESCRIPTOR Statement [ESQL]Locate this document in the navigation structure

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 [, …] }

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 Database products—Supported by Open Client/Open Server.
Permissions