Archives of the TeradataForum

Message Posted: Mon, 03 Jul 2006 @ 20:29:09 GMT

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

<-- Anonymously Posted: Monday, July 03, 2006 15:09 -->

One of our applications trying to retrieve data by running a macro on the Teradata database using a JDBC /Web Methods program. The macro executes series of delete/insert/update sqls and the final select which returns data to the application selects from a persistent Global Temporary table (global temporary table with ON COMMIT PRESERVE ROWS ). The application returns no rows when selecting data from the Global Temporary table. However when the macro was run from SQL Assistant and / or macro was modified to not use the Global temporary table the user / application was able to get back the data.

     Teradata version 05.01.02.43
     JDBC 3.01.00..03

Any clues / suggestion would be highly appreciated!!!

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