Archives of the TeradataForum
Message Posted: Wed, 05 Jul 2006 @ 22:18:51 GMT
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!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|