Determining the Number of Cache Instances Affected by an Operation

You can use mechanisms to determine how many cache instances were loaded by a LOAD CACHE GROUP statement, refreshed by a REFRESH CACHE GROUP statement, flushed by a FLUSH CACHE GROUP statement, or unloaded by an UNLOAD CACHE GROUP statement.

  • Call the SQLRowCount() ODBC function.

  • Invoke the Statement.getUpdateCount() JDBC method.

  • Call the OCIAttrGet() OCI function with the OCI_ATTR_ROW_COUNT option.