Archives of the TeradataForum

Message Posted: Tue, 26 Nov 2002 @ 17:15:25 GMT

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

Thanks Narayan for your explanation it was really of great help. I do have a follow up question. I am working on application that is not truly a data warehouse /Decision support system. We have lot of set logic sql statements that perform 'Insert' follow by 'Select'. If we were to use macros would as you pointed out 'bundle all sql statements in to one multistatement' this would lock multiple tables for write leading to table contentions. Are stored procedures the way to go under the circumstances? Does stored procedures lock required resources as they need (execute one sql statement at a time) Again I appreciate your help.

Sada Shirol

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