Archives of the TeradataForum

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

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

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.

Regards,

Victor

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