Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > OUTPUT >

Sending Query Results to a File

To send the results of a query to an operating-system file, specify the full pathname for the file. If the file already exists, the output overwrites the current contents.

The following examples show how to send the result of a query to an operating-system file. The example uses UNIX filenaming conventions.

OUTPUT TO /usr/april/query1
   SELECT * FROM cust_calls WHERE call_code = 'L'
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]