former_member185332
Explorer
Member since ‎02-12-2014

User Statistics

  • 44 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

is_valid_date and raise an exception

08-16-2016
SAP DS version 4.2 SP 6I have a datetime field with the following codeifthenelse(is_valid_datetime(Q_SELECT.TIJDSTIP, 'YYYY-MM-DD HH24:MI:SS')=1, to_date(Q_SELECT.TIJDSTIP,'YYYY-MM-DD HH24:MI:SS'), raise_exception ('for the given inputfile an value n...

How to call a (catalog) stored procedure directly in a xsodata file with in/output parameters

04-23-2015
I am new to XS but i managed to enable a table through xsodata:service namespace "sap.hana.democontent.epm" {    "AA465342"."TMP_HENK" as "TMP_HENK";    }  But now i am looking for code that can call a stored procedure that has 2 input- and 3 output ...

missing functions in expressions

02-27-2015
Although not available in the function list, the function LOWER does work in a expression of a HANA view:Now i am wondering whether there are more functions, not mentioned that will work. Is there a complete list of functions that work in a HANA view...

how to pass a sequence name to a stored procedure?

12-10-2014
I've created a stored procedure where we want to determine the currval of a sequence. The sequence name self is not known in front, so it has to be passed to the procedure. This, off course, can be done by a IN parameter. But how can i use it within ...

SPS09 and smart data integration and smart data quality: a question

11-12-2014
In the link What's new in SPS09 i read the following:"Moreover, smart data integration and smart data quality in SAP HANA SPS09 enables the provisioning filtering, transformation, cleansing and enrichment of data from multiple sources into SAP HANA e...
View more