Pass input parameters to HANA view connected through ODBC Connector

[akspande]

Hi All,

I have connected to a SAP HANA view through ODBC (using Input Data tool) and am trying to fetch data through an SQL statement.

I have mandatory input parameters in the view and need to pass values to it. 

Any idea on the SQL syntax?

I tried using PLACEHOLDER (below), like we do in SAP HANA but that isn't working.

SELECT _SYS_BIC.<Table>.*
FROM _SYS_BIC.<Table>('PLACEHOLDER' = ('$$IP_BD_CR_DT_TO$$', '20171001'), 'PLACEHOLDER' = ('$$IP_BD_CR_DT_FR$$', '20160701'))

[DawnR · Accepted solution]

This logic worked fine for me. here's my query:

From

_SYS_BIC.<table>

('PLACEHOLDER' = ('$$parYearFrom$$','2009'), 'PLACEHOLDER' = ('$$parYearTo$$','2018'))

[akspande]

Hi DawnR

It worked after changing the

SELECT _SYS_BIC.<Table>.*

to

SELECT *

and keeping the PLACEHOLDER code the same

[rmuvva]

Hi,

I am trying to same thing here to my HANA view but it saying

Error: Data Stream Out (5): Error SQLExecute: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search parameter error: [2018] A received argument has an invalid value;TABLE/VIEW parameter: ( 'I_DateFrom'='$$I_DateFrom$$, 1/1/2017') not supported.

Is this date format issue or anything related Paramenters.

Thanks,
R