Try OpenEdge Now
skip to main content
SQL Reference
JDBC Reference : Java Class Reference : SQLIStatement : SQLIStatement.rowCount : Throws
 
Throws
DhSQLException

Example

This example uses the rowCount method of the SQLIStatement class by nesting the method invocation within SQLResultSet.set to store the number of rows affected (1, in this case) in the procedure's result set:
CREATE PROCEDURE sis_rowCount()
RESULT ( ins_recs INTEGER )
BEGIN
SQLIStatement insert_test103 = new SQLIStatement (
"INSERT INTO test103 (fld1) values (17)");
insert_test103.execute();
SQLResultSet.set(1,new Long(insert_test103.rowCount()));
SQLResultSet.insert();
END