The DESCRIBE CURSOR -statement obtains information about the result set that is associated with the cursor. The information, such as column information, is put into a descriptor.

DESCRIBE

Use DESCRIBE CURSOR for result set cursors from stored procedures. The cursor must be defined with the ALLOCATE CURSOR statement.

Example 1:

Place information about the result set associated with cursor C1 into the descriptor named by :sqlda1.

EXEC SQL DESCRIBE CURSOR C1 INTO :sqlda1 

Example 2:

Place information about the result set associated with the cursor named by :hv1 into the descriptor named by :sqlda2.

EXEC SQL DESCRIBE CURSOR :hv1 INTO :sqlda2

So, the DESCRIBE CURSOR  is a part of Stored procedures.

DECLARE

The DECLARE CURSOR statement -defines a cursor. This statement can only be embedded in an application program. It is not an executable statement. It must not be specified in Java.

Related posts