Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 11 Nov 2008 @ 13:43:53 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Multi Statement Transaction in Stored Procedure
From:   Dempsey, Mike

When creating a stored procedure SQL Assistant just submits the string as it was entered - it does not edit it at all. (I don't know what the ODBC driver and the compiler do - they may read the procedure statement by statement and cause the semicolon to move.)

As far as I know it doesn't matter where the semicolons are in a stored procedure though. The placing of the semicolon immediately before the statement to indicate that it should be part of the previous request is a BTEQ specific convention. I don't think it has any effect on how a stored procedure is interpreted.

I think you probably want to simply add a locking statement (for READ) in front of the Select. This ensures that the statement will wait if someone else is updating the table.

If this is the entire procedure you might be better off creating a macro instead of a procedure. A macro is always treated as a single transaction and will therefore do exactly what you want with less overhead.

Mike Dempsey
Teradata Client Tools

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020