User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

Retrieves information about variables within a descriptor area, or retrieves actual data from a variable in a descriptor area

Syntax

     GET DESCRIPTOR descriptor-name
          ...{ hostvar=COUNT } | VALUEn assignment [,...] }

Parameters

     assignment:
          hostvar = { TYPE | LENGTH | PRECISION | SCALE | DATA | INDICATOR | NAME | NULLABLE | RETURNED_LENGTH }

Usage

Embedded SQL.

Permissions

None.

Side effects

None.

See also

• ALLOCATE DESCRIPTOR statement
• DEALLOCATE DESCRIPTOR statement
• SET DESCRIPTOR statement
• "The SQL descriptor area (SQLDA)"

Description

The Get descriptor statement is used to retrieve information about variables within a descriptor area, or to retrieve actual data from a variable in a descriptor area.

The value n specifies the variable in the descriptor area about which the information will be retrieved. Type checking is performed when doing GET ... DATA to ensure that the host variable and the descriptor variable have the same data type.

If an error occurs, it is returned in the SQLCA.

Example

For an example, see "ALLOCATE DESCRIPTOR statement".