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???