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
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]( Is this the only way?
 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)]( 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