Try using:

   ... where node_name like 'AD1%'

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Neil Rosenberg <rosenbn AT PJM DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
07/24/2002 05:47
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        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
rosenbn AT pjm DOT com



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