Archives of the TeradataForum
Message Posted: Fri, 19 Apr 2002 @ 08:34:40 GMT
<-- Anonymously Posted: Thursday, April 18, 2002 23:10 -->
The update is not occurring because your WHERE clause is returning a false.
The result, step by step:
Step 1 WHERE X = :IN_x <--- TRUE > AND (Y <> :IN_y OR <---- FALSE > Z <> :IN_Z) <--- Unknown Step 2 WHERE TRUE AND Unknown <--- FALSE
with an AND condition, both sides of the AND must be TRUE and here, they are not. So, the update does not take place.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|