 |
 |
Archives of the TeradataForum
Message Posted: Wed, 26 Jul 2006 @ 16:45:29 GMT
| Subj: | | Re: Macro call from JDBC for Tactical Queries |
| |
| From: | | McCall, Glenn David |
| | However, when the call is made from Java (using JDBC) we get three result sets back from the Macro : one to indicate that a delete has been
made to the GTT, one to show that an Insert has been made to the GTT and the third provides the actual result set - the bit we want. | |
| | Our programmers - bless them - have resolved this by looping through the three result sets back until we get to the actual business
data. | |
| | I just feel that this shouldn't be necessary, given that when you execute the same Macro through Queryman you only get the business data
back. | |
Actually ODBC will also return the results of the individual statements as well.
Queryman (bless it) simply steps over the activity reports and only displays the actual business data.
In other circumstances, it may be necessary to know how many rows if any were "hit" by the action queries. So it is better that it be returned
than not.
Glenn Mc
| |
