select statement output format in TSM6.3.2

unixandtsm

ADSM.ORG Member
Joined
Feb 9, 2011
Messages
307
Reaction score
0
Points
0
PREDATAR Control23

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
Code:
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
Code:
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!
 
PREDATAR Control23

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
 
PREDATAR Control23

thank you ChrisRees,

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