Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: JDBC and global temporary tables
 
From:   McCall, Glenn David

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023