Top "Hana" questions

Conditional statements using HANA SQL Script

I have a table in HANA studio, which consists of 5 columns: item value cost Margin ABC_cat How can I …

sql hana

How to convert BLOB to varchar with SAP HANA database using SQL

how do I cast a blob to varchar with SAP HANA database using SQL. (we need the column to be …

sql blob sap varchar hana

not able to call procedure within procedure in HANA Studio

I am trying to call a procedure I made earlier in new procedure. I am getting error in same line …

sql stored-procedures hana hana-studio

HANA: Split string?

Is there a way to split a string in HANA? Something similar to the equivalent in SQL Server: SELECT * FROM …

sql 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 return the number of affected rows in a HANA stored procedure?

How does one return the number of rows affected from an insert or update statement while inside a SAP HANA …

sql hana

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

Efficient database access to various DBMS from Delphi XE2

My needs I work with Delphi/C++Builder XE2. I need to access at least these DBMSs: Firebird DB2/400 SQL …

database performance delphi c++builder hana

How to do an IF EXISTS in hana SQL query

I have this query code: IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BAL_WMS_…

sql hana

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