Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Feb 2011
    Posts
    306
    Thanks
    14
    Thanked 0 Times in 0 Posts

    Default select statement output format in TSM6.3.2

    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. #2
    Senior Member
    Join Date
    Jul 2008
    Location
    Birmingham, UK
    Posts
    537
    Thanks
    0
    Thanked 5 Times in 4 Posts

    Default

    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

  3. #3
    Member
    Join Date
    Feb 2011
    Posts
    306
    Thanks
    14
    Thanked 0 Times in 0 Posts

    Default

    thank you ChrisRees,

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

  4. #4
    Senior Member
    Join Date
    Jul 2008
    Location
    Birmingham, UK
    Posts
    537
    Thanks
    0
    Thanked 5 Times in 4 Posts

    Default

    Hi

    I came across rpad in this thread

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

    Cheers

Similar Threads

  1. Replies: 4
    Last Post: 08-16-2012, 04:44 PM
  2. use output of select statement in a script
    By mirreke in forum Scripting
    Replies: 2
    Last Post: 04-18-2011, 03:30 PM
  3. Need output of select statement in unicode format
    By raydifede in forum Scripting
    Replies: 1
    Last Post: 04-24-2008, 04:06 AM
  4. text format - select statement output
    By friesguy in forum Scripting
    Replies: 5
    Last Post: 10-15-2006, 11:09 PM
  5. Replies: 3
    Last Post: 10-08-2006, 06:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •