Incorrect results from Select process with Netezza

Problem or error: When Netezza is the user database and in-database optimization is not enabled in Campaign, the Select process sometimes returns incorrect results.

Solution: Configure the Netezza ODBC driver to have a prefetch count value that is a multiple of the value of the BulkReaderBlockSize property (in versions of Campaign that use the dbconfig.lis file, the name is bulkreader_blocksize). For example, if the value of the BulkReaderBlockSize property is 2500, the prefetch count can be 25000.