Re: Question about using global characters in a select statement

[Andy Raibeck]

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: [EMAIL PROTECTED] (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 <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
07/24/2002 05:47
Please respond to "ADSM: Dist Stor Manager"


        To:     [EMAIL PROTECTED]
        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
[EMAIL PROTECTED]



Neil Rosenberg
610-666-8936
[EMAIL PROTECTED]