Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 24 Jun 2005 @ 13:58:40 GMT

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

Subj:   Re: Dirty Reads... Done Dirt Cheap
From:   Coffing Christopher L

You Wrote:

  "Is there a system setting that allows dirty reads (or any way to get dirty reads on a table without specifying it)? I have a vendor whose processes keep stepping on each other, but the don't want me to use views with locking for access in them. GRRR...  

If they will not let you create views to lock for access then perhaps they can insert a line in their SQL statements to "Lock Row for Access"

This will lock any tables for a dirty read within the query.

If they will not allow you to perform this task in the database then they will have to perform this task at the application level.

I have not heard of a way to perform a dirty read at a system level.

This isn't magic...

Any ideas would be greatly appreciated.

Chris Coffing

  <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