Re: Question about using global characters in a select statement

2002-07-26 Thread Andy Raibeck
quot; 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_n

Re: Question about using global characters in a select statement

2002-07-26 Thread Thomas Denier
> 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. The correct form for the where cl

Re: Question about using global characters in a select statement

2002-07-26 Thread PINNI, BALANAND (SBCSI)
mail pager -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 i

Re: Question about using global characters in a select statement

2002-07-24 Thread Bratlie, Allen
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 w

Re: Question about using global characters in a select statement

2002-07-24 Thread Ford, Phillip
iginal 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 gro

Question about using global characters in a select statement

2002-07-24 Thread Neil Rosenberg
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'