SEC_SQL Variable with bind parameters error U02012033

Document ID : KB000087139
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
Error: U02012033 Query could not be executed:
'com.microsoft.sqlserver.jdbc.SQLServerException: Unable to identify the table
select oh_client, oh_name from oh where oh_client = ? for the metadata.

When defining a SQL Secure (SEC_SQL) variable using bind parameters, there is an issue in the concatenation of the SQL Statement lines.  There should be a space before the line containing the "FROM" keyword. 

This statement will work:
select oh_client,
oh_name
 from oh
where oh_client = ?

Without space before "from" it will produce an error:
select oh_client,
oh_name
from oh
where oh_client = ?
Cause:
Cause type:
Other
Root Cause: Bug with MSSQL JDBC driver, which deals with newline characters in the prepare statement method on the connection which is called when using bind parameters.
The JDBC driver can't handle a missing blank in front of the FROM keyword.
Resolution:
N/A

Fix Status: No Fix

Additional Information:
Workaround :
Add a space before the "from" keyword.