Skip to Content
avatar image
Former Member

SQL query with dynamic placeholder

I have a hana view with a year placeholder and i would like pass the placeholder in query, for example i can use this sintax?

declare v_year as int;
set v_year = YEAR(CURRENT_DATE);

SELECT * FROM “_SYS_BIC”.”my_view/MY_VIEW”

(‘PLACEHOLDER’ = (‘$$YEAR$$’,”v_year”’))

I wouldn't like create a proc to do a semple select

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers