I wondered about that too, I use literal strings in selects like the
following partial command, but there are single quotes around them:
SELECT 'Move Data'|| ' ' ||volume_name|| ' ' ||'reconstruct=yes'|| ' '
||' wait=y'
Interesting...
tsm: AIXPROD65>select member_name, server from group_member
MEMBER_NAME Unnamed[2]
------------------ ------------------
AIXPROD123 SERVER
AIXPROD456 SERVER
AIXPROD789 SERVER
I wonder if there is something underlying the "sql" tables that the
query can see but is not completely translated from the b tree db and
not show as a valid column.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Remco Post
Sent: Sunday, November 08, 2009 10:49 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] huuh?
On 8 nov 2009, at 16:46, Huebschman, George J. wrote:
> "Server" is not a column name, use "group_name" :
>
I know that server is not the name of any column in the group_member
table. What I'm surprised about is that TSM parses this as a literal
string rather than as a column name in my select.
> George Huebschman
>
> -----Original Message-----
>
> AIX 5.3 TSM 5.5.2.0:
>
> tsm: TSMSERVER2.DEMO>select server from group_member
>
> Unnamed[1]
> ------------------
> SERVER
>
>
> huuh? :)
>
> definitely not what I expected....
--
Met vriendelijke groeten/Kind regards,
Remco Post
IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason
therefore recommends that you do not send any confidential or sensitive
information to us via electronic mail, including social security numbers,
account numbers, or personal identification numbers. Delivery, and or timely
delivery of Internet mail is not guaranteed. Legg Mason therefore recommends
that you do not send time sensitive
or action-oriented messages to us via electronic mail.
This message is intended for the addressee only and may contain privileged or
confidential information. Unless you are the intended recipient, you may not
use, copy or disclose to anyone any information contained in this message. If
you have received this message in error, please notify the author by replying
to this message and then kindly delete the message. Thank you.
|
