Inserting Rows into Result Sets

Insert a row using the JDBC 2.0 API.

There is no need to downcast to a SybCursorResultSet.
// prepare to insert
rs.moveToInsertRow();
// populate new row with column values
rs.updateString(1, "New entry for col 1");
rs.updateInt(2, 42);
// insert new row into db
rs.insertRow();
// return to current row in result set
rs.moveToCurrentRow();