|
|
Archives of the TeradataForum
Message Posted: Fri, 21 Nov 2003 @ 18:30:35 GMT
Subj: | | Re: Executing multiple SQLs in parallel through JDBC |
|
From: | | Victor Sokovin |
Kiran,
On Fri, 21 Nov 2003 09:33:42 -0500, Pudhota, Kiran K wrote:
| [1] Statement.execute, getMoreResults, getResultSet - How would one code multiple SQL statements as a single String. (separate using
; ?) | |
DR61092 seems to suggest that multi-statements requests (MSR) do not work with the JDBC driver 02.02.
| [2] Write a stored procedure to return 7 out parameters as cursors - Would this help in reducing the overall time to a great
extent? Would appreciate if you could point us to some sample code that shows how to work with cursors in Teradata stored
procedures. | |
Have you considered a macro with 7 queries? It will run as an MSR and will perhaps be the easiest option. It is also likely to be faster
than an SP when executed multiple times. You can find some run time statistics in this month's thread "Stored Procedures or Macros".
Regards,
Victor
| |