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'))
Solved! Go to Solution.
This logic worked fine for me. here's my query:
From
_SYS_BIC.<table>
('PLACEHOLDER' = ('$$parYearFrom$$','2009'), 'PLACEHOLDER' = ('$$parYearTo$$','2018'))
Hi DawnR
It worked after changing the
SELECT _SYS_BIC.<Table>.*
to
SELECT *
and keeping the PLACEHOLDER code the same
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