What is your $selsort ??? are you sure it is one of the variables you are
selecting ?
Wait, aren't you missing a quote somewhere ???

Dwight





                      Bill Fitzgerald
                      <wfitzger AT MHC DOT NET        To:       ADSM-L AT 
VM.MARIST DOT EDU
                      >                        cc:
                      Sent by: "ADSM:          Subject:  Query to TSM from Perl
                      Dist Stor
                      Manager"
                      <[email protected]
                      .EDU>


                      04/28/2003 10:42
                      AM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






I am trying to write a script that executes dsmadmc and runs a query.

The trouble is that where clause  and the order clause keeps failing.

@volumes=`dsmadmc -id=xxxxxxxx -pass=xxxxxxxx select
volume_name,stgpool_name,devclass_name,est_capacity,pct_utilized,status,
from volumes where stgpool_name = '$selpool' order by $selsort'

Can anyone help me with this?

If you can help please respond to my email address and not the list serv.

William Fitzgerald
Software Programmer
Munson Medical Center
wfitzger AT mhc DOT net