JDBC programs use Statement.setMaxRows(int max) to limit the number of rows returned by a result set. In jConnect 7.0 and earlier, the result of the select, insert, update, and delete statements are counted against the limit.
To be consistent with the JDBC specification, jConnect 7.07 introduces the SETMAXROWS_AFFECTS_SELECT_ONLY connection property, which, when set to true (the default), limits only the rows returned by select statements.
SETMAXROWS_AFFECTS_SELECT_ONLY is ignored when connected to Adaptive Server 15.5 or earlier.