Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Tue, 06 Jun 2007 @ 01:21:10 GMT


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


Subj:   Re: Locking/unlocking a table
 
From:   fachtna.c.donovan

Hi,

You could do some thing like the following

     BEGIN TRANSACTION;

     Locking table  db.tableName1 for read;
     Locking table  db.tableName2 for read;
     Locking table  db.tableName3 for read;

     Do SQL/DML stuff1;
     Do SQL/DML stuff2;

     END TRANSACTION;

Fachtna O'Donovan AIB Bank
Ireland



     
  <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: 28 Jun 2020