Export data into server with header information in SAP HANA

[Former Member]

How to export data into csv or txt using SQL statement in SAP HANA with the header information (column names) ? i am searching for the result from quiet long time but couldnt find any solutions ?

[Former Member]

Hi Roberto,

Purpose - we have developed few reports using views and SAP tables and showcasing these reports using UI5, so i want to download these report data from backend (SAP HANA studio - Export functionality in hdbprocedure). Basically this download option is for the end user, so searcing for options to enable this functionality.Thanks.

[roberto_vacca2]

Hi.

You can't use SQL. If you really want it you can choose between HDBSQL or a program client to execute query.

There's no SQL export functionality. You can use SAVE function from HANA Studio. You can put a flag when exporting CSV (Generate table header)

What's your purpose?

Hope to help

Bye