Archives of the TeradataForum

Message Posted: Wed, 26 Jul 2006 @ 14:11:31 GMT

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

The reason you only get the result set back when you execute your macro through Queryman / SQL Assistant is that these apps 'silently' do what your programmers are doing.

(They read the 'empty' result sets and silently discard them. Or more acurately, they detect that these are empty resultsets and simply request the next resultset until they find one that is not empty.)

This same kind of multi-resultset handling is required for other situations such as parallel statements, and the results from a 'Show Type' statement, for example, so you should probably add it anyway.

Mike Dempsey
Teradata Client Tools

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