1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

select statement output format in TSM6.3.2

Discussion in 'TSM Server' started by unixandtsm, Dec 13, 2012.

  1. unixandtsm

    unixandtsm New Member

    Joined:
    Feb 9, 2011
    Messages:
    307
    Likes Received:
    0
    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!
     
  2.  
  3. ChrisRees

    ChrisRees Senior Member

    Joined:
    Jul 24, 2008
    Messages:
    537
    Likes Received:
    13
    Occupation:
    Storage Management Person
    Location:
    Birmingham, UK
    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
     
  4. unixandtsm

    unixandtsm New Member

    Joined:
    Feb 9, 2011
    Messages:
    307
    Likes Received:
    0
    thank you ChrisRees,

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

    ChrisRees Senior Member

    Joined:
    Jul 24, 2008
    Messages:
    537
    Likes Received:
    13
    Occupation:
    Storage Management Person
    Location:
    Birmingham, UK

Share This Page