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.

Extracting Archive Information

Discussion in 'Scripting' started by kevlee, Nov 7, 2012.

  1. kevlee

    kevlee ADSM.ORG Member

    Joined:
    Oct 28, 2010
    Messages:
    25
    Likes Received:
    0
    Hi, inexperienced at scripting.

    Need to extract archive information from database (TSm v5.5.3).

    Would like to produce an output list showing distinct description, class_name, archive date which outputs only one line per archive description. Any ideas???

    Have tried using select description, class_name, archive_date but it gives me a line for each archived file, I really want to add the class_name and archive date to the distinct look up.

    Also, can't seem to get sqldisplaywide to work, run dsmadmc -id -password set sqldisplaymode wide then run dsmadmc select but it still gives narrow output???
     
  2.  

Share This Page