copying the results to the file

[chavalis]

Hi
How to copy the results of query to a file?
For example

Say there is a query like this
select * from city;
The results of this query are to be seen in the file.

Regards

[John]

There are many ways you can do that, depending on what format you want. The simplest is to use tsql, and redirect the output:

tsql "select * from city;" > filename

There are a number of formats that tsql can produce.

You could also create a vortex script to format the
results any way you want, and either redirect the output, or use <WRITE> in Vortex.