Skip to Content
0

Export data into server with header information in SAP HANA

May 04, 2017 at 12:23 PM

205

avatar image
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 ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Roberto Vacca May 04, 2017 at 01:34 PM
0

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


Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 05, 2017 at 06:48 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded