Skip to Content

How to export data result from query to .dat file on HANA database?

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've tried programmatically to do this task, but it's extremely slow when the result includes thousands of records

Thanks for your help

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 05, 2017 at 10:44 AM

    1 - Instead of a query, use one or many Graphical HANA Calculation view to retrieve the records

    2 - Query the Calculation View with an XSJS

    3 - Return the XSJS content as a txt (or do the formatting you want)

    Never query the tables directly, always use the views (Graphical is the best)

    Add comment
    10|10000 characters needed characters exceeded