Archives of the TeradataForum

Message Posted: Fri, 26 Nov 2010 @ 12:15:47 GMT

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

Hi Faible,

Sorry, but both those statements are incorrect.

An SP may contain both sql and SPL (non-sql) commands. The SPL commands run on a single PE (not AMP). Whether the sql runs on a single amp or many amps depends on the sql, indexes etc (just like any sql command executed in Teradata).

Transactions:

A macro will by default be treated as a single, ** entire ** transaction because if it contains multiple statements they are always treated as an msr. A macro may be ** part of ** a transaction.

With an SP you have a lot more control over transaction boundaries, you can terminate and start transactions within the SP. It all depends on your code.

What gets rolled back depends on whether you're running in Teradata mode or ANSI mode.

Cheers,

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )

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