Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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!


Glenn Mc

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016