User`s guide

exec
7-121
Output Arguments
curs — Database cursor
database cursor object
Database cursor, returned as a database cursor object. The properties of this object are
different based on the database connection object.
For a JDBC/ODBC bridge or a JDBC driver database connection, the cursor object has
the following properties.
Property Description
Attributes Not used.
Data Contains the resulting data after executing fetch.
DatabaseObject Database connection object or database.ODBCConnection
object that opened the cursor object.
RowLimit Number of rows to fetch at a time.
SQLQuery SQL statement to execute.
Message Contains the error messages generated from executing the
SQL statement. If this property is empty, then the SQL
statement executed successfully.
Type Database cursor object or database.ODBCCursor object type.
ResultSet Java result set object.
Cursor Internal Java representation of a cursor object.
Statement Java statement object.
Fetch Internal Java representation of the fetched data.
Scrollable Contains a logical value to identify the cursor object as
scrollable or basic. This property is set to 1 for a scrollable
cursor and 0 otherwise. This property is hidden and read only.
Position Contains a number that specifies the current position of the
cursor in the data set. This property is only available for a
scrollable cursor. This property behaves differently for native
ODBC, JDBC, and different database drivers. This property is
read only.