Archives of the TeradataForum

Message Posted: Fri, 09 May 2008 @ 15:52:05 GMT

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

Hi Pete:

Have you considered using a macro instead of a view?

     create macro acct_access (acct_no int) as
     (sel * from account_table
       where acct_number = :acct_no;);

     exec acct_access (1234567)

Plus, you can put more than one SQL statement into a macro and build a transaction.

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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