Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 01 Aug 2002 @ 09:50:39 GMT

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

Subj:   Re: Volatile table & VB
From:   David Wellman

Check the following:

-- in your "create volatile table" statement do you have "ON COMMIT PRESERVE ROWS" option specified? If not, add it (just prior to semi- colon at end of statement).

If that's the case, I'd guess that the reason you're getting different results for Queryman vs. VB is the transaction semantics specified in each.

In Queryman you've probably got ANSI specified, this will keep the transaction open until you explicitly commit/logoff. In VB you've got nothing specified, which will use BTET (i.e. Teradata mode).



Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

  <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: 15 Jun 2023