After making changes to an existing query, this error is produced when it is run:
ERROR - SQL STATEMENT GREATER THAN 65530 BYTES SQL STATEMENT EXCEEDS 65530 CHARACTER(S)
How do we resolve this error?
There is a limit to the size of a single query to be processed within CA Datacom, and this limit of 65530 cannot be changed without some major architectural changes to the base CA Datacom/DB product.
However, we have a few suggestions that might help you to make your query fit this limit:
As always, please contact CA Technologies support for CA Datacom if you have further questions.
Was this information helpful?