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.

TSM 6.1 SQL Behavior

Discussion in 'Scripting' started by chad_small, Nov 29, 2010.

  1. chad_small

    chad_small Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,207
    Likes Received:
    44
    Occupation:
    AIX/SAN/TSM
    Location:
    Gilbert, AZ
    With TSM 6.1 I currently am not getting scripts to return in column format, it keeps outputting in list format (one field per line). Do I missing something? I set sqldisplaymode wide. ???
     
  2.  
  3. nkovacs

    nkovacs New Member

    Joined:
    Oct 20, 2005
    Messages:
    57
    Likes Received:
    2
    You can force the output in list or table mode on the command line when you start dsmadmc using -displaymode=list or -displaymode=table. I believe the admin client switches from table to list mode by default once the column width reaches some threshold width. Some of the column widths changed from 5.5 to 6.1 which will cause some of the formatting to be different on SQL queries.

    Try starting your admin client like this:
    dsmadmc -tcps=xx.xx.xx.xx -tcpport=1500 -displaymode=table
     

Share This Page