Progress
SQL-92
Guide and Reference


SQLCursor

Allows rows of data to be retrieved from a database or another stored procedure’s result set.

Constructors

SQLCursor (String statement)

Parameters
statement

Generates a result set. Enclose the SQL statement in double quotes. The SQL statement is either a SELECT or CALL statement.

NOTES

Throws

DhSQLException

EXAMPLES

The following excerpt from a stored procedure instantiates an SQLCursor object called cust_cursor that retrieves data from a database table:

SQLCursor empcursor = new SQLCursor ( "SELECT name, sal FROM emp " ) ; 

The following excerpt from a stored procedure instantiates an SQLCursor object called cust_cursor that calls another stored procedure:

t_cursor = new SQLCursor ( "CALL get_customers (?) ") ; 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095