Skip to Content
0

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

Jul 04, 2017 at 12:10 AM

168

avatar image

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

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

2 Answers

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

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member
Sep 20, 2017 at 04:06 PM
0

Hi,

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

Regards,

Kapil

Share
10 |10000 characters needed characters left characters exceeded