DESCRIBE Statement [ESQL]

Gets information about the host variables required to store data retrieved from the database or host variables used to pass data to the database.

Quick Links:

Go to Parameters

Go to Examples

Go to Usage

Go to Standards

Go to Permissions

Syntax

DESCRIBE
   …[ USER TYPES ]
   …[ { ALL | BIND VARIABLES FOR | INPUT
   | OUTPUT | SELECT LIST FOR } ]
   …[ { LONG NAMESlong-name-spec ] | WITH VARIABLE RESULT } ]
   …[ FOR ] { statement-name | CURSOR cursor-name }
   …INTO sqlda-name

long-name-specOWNER.TABLE.COLUMN 
   | TABLE.COLUMN 
   | COLUMN }

Parameters

(back to top)

Examples

(back to top)

Usage

(back to top)

DESCRIBE sets up the named SQLDA to describe either the OUTPUT (equivalently SELECT LIST) or the INPUT (BIND VARIABLES) for the named statement.

Standards

(back to top)

  • SQL—Some clauses are vendor extensions to ISO/ANSI SQL grammar.
  • SAP Sybase Database product—Some clauses supported by Open Client/Open Server.

Permissions

(back to top)

None

Related reference
ALLOCATE DESCRIPTOR Statement [ESQL]
DECLARE CURSOR Statement [ESQL] [SP]
OPEN Statement [ESQL] [SP]
PREPARE Statement [ESQL]