Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Using Teradata Procedural Language
From:   Dempsey, Mike

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023