Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Macro call from JDBC for Tactical Queries
 
From:   Dempsey, Mike

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