![GOTO statement [T-SQL]](arrow-right.gif){kind=icon}
Retrieves information about variables within a descriptor area, or retrieves actual data from a variable in a descriptor area.
GET DESCRIPTOR descriptor-name
... { hostvar = COUNT } | VALUE n assignment [, ...] }
hostvar = { TYPE | LENGTH | PRECISION | SCALE | DATA | INDICATOR | NAME | NULLABLE | RETURNED_LENGTH }
For an example, see ALLOCATE DESCRIPTOR statement [ESQL].
The value n specifies the variable in the descriptor area about which information is 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.
None.
None
