Archives of the TeradataForum
Message Posted: Thu, 01 Aug 2002 @ 09:50:39 GMT
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)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|