Archives of the TeradataForum

Message Posted: Wed, 05 Jul 2006 @ 22:18:51 GMT


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

Subj:		Re: JDBC and global temporary tables

From:		McCall, Glenn David

My developers use JDBC connection to connect to Teradata and use WebMethod's web services to excite the macro and retrieve the data. And what I hear from them is that they don't have any way to iterate through the result set.

Alternatively what I did was inserted echo '.set quiet on/off' in the macro before and after the set of sqls whose output we really do care for.

Non SQL commands in macros (such as .set quiet on) are intended to work with bteq. Unfortunately they don't work over JDBC or ODBC. At the end of the day, I don't think that .set quiet on actually prevents the additional resultsets from being generated - it merely directs bteq to not report on them. It would still have to deal with them.

I don't know much about webmethods, but I guess you now have a question for web methods, how does one navigate through the multiple result sets generated by a multi-statement request?

Or more precisely, what is the web methods equivalent of:

     * java.sql.Statement.getMoreResults ()

Failing that is their a web methods user community ( www.wmusers.com ) you could ask?

The multiple result set capability provided via java.sql.Statement.getMoreResults () is not specific to Teradata. It is part of the JDBC API - and should work for any database capable of executing multi-statement requests (which is pretty much what a macro is).

There must be one!

Regards

Glenn Mc


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

Attachments

Library

Quick Reference