@rdbobak:  Most likely, the error message you are seeing is returned from the driver and potentially your insert/update/delete are executing a large number of rows into the table named TABLE. If the number of records affected is more than the max value of INT (depending on the RDBMS server, the value can be 231 = 2147483648 ) then the server will return this warning.

Could you please provide the following information to help us look into the issue:

Database is (IBM PureData) Netezza running 7.2.1.1.  My JDBC driver should also be the same version.  However ADS just says it is "7.2"

I'll email the Support Info.

The logs don't contain any info on this in particular.

The Update Count is retrieved with the JDBC API method :

https://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#getUpdateCount()

Which returns an INT.  Here is a Q&A on this specific scenario :

http://stackoverflow.com/questions/33780120/what-happens-when-the-number-of-updated-rows-exceeds-231

ADS 17.0 is compiled with Java 1.7.  ADS 18.0 is compiled with Java 1.8.  In ADS 18.0 we will be able to call the new API method :

https://docs.oracle.com/javase/8/docs/api/java/sql/Statement.html#getLargeUpdateCount--

But, this method will also only work if the JDBC driver is an updated driver that has this new method implemented.

Until this, this error message is coming from the JDBC driver.

Will move this issue to 18.0 for our current development process.

@tom: next step for this issue is to compile a list of JDBC that do support the getLargeUpdateCount() method

This is now supported in ADS v18, but it also requires the driver to support Statement.getLargeUpdateCount() which is part of the JDBC API 4.2 available in Java 1.8 and above.

Netezza current doesn't support this API for their driver version 7.2.1 :

https://www.ibm.com/support/knowledgecenter/beta/SSULQD_7.2.1/com.ibm.nz.datacon.doc/r_datacon_jdbc_unsupported_methods.html