Archives of the TeradataForum
Message Posted: Mon, 24 Nov 2003 @ 18:17:08 GMT
| 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.