cancel
Showing results for 
Search instead for 
Did you mean: 

Creating Stored Procedures and User defined Functions via DI API

dkinyua11
Explorer
0 Kudos

Dear All,

I woould like to create stored procedures and user defined functions to be used by an addon automatically either through DI API or any other way. NB it is in SBO HANA.

Is there a way to do this ?

Thank you.

Accepted Solutions (0)

Answers (2)

Answers (2)

dkinyua11
Explorer
0 Kudos

Thank you Balakumar

Okay, I use that the problem is that in SBO HANA I have user functions with SELECT INTO clause, when I create this functions in HANA studio I get a warning message and the function is successfully created.

The problem is that when I use the DI due to that warning SBO Recordset object crashes.

Thank you.

kvbalakumar
Active Contributor
0 Kudos

I hope sharing the error message would help to understand the issue.

dkinyua11
Explorer
0 Kudos

This is the warning message from HANA Studio:

java.sql.SQLWarning: Not recommended feature: Using SELECT INTO in Scalar UDF

Recordset object crashes with same error message.

Thank you.

kvbalakumar
Active Contributor
0 Kudos

Hi,

You can execute the related T-SQL using Do.Query method at DI.

Regards,

Bala