You can translate the question and the replies:

Denodo 7 VQL Shell save query to local file

Hi - I am running a VQL query via Denodo Admin Tool and wish to query a MySql view and save the result to disk programmatically. Here is the query: select * from my_base_view.my_campaign; INTO OUTFILE '/tmp/output.txt' When I run it I get error: Statement: INTO OUTFILE '/tmp/output.txt' Syntax error: Exception parsing query near 'INTO' Can you help with this? Theo
user
19-10-2020 11:26:43 -0400

2 Answers

After researching some more in the Denodo Q&A, I found this article which implies VQL Shell output export is not possible, but can be achived through Denodo’s Scheduler as seen [here](https://community.denodo.com/answers/question/details?questionId=9060g0000004FMiAAM&title=When+use+import.sh+to+run+vql%2C+where+is+the+vql+output+file%3F://) Is this the only way?
user
 Edited on: 20-10-2020 03:31:49 -0400
Hi, Yes, you can use the Denodo Scheduler to export the result of a query execution/ job. You can refer to the [Postprocessing Section (Exporters)](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/postprocessing_section_exporters#postprocessing-section-exporters) section of the Scheduler Administration Guide for more information. Hope this helps!
Denodo Team
21-10-2020 08:47:28 -0400
You must sign in to add an answer. If you do not have an account, you can register here