Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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
     JDBC 3.01.00..03

Any clues / suggestion would be highly appreciated!!!



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