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.
select add_months (date_field, -1) from tab;
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.
Please sign in to leave a comment.