Archives of the TeradataForum

Message Posted: Thu, 24 Apr 2014 @ 17:35:16 GMT

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

Thank you Dieter and Dave for setting me straight on Locks; I have to hang my head in ignorant shame !

So, I guess the Row Hash Lock side of Concurrency is what T-Pump takes advantage of.

Anyway, out of interest, if anyone was considering opening as degree of Transactional capability within Teradata (uh hum, no names), you wouldn't see that as an overly concerning approach ? ?For some reason, I expected someone to tell me that it would be a stark starring mad thought even to consider. ?

As long as Row Hash Locks are involved, and there's no concurrent Batch suit in operation, then I suppose it's not much different to a Tactical Query - is it ?

Lastly, if anyone currently allows this, what type of software do you use to build a Data Entry screen over Teradata ? ?

Regards

David Clough
Senior BI Database Designer
BI Competency Centre

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