Archives of the TeradataForum

Message Posted: Tue, 04 Jul 2006 @ 09:36:19 GMT

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

With a macro such as this, the result set will not be the first result set.

You need to use the java.sql.Statement.getMoreResults () method to step through the result sets until you get to the one containing the output.

In your case, the macro will generate a series of "update counts" results corresponding to the updates, deletes and inserts. Eventually you will get to a "resultSet" result set which contains the data from the table (getMoreResults returns true).

The same thing is happening in SQL Assistant. The only difference is that SQL assistant will do this stepping through the "update count" result sets automatically for you. If you exec your macro from bteq, you should see the individual result sets (i.e. the "update counts" as well as the content of the table).

Make sure you read the javadocs for getMoreResults, because it will tell you how to correctly determine when you've reached then end of the results.

I hope this helps

Glenn Mc

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