Top "Hana-sql-script" questions

The language for stored procedures and functions used in SAP HANA

HANA - Passing string variable into WHERE IN() clause in SQL script

Lets suppose I have some SQL script in a scripted calculation view that takes a single value input parameter and …

hana sql-scripts hana-sql-script
How to convert an invalid number column to a number on HANA?

I have a table with a string column. I convert this column to a number using the function TO_INTEGER(). …

sql sap hana hana-sql-script
Temporary tables in hana

it it possible to write script in hana that crate temporary table that is based on existing table (with no …

database hana hana-sql-script
how to assign a variable in procedure in SAP HANA

here i tried to give discount based on quantity ordered by using procedure. but i dont know how assign a …

sql stored-procedures hana hana-sql-script
SAP HANA : How to insert the result of stored procedure into local temporary table

I am trying to store the result of my read/write stored procedure in local temporary table. After creating the …

stored-procedures temp-tables hana-sql-script
How to get date and time separately in to two columns from a HANA unix timestamp field?

The unix timestamp value is coming to HANA via data services from MySQL DB. I can however find the date …

hana hana-sql-script
Add days to date in SAP HANA stored procedure

I need to add days to date in HANA stored procedure, but I am getting error message ERROR WHILE parsing …

stored-procedures sap hana hana-sql-script
Convert T-SQL Declare statement to SAP HANA

I cannot seem to get the query with declare statement working in SAP HANA. Below I've put the original working …

converter hana hana-sql-script