Folks,

Probably a FAQ but......

How would I execute a "select" statement to send data to an external
file and make it readable?

Here is an example:

select * from volumes where access='UNAVAILABLE' and location is null >
/tmp/outfile

the outfile looks like this:

VOLUME_NAME            STGPOOL_NAME           DEVCLASS_NAME
EST_CA
PACITY_MB     PCT_UTILIZED     STATUS                 ACCESS
PCT
_RECLAIM     SCRATCH                ERROR_STATE            NUM_SIDES
TIMES_M
OUNTED      WRITE_PASS        LAST_WRITE_DATE         LAST_READ_DATE
P
ENDING_DATE     WRITE_ERRORS     READ_ERRORS     LOCATION
  CHG_TIME     CHG_ADMIN
------------------     ------------------     ------------------
-----------
---------     ------------     ------------------     ------------------
---
--------     ------------------     ------------------     ---------
-------
------     -----------     ------------------     ------------------
-------
-----------     ------------     -----------     ------------------
--------
----------     ------------------
303028                 EAGLETAPE              EGL9840
  20959.7              6.2     FULL                   UNAVAILABLE
    93.7     Yes                    No                             1
    27               1             2005-06-16             2005-07-07
                           0               0
2005-07-07     ADMIN

etc.....

Thanks!

DaveZ