Archives of the TeradataForum

Message Posted: Fri, 11 Nov 2005 @ 12:26:26 GMT


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

Subj:		Re: Stored procedures results

From:		cbarrineau

Boris,

By intermediate results, are you referring to various versions of the data as it is being manipulated by the stored procedure? If so, I typically start with Global Temp Tables (On Commit Preserve Rows) for trouble shooting purposes. This allows me to study the data through its various iterations. Once I have worked out all of the bugs, I'll change the definition of these tables to (On Commit Delete Rows.)

Let me know if I completely mis-understood your question.

Thanks,

Clay