Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 Jul 2006 @ 16:45:29 GMT


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


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023