Archives of the TeradataForum
Message Posted: Thu, 28 Mar 2013 @ 16:45:45 GMT
Firstly check the basics.
- you're running inTeradata mode (because if you're using ANSI then BT/ET are meaningless)
- are you calling any stored procedures as part of your processing? Do they issue any ET commands?
- check that you don't have any errors in a request BEFORE the one that you're checking. For instance:
BT; Request#1 works Request#2 works Request#3 fails - so DBMS rolls back Req#1 and Req#2 Request#4 works Request#5 works Request#6 fails - but now ONLY this one will get rolled back because Req#4 and Req#5 are in separate transactions ET; - this should fail with 3510 error.
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|