Or, how about

dsmadmc -id=$user -password=$pw "select domain_name,set_name,class_name from
BU_COPYGROUPS where class_name='$newmc'"

Double quotes outside.

Million ways to skin a cat, #42.


-----Original Message-----
From: Ford, Phillip [mailto:phillip.ford AT SPCORP DOT COM]
Sent: Wednesday, April 23, 2003 12:30 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Query to TSM from AIX


Here are two that I have found quickly

dsmadmc -id=$user -password=$pw select domain_name,set_name,class_name from
BU_COPYGROUPS where class_name="'$newmc'"

Here is another

dsmadmc -id=$user -password=$pw select node_name,filespace_name,... from
backups where node_name = \'$1\' and filespace_name like \'\%oracatalog\%\'


Hope that helps


--
Phillip Ford
Senior Software Specialist
Corporate Computer Center
Schering-Plough Corp.
(901) 320-4462
(901) 320-4856 FAX
phillip.ford AT spcorp DOT com





-----Original Message-----
From: Bill Fitzgerald [mailto:wfitzger AT MHC DOT NET]
Sent: Wednesday, April 23, 2003 12:19 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Query to TSM from AIX


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

The trouble is that where clause keeps failing.

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

I have tried single quote, double quote, and the tic mark and in all three
cases it fails
I have tried using a AIX variable and it still does not work.

Can anyone help me with this?

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


*********************************************************************
This message and any attachments are solely for the intended recipient. If
you are not the intended recipient, disclosure, copying, use or distribution
of the information included in this message is prohibited -- Please
immediately and permanently delete.