Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 25 Feb 2003 @ 19:53:47 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Utility Lock
From:   David Wellman


A little difficult in Teradata. There's no direct equivalent.

Assuming that your "setup the environment" involves issuing DDL commands then you can't use transaction locks.

Probably your best/safest bet is to revoke everyone's AccessRights for the duration of your processing. This is either

-- at the database level if your talking about setting up tables, views and macros etc within a single Teradata database but you want people to be able to acess other databases on the same machine, OR

-- at the logon level (i.e. remove the ability for people to logon to the machine) if you're talking about setting up an entire Teradata machine.


  <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