cancel
Showing results for 
Search instead for 
Did you mean: 

Calculation view result into text file

former_member784780
Discoverer
0 Kudos

Good Day Experts,

I'm running HANA Query on Calculation View in HANA Studio, It's a detail report getting output almost 1.5 million records. Please assist me is there any way i can directly save the output into a text file on desktop?


Your quick response is highly appreciated.

Thanks & Regards,

Raj

Accepted Solutions (0)

Answers (3)

Answers (3)

eason_chen
Employee
Employee

Hi,

You could use hdbsql to run your query and get out put to a file in a server with HANA client installed.
Firstly, create a file which contains your query e.g. query.sql
Then run hdbsql command to generate out put into out.txt

hdbsql -n <hostname>:<sqlport> -u <dbuser> -p <password> -I query.sql -o out.txt

You could run hdbsql -h to show help of this command.

Best Regards,
Eason Chen

former_member784780
Discoverer
0 Kudos

Thanks for the response.

Is there any other way? Directly coping the SQL Query output into the text file.

Regards,

Raj

akshinde
Participant
0 Kudos

One option is , You can use export SQL, and use that in hdbsql if this data extraction is on- going,

Other option is ,you can insert the output into temporary physical table and export that from Hana studio, of course when it is not on-going.