Tag: hana

SQL: SAP Hana if parameter is null, ignore where

hana hana-sql-script sql sql-server stored-procedures

I’m passing 3 parameters into my Hana Stored Procedure to use as WHERE clauses, and if the parameter is null, I want the procedure to behave as though that condition doesn’t exist. example: if one of the input parameters is deviceType. if deviceType is null, query should simply be I know I can achieve this with if statements, but is

SQL “IS NOT NULL” compensation for SAP HANA SQLScript

hana isnull sap sql

Actually I tried to run a is null SQL Statement on a SAP HANA Database using the SAP HANA Studio. This does not work because SQLScript has no is not null or is null function. My statement looks like: Unfortunately it does not work. Does anybody know an alternative approach which is practicable using SAP HANA SQLScript? On the internet

HANA: Split string?

hana sql

Is there a way to split a string in HANA? Something similar to the equivalent in SQL Server: SELECT * FROM dbo.fnSplitString(‘valueA,valueB’, ‘,’)