I'm not sure there is a problem with how the redirected output shows up in the file. The output as shown in your message is probably due to implicit line wrapping in your console or editor (for example, vi could be wrapping the output).
Also, take a look at Chapter 3 in the Administrator's Reference, "Using the Command Line Interface" for further information on using the Admin command line interface. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" <[email protected]> wrote on 2005-07-19 09:00:23: > 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
