Is there a way to change how my output is formatted when I run an sql query. Right now if i execute the command:
select volume_name,stgpool_name,status from volumes where volume_name='
X00172L4'
The results is formatted like:
VOLUME_NAME: X00172L4
STGPOOL_NAME: TAPE_STGPOOL_L4
STATUS: FULL
I want to get the result is a table format similar to ms sql.
volume_name STGPOOL_Name STATUS
X00172L4 TAPE_STGPOOL_L4 FULL
I am just running the queries from the administrative command line.
Thanks for the help.
select volume_name,stgpool_name,status from volumes where volume_name='
X00172L4'
The results is formatted like:
VOLUME_NAME: X00172L4
STGPOOL_NAME: TAPE_STGPOOL_L4
STATUS: FULL
I want to get the result is a table format similar to ms sql.
volume_name STGPOOL_Name STATUS
X00172L4 TAPE_STGPOOL_L4 FULL
I am just running the queries from the administrative command line.
Thanks for the help.