Archives of the TeradataForum

Message Posted: Thu, 06 Jul 2006 @ 22:38:04 GMT

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

Macro result sets are returned in exactly the same way as a regular query.

For example:

     Select a,b,c from some_table
     ;select d,e from another_table;

Returns 2 result sets, one with 3 columns and one with 2.

Execing the following macro

     Replace macro test_macro as (
     Select a,b,c from some_table
     ;select d,e from another_table;
     )

Will also return 2 result sets, one with 3 columns and one with 2.

Sometimes it is easier just to give it a try.

B.T.W. why are you changing from views to macros?

Regards

Glenn Mc

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