AnsweredAssumed Answered

JDBC Generic SQL Operator max rows

Question asked by tony.harrison on Aug 17, 2012
Latest reply on Sep 18, 2013 by yann_huang
Is it possible to increase the maximum number of rows returned by the Generic SQL Operator in PA 3.1?

Maximum rows to retrieve
Specifies the maximum number of rows to retrieve. If blank, the default value is 10 rows. The Generic SQL Operator retrieves a maximum of 512 rows. Additional rows will be truncated.

We wouldn't normally hit this limit but we are implementing an overnight process to handle a large number of records.