Skip to main content

Error appears when running certain 'CASE' statements using SAP HANA connector

Rich Talbot
  • Created
Date Posted:
Product: TIBCO Spotfire®

Problem:

Error appears when running certain 'CASE' statements using SAP HANA connector


Solution:

When running a query containing a 'CASE' statement using the SAP HANA connector, the error "The query is not supported in the external data source." appears.

Below are 2 examples of external errors that can appear:
1.  

ERROR [42000] [SAP AG][LIBODBCHDB DLL][HDBODBC]
Syntax error or access violation;257 sql syntax error:
incorrect syntax near "-":line x col y

2. 
ERROR [42000] [SAP AG][LIBODBCHDB DLL][HDBODBC] 
Syntax error or access violation;257 sql syntax error:
incorrect syntax near "IN": line x col y

  This is a known issue in 10.3.

The errors appear when using CASE statements with relation expressions (for example A=B) together with 'WHEN' or 'THEN', or using CASE statements with 3 or more conditions (for example A=B or B=C or C=D).

This is fixed in 10.3.3 HF-014. Keywords: SAP HANA, CASE, The query is not supported in the external data source, ERROR [42000]

Comments

0 comments

Article is closed for comments.