Archives of the TeradataForum
Message Posted: Mon, 03 Jul 2006 @ 20:29:09 GMT
| Subj: || || JDBC and global temporary tables |
| From: || || Anomy Anom |
<-- 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
Any clues / suggestion would be highly appreciated!!!