Skip to Content

How to export data result from a query to .dat or .txt on Hana?

Hello everyone,

I need easily export a query result to a .dat or .txt file, from HANA database; when using SQL, I use bcp utility to generate those files. Does HANA provide some utility in order to export data?

I have tried to do this task programatically, but it's extremly slow where there are thousands of records

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 14, 2017 at 04:46 AM

    Right Click left cell on query result and choose Export Result... and then save as .TXT

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 20, 2017 at 04:06 PM

    Hi,

    Dump records to a temporary table then export the table using the "EXPORT" command. Fastest way to export.

    Regards,

    Kapil

    Add comment
    10|10000 characters needed characters exceeded