Skip to Content
avatar image
Former Member

Export data into server with header information in SAP HANA

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 04, 2017 at 01:34 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 05, 2017 at 06:48 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded