Archives of the TeradataForum

Message Posted: Wed, 22 Mar 2006 @ 20:28:56 GMT

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

Peter:

If you wish to return rows from a select, you do not want to use a stored procedure when it is easier to use a macro. You can pass parameters to a macro in much the same fashion as a stored procedure except that you do not declare them as IN because that is all they are and SQL works get in a macro - even to the point of multiple SQL statements automatically become part of the same transaction.

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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