Try place the backslash in front of the quote

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


Ray Baughman
TSM/Engineering Systems Administrator
National Machinery LLC

> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Bill Fitzgerald
> Sent: Wednesday, April 23, 2003 1: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,s
> tatus, 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
>