Pass input parameters to HANA view connected through ODBC Connector

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'))

Input

Connectors

Database Connection

Accepted answers

DawnR

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

From

_SYS_BIC.<table>

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

All comments

DawnR

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>.*

SELECT *

and keeping the PLACEHOLDER code the same

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703