Storage Management Server for AIX - Version 6, Release 2, Level 0.0 (AIX v5.3)
tsm: TSMTEST1>select stgpool_name from stgpools where stgpool_name like '%\_%' escape '\' STGPOOL_NAME -------------------------------- TEST_POOL tsm: TSMTEST1>select stgpool_name from stgpools where stgpool_name like '%\_%' ANR2034E SELECT: No match found using this criteria. ANS8001I Return code 11. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Richard Sims Sent: Friday, June 04, 2010 11:02 AM To: [email protected] Subject: Re: [ADSM-L] SQL statement On Jun 4, 2010, at 10:41 AM, Prather, Wanda wrote: > Ow. > Richard, do you know if it works this way still in V6? Hi, Wanda - We remain a v5 shop, pending a lot of infrastructure decisions to be made by a new VP, so I haven't that experience. I would expect DB2 to be much more conformant to SQL standards than the Select accommodations in "TSM Classic". Perhaps a customer with v6 can lend to this. Richard The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. To reply to our email administrator directly, please send an email to [email protected].
