Archives of the TeradataForum

Message Posted: Fri, 06 Aug 2004 @ 08:55:11 GMT

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

Hi,

I just started working with Teradata so I'm not an experienced user but I also noticed that locking is quite a problem. I work with Teradata stored procedures and I found out that if the procedure is called more than twice (at the same time), locks occur and Teradata is not able to resolve them. I tried adding "locking" statement but finally I added "commit" statement after almost each SQL statement (because the processing does not need to be transactional in thios case). This helped but the locks still occur from time to time.

I f anyone has an idea what else can be improved, let us know.

Marek

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