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
rosenbn AT pjm DOT com



Neil Rosenberg
610-666-8936
rosenbn AT pjm DOT com