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.

Extracting Archive Information

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

  1. kevlee

    kevlee New Member

    Joined:
    Oct 28, 2010
    Messages:
    19
    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