select statement output format in TSM6.3.2

[unixandtsm]

Hi all,

Recently migrated to TSM 6.3.2 and i find it little different when it comes to output format of select statements from TSM 5.5
Below is the output format of a select statement in V6.3.2

select volume_name, stgpool_name from volumes where DEVCLASS_NAME='TEST'

 VOLUME_NAME: T05126
STGPOOL_NAME: ORACLE

but i want those two seleted columns side by side as below but not one after the other

VOLUME_NAME   STGPOOL_NAME
T05126             ORACLE

This is how it used to be in TSM5.5, i know things have changed with v6 but wondeing if i can customize the select statments ?

Thanks in advance!

[ChrisRees]

Hi

Try this

select rpad(volume_name,9) as volume, rpad(stgpool_name,13) as stgpool from volumes where DEVCLASS_NAME='TEST' order by stgpool

Hope that helps

[unixandtsm]

thank you ChrisRees,

Can you please expalin what are rpad and numbers like 9 and 13 etc in the query ?

[ChrisRees]

Hi

I came across rpad in this thread

http://adsm.org/forum/showthread.php...highlight=rpad

Cheers