SAS VA: Could not execute the JDBC batch update

[Carrot17]

Hi Experts,

Anyone here knows the "server error: could not execute JDBC batch update"? For additional information, we encountered this error when saving case statement with more than 5 statements comparison and the query validation is valid. Please find attached error and case statement.

Best Regards,

Carrot17

[EWS · Accepted solution]

Hi Carrot17,

When your statement contains more then 1024 characters system will fail to execute the expression. Validation works fine but you vannot run the query.

http://support.sas.com/kb/51/510.html