I ran into this same problem a while back. If you are using the command with a script, you need to use '%%string%%'. If you type them into the admin interface you should be able to use '%string%'.
I run several scripts from a W2K batch file similar to this: DSMADMC.exe -tcpserveraddress=tsmserver -tcpport=1500 -id=user -password=password -COMMAdelimited -outfile=testdata.csv select node_name, domain_name from nodes where node_name like '%%DB%%' -----Original Message----- From: Neil Rosenberg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 7:47 AM To: [EMAIL PROTECTED] Subject: Question about using global characters in a select statement I would like to use a global character in select statements on tsm servers to get information about groups of nodes For example if I use something like: select node_name, filespace_name from filespaces where node_name='AD1%' to get information about all nodes whose node_names begin with 'AD1' I get the following error: ANR2002E Missing closing quote character. I have tried "Double quotes" and used * instead of % - none of these work Any Suggestions? Thanks Neil Rosenberg [EMAIL PROTECTED] Neil Rosenberg 610-666-8936 [EMAIL PROTECTED]
