Skip to Content
0

Use of custom HANA database functions within BODS to generate hash keys (md5)

May 11, 2017 at 12:51 PM

244

avatar image
Former Member

Hello all,

I imported a HANA database function to a datastore. So far so good.

When I try to use this function within a BODS script I get an error message from the database, that the function doesn't exist. As you can see in the trace below, BODS tries to execute the function with a call command in the database.

As far as I know it's not possible to call a function that way. I'm using HANA 1.0 and BODS 4.2 with SP6. The import and use of stored procedures works fine.

Why do I want to use stored functions instead of stored procedures? I want to create md5 hash keys of business keys in the mapping of a query transform directly, hoping that BODS would do a full push down to the database.

Has anybody a solution for this function call issue or a better idea to create md5 based hash keys?

Thanks a lot,

Markus

image001.png (51.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers