|
|
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.
Regards,
Victor
| |