cancel
Showing results for 
Search instead for 
Did you mean: 

Export SQL Statement From SAP HANA SQL Console

ermeospina
Discoverer
0 Kudos
555

I Have a SQL statement that I execute in HANA Studio with "SQL Console" or with HDBSQL. I Need to save the result, i am trying that but I getting a syntax error.

venkateswaran_k
Active Contributor
0 Kudos

Dear Erwin,

You can export it by - click in the SQL Editor on your result set -> use EXPORT RESULT

However, what is the error message you get it?

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos

Please add the syntax error you are getting to the question to better understand your issue.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member644293
Active Participant
0 Kudos

Erwin,

Please right click on the result tab in the HANA studio and choose "Export Result"

with this you should be able to save the results.

Regards,

hans_segers
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Arunkumar,

When you choose "Export Result", the export contains the first 1000 records (by default).

Is there a way to export the complete result set of the query ?

I have a query that returns 80K records, the first 1000 are displayed.

I want to export the complete result set.

Many thanks

Hans