Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 24 Nov 2003 @ 18:17:08 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Executing multiple SQLs in parallel through JDBC
From:   Victor Sokovin

  Is MSR supported from JDBC at all?  

I think MSR should have been supported but the DR suggests that there are some issues with them.

  Could you please point me to any example code of running macro through JDBC? Would it be possible to retrieve the output of 7 SQLs as individual result sets in JDBC?  

The JDBC driver user guide contains a code example for stored procedures. It should be easy to change for macros. Statement method execute("exec macro_name;") will return multiple result sets which can be handled with getResultSet, getMoreResults and getUpdateCount. Alternatively, the macro can be written in such a way that it inserts results into some tables.



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