Sybase Adaptive Server Anywhere - GET DESCRIPTOR Statement [ESQL]

Chapter 9 SQL Statements
537
GET DESCRIPTOR statement [ESQL]
Use this statement to retrieve information about a variable within a descriptor
area, or retrieves its value.
GET DESCRIPTOR descriptor-name
…{ hostvar = COUNT | VALUE n assignment [, …] }
assignment:
hostvar = { TYPE | LENGTH | PRECISION | SCALE | DATA |
INDICATOR | NAME | NULLABLE | RETURNED_LENGTH }
None.
None.
"ALLOCATE DESCRIPTOR statement" on page 381
"DEALLOCATE DESCRIPTOR statement" on page 485
"SET DESCRIPTOR statement" on page 611
"The SQL descriptor area (SQLDA)" on page 45 of the book ASA
Programming Interfaces Guide
The GET DESCRIPTOR statement is used to retrieve information about a
variable within a descriptor area, or to retrieve its value.
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.
♦
SQL/92 Entry level feature.
♦
Sybase Supported by Open Client/Open Server.
♦ For an example, see "ALLOCATE DESCRIPTOR statement" on
page 381.
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility
Example