Commands

DESCRIBE

Describe the last executed SELECT statement. This command is used in conjunction with the BIND command.

AUTOFETCH must be set to OFF before executing a bind command.

SET AUTOFETCH OFF

Syntax

DESCRIBE [ON [CURSOR] cursor] [WITH options]

DESCRIBE
Required.

ON [CURSOR]
Both the ON and CURSOR keywords are optional.

cursor
Optional. Indicates the cursor number that the statement to be described was executed on. If omitted, the last statement executed on the current cursor in the status array will be described.

WITH options
Optional. A comma separated list of options to apply to this command.

Options

The following options can be applied to the DESCRIBE command in a WITH options clause of the DESCRIBE statement.

FETCH

FETCHKEYS

Example

>select count(*) from customers
count('*')
--------------
999

1 row returned

>describe
------------------------------------------------------------
Expr. (1) : count('*')
Occurrences : 1
Actual 0 : INTEGER 4
Request 0 : C STRING 12 VALUE EXP OVRFL
------------------------------------------------------------

Top