Archives of the TeradataForum
Message Posted: Mon, 14 Mar 2005 @ 15:17:15 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|