Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 09 Dec 2008 @ 19:30:18 GMT

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

Subj:   Re: Rank and Delete?
From:   Anomy Anom

<-- Anonymously Posted: Tue, 9 Dec 2008 12:59 -->

An IMPORT MLOAD must always qualify by the (entire) primary index, for any DML statement applied.

But a DELETE MLOAD must not specify the PI. That's a special case where the DML must be a single DELETE for a single table. Try the subselect with that...

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020