Archives of the TeradataForum
Message Posted: Wed, 18 Jun 2008 @ 17:57:48 GMT
> 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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|