Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 23 Mar 2005 @ 13:32:39 GMT

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

Subj:   Re: Purging Data from tables
From:   Victor Sokovin

  5. I came to know that we cant use a Multi Load delete because dateid is not a PI and MultiLoad delete will work only with WHERE condition on PI Columns.  

You don't need to fully qualify the rows if you use the BEGIN DELETE syntax. A quick quote from the manual:

"If you used a BEGIN DELETE MLOAD command to specify a delete task:

- You can apply the single DELETE statement to a table only, not to a view.

- The DELETE operation requires a full file scan.

- You must not specify equality values for all the primary index columns in the WHERE clause. You may, however, specify equality values for a lesser number of columns of a unique primary index.

The columns specified in this clause need not be a part of any index, but can be one or more nonindexed columns.

This clause may specify nonequality values for any combination of columns of unique indices, or any values for other columns."

Last time I tried this statement it worked as described above.

You are correct in you concern if you specify the import task with the BEGIN MLOAD command.



  <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: 15 Jun 2023