Archives of the TeradataForum

Message Posted: Wed, 18 Jun 2008 @ 17:57:48 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

          > Query B inserts all the rows of the source into the target. (partition
          > specific logic is ignored. The explain reflects this.)
          >
          > /*** Query B ***/
          >
          > database wlg35507_temp ;
          >
          > MERGE INTO wlg35507_temp.table_mvc_idx  bb
          > USING wlg35507_temp.table_tst   aa
          > ON aa.PI_attr = bb.PI_attr
          > and aa.partitioning_attr = bb.partitioning_attr
          > and (aa.partitioning_attr between 8736 and 8766
          >    or xx.partitioning_attr between 8249 and 7679
          >    or xx partitioning_attr between 7672 and 7702 )
          >
          >
          > WHEN NOT MATCHED THEN
          > Insert (
          >   aa.attr01
          > ,aa.attr02
          >     ...
          > ,aa.attr_last
          > )
          > ;

Bill, you may need to check the syntax, or the syntax you posted is not the same as what you describe.

What is the exact definition of xx in the above query, for example?

What are the UPDATEs you are talking about? You did not post them.

Victor

	<Prev	Next>		<<First	<Prev	Next>	Last>>