<docbook><section><title>VirtTipsAndTricksGuideISQLQueryResultOutput</title><title>How to output from isql the result of a sql select query to a file in Virtuoso?</title>How to output from isql the result of a sql select query to a file in Virtuoso?
<para> </para>
<bridgehead class="http://www.w3.org/1999/xhtml:h2">What?</bridgehead>
 Output iSQL result of a SQL SELECT Query.<bridgehead class="http://www.w3.org/1999/xhtml:h2">Why?</bridgehead>
 Manage the results of a SQL SELECT Query by using by saving into a file for convenience.<bridgehead class="http://www.w3.org/1999/xhtml:h2">How?</bridgehead>
<para>In order to save the output in a file from a SQL SELECT query executed from Virtuoso iSQL, one should use the following syntax:</para>
<programlisting>isql &lt;port&gt; user pass exec=&quot;SELECT ...&quot; &gt; {file-name.{ext}}
</programlisting><para> </para>
<bridgehead class="http://www.w3.org/1999/xhtml:h3">Related</bridgehead>
<para> </para>
<itemizedlist mark="bullet" spacing="compact"><listitem><ulink url="VirtTipsAndTricksGuideSPARQLEndpointQueryResultOutput">How to output the results of a SPARQL query run against the /sparql endpoint to a file in Virtuoso?</ulink> </listitem>
<listitem><ulink url="VirtTipsAndTricksGuide">Virtuoso Tips and Tricks Collection</ulink> </listitem>
</itemizedlist></section></docbook>