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.
top
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
Options
The following options can be applied to the DESCRIBE command
in a WITH options clause of the DESCRIBE statement.
FETCH
FETCHKEYS
top
|