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:ads...@vm.marist.edu] On Behalf Of Remco Post Sent: Sunday, November 08, 2009 10:49 AM To: ADSM-L@VM.MARIST.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.
