Re: formatted output
2005-07-19 12:14:08
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/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com
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" <ADSM-L AT VM.MARIST DOT EDU> 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
|
|
|