How to execute a SQL statement from a Table in SAP HANA.

[former_member184871]

Hello Community,

Refer to screen-shot for table structure.

I have to create a stored procedure with an input parameter as USER_INPUT which will be checked with "TEXT" - when User Input matches the data stored in the TEXT then the corresponding query should get executed.

Please guide me how to achieve the same.

Regards

Kumar

[former_member182302 · Accepted solution]

You got to use EXEC or EXECUTE IMMEDIATE to achieve it.

When the user input matches, the corresponding query should be taken into a String variable.

Example:

SQL_STRING := 'Select Count(*) from TABLE'

EXECUTE IMMEDIATE (:SQL_STRING)

Have a look on the sample proc created using EXECUTE IMMEDIATE below.

Regards,

Krishna Tangudu

[former_member184871 · Accepted solution]

Hi Krishna

Thanks for the reply. when I am executing the procedure, I am getting the output as :

But the expected output is the total no of records present in the table !!

Following is the code I used :

I think I am missing something !!

Please guide.

Regards

Kumar

[sergey_sheremet · Accepted solution]

Hi Kumar,

Try the following statement

select "QUERY" into SQL_STR from "TA"."QUERYTABLE";

instead of SQL_STR := '...

Good luck!

WBR,

Sergey.

[former_member182302 · Accepted solution]

Hi Kumar,

You are executing the below query:

SELECT "QUERY" from "TA"."QUERYTABLE" and hence you are getting the corresponding output.

Change the code as mentioned below:

SELECT "QUERY" INTO SQL_STR FROM "TA"."QUERYTABLE" ;

EXECUTE IMMEDIATE (:SQL_STR);

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

This message was moderated.

[former_member184871]

Thanks Krishna and Sergey