Archives of the TeradataForum

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

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

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).

Cheers,

Dave

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

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