Executing Dynamic Cursor Specifications
Unlike static Embedded SQL, when you perform a cursor SELECT with dynamic ESQL, you cannot predict in advance the number of columns in the result, nor the data types of these columns. Instead, your application must have some way of handling and storing the results dynamically at run time.
Therefore, ESQL support for cursor SELECT statements in dynamic ESQL includes the following:
NOTE: Multiple simultaneous cursors are supported for both static and dynamic ESQL.This section provides a detailed description of the typical steps for executing a dynamic cursor SELECT statement using Progress/ESQL. The examples shown are taken, in part, from the dynamic ESQL demo application (
dyndemo.cc
) provided with your ESQL installation.NOTE: In dynamic ESQL, make all single-row statements using cursor selects. Dynamic ESQL does not support the singleton SELECT (SELECT...INTO statement).
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |