Archives of the TeradataForum
Message Posted: Tue, 26 Feb 2008 @ 18:54:38 GMT
1. what happens if your SQL includes explicit transaction (BT/ET) commands ? Do they get ignored ?
Not sure.. I believe for good practice its good to control transaction through backend only. We used to call oracle stored procedure through Java and handle commit/rollback in SP even and always return the some status to Java to show error/messages etc.
2. How you can implement multiple SQL requests..
If you want to use JDBC and Teradata and also want to control Transactions then I believe you need to use MACRO (TERADATA MACROS). You can also use Teradata Stored Procedure for this but good to use Macros.
Kapil D Sapra
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|