Ability to create user defined functions on row level

Follow

3

Don Seur

• February 13, 2019 14:38

Can it be made possible to create defined functions in DV?

The user defined function must be used on a row level, i.e. in a sql statement.

With these functions the acceptance of DV by our endusers can be increased.

Especially the date / time functions are different from what they are familiar with in their end-user tools.

For example, we could create an add_months function that uses the TimeStampAdd function.

So

select add_months (date_field, -1) from tab;

instead of
selecting TimeStampAdd (SQL_TSI_MONTH, -1, date_field) from tab

Now, we have to rewrite existing applications whenever we want to connect them on DV.
With these functions we can simplify that transformation.

• Comment actions Permalink

  Official comment

  

  Salvatore Raunich

  • February 13, 2019 19:58

  Hi Don,

  thanks for posting your request to our online community.

  Having the possibility to easily create user-defined functions that can be also mapped to existing DV functions would indeed improve the usability. One thing to consider is also how these functions can be pushed down to the underlying data sources, if supported. 

  We added your request to the wishlist and we will consider it in our Roadmap, but at the moment I cannot give you an exact estimation when this feature will be implemented.

  I will follow up here as soon as I have more info.

  Best

  Salvatore

Please sign in to leave a comment.