Skip to main content
V
vivekr0006
July 5, 2024
Question

Passing Parameters to a Connected System (HANA DB)

  • July 5, 2024
  • 2 replies
  • 0 views

Hi experts,

We have been able to establish connectivity to a HANA database successfully.

The HANA stored procedure is expecting the values to be passed, enclosed in single quotes - 'Value1, Value2'.

A query like below works perfectly fine.

SELECT * from DB_SCHEMA.VIEW_NAME('placeholder' = ('$$list_name$$','Value1,Value2'))

However when I try to pass this list as a parameter, I am getting an error.

SELECT * from DB_SCHEMA.VIEW_NAME('placeholder' = ('$$list_name$$',{parameter}))

Has anybody integrated with HANA DB before and has a reference to how we can achieve this by passing dynamic values via parameter with the main criteria being include parameter values in single quotes?

2 replies

shubhama926776
shubhama926776
July 5, 2024

Concatenate parameter with single quotes

SELECT * from DB_SCHEMA.VIEW_NAME('placeholder' = ('$$list_name$$', ' ' parameter ' '))


V
vivekr0006Author
July 5, 2024

Thanks for your response. Shubham.

Unfortunately, it doesn't work. For Appian to detect something as a parameterName it is necessary to enclose it in curly braces without anything before or after. We can only play with what values go into the parameter and not the syntax you have suggested above. 

Terms & ConditionsAccessibility statement