Re: [ADSM-L] Changed SQL behavior under server 188.8.131.52
Hi, Margaret. What error are you getting?
Taking a stab in the dark, explicitly using NODES and FILESPACES in your
predicate can cause unexpected results
(http://www-01.ibm.com/support/docview.wss?uid=swg21380830). I would
guess failing with the addition of the word "NOT" could be construed as
an unexpected result. You might retry using the "AS" keyword. This
particular problem is listed as fixed in 184.108.40.206.
On 6/21/2012 9:55 AM, Clark, Margaret wrote:
Using TSM server 220.127.116.11, the following SQL command no longer works:
select node_name from nodes where node_name not in (select node_name from
It still works correctly if you take out the "not".