We have a JAVA application for which backend is UDB 7.2.
We are executing a batch of SQL statements using
'execute batch' command from Java application..
When the batch size = 74. It gives the error
'Invalid SQL statement'.
When I take the same set of 74 SQL statements and execute from command line as a script it runs fine, without any error.
What can be the problem? Is there any limitation on number of SQL statements for 'execute batch'?