1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above 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 notice will disappear after you have made at least 3 posts.

TSM 6.1 SQL Behavior

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

  1. chad_small

    chad_small ADSM.ORG Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,210
    Likes Received:
    46
    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 ADSM.ORG 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