Archives of the TeradataForum

Message Posted: Mon, 14 Mar 2005 @ 15:17:15 GMT

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

You can not use procedural logic in SQL Assistant.

You can do what you want using Import mode however.

Switch on Import mode (File, Import)

Execute the query:

     delete from Location where Location_ID mod 5 = ? ;

when it asks for the name of the import file point it to a file containing the numbers to be used. (One per line)

It will submit the delete statement once for each value in the file.

Since you are using Teradata Mode (as opposed to ANSI mode) each statement will automatically be treated as a separate transaction.

Mike Dempsey
Teradata Client Tools

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