#DateForumTypeThreadPost
1318 Aug 2016 @ 03:12 PDTDatabaseReplySQL command for setting connection option to return generated keysAny insight, anyone? (Bump)
1215 Aug 2016 @ 07:08 PDTDatabaseTopicSQL command for setting connection option to return generated keysHello, I am setting the following parameter in a connection string: ReturnGeneratedKeys="C" Instead, I'd like to set this option via an SQL command after having made the connecti...
1101 Mar 2016 @ 10:50 PSTDatabaseReplyLOCKING TABLE table_name FOR ACCESS can be blocked by other locksThanks Arparmar.  I have searched my codebase and am sure that it does not explicitly apply an exclusive lock.  Further, I am not using DDL in my codebase (which I understand implicitly a...
1001 Mar 2016 @ 09:54 PSTDatabaseReplyLOCKING TABLE table_name FOR ACCESS can be blocked by other locksOne further observation: When I instead lock the ROW for access (as below) followed by a SELECT statement, the command is not blocked. LOCKING ROW FOR ACCESS  
901 Mar 2016 @ 09:32 PSTDatabaseTopicLOCKING TABLE table_name FOR ACCESS can be blocked by other locksHello, I am trying to use the following statement so I can do a dirty read on a table which has locks applied to it from other users. LOCKING TABLE table_name FOR ACCESS The problem is, this s...
812 Oct 2015 @ 02:09 PDTDatabaseReplyWithin transaction, how to find keys from one table and use those to delete from other tables in a single request?Hi tomnolan, Thanks for your suggestion.  I think that if I do that, Teradata will do the subquery once for every table even though the result will always be the same.  I am trying to av...
712 Oct 2015 @ 01:05 PDTDatabaseTopicWithin transaction, how to find keys from one table and use those to delete from other tables in a single request?Hello, As the subject states, I am trying to find keys in one table and then use those keys to delete from multiple other tables.  I need to do this within a transaction where other things ar...
617 Aug 2015 @ 09:27 PDTDatabaseReplyHow to ensure atomic nature of multiple table actions?Dieter, I am using your suggested method with success.  Thanks for your help! FYI for anyone's future reference, I had to put a semicolon after "BEGIN TRANSACTION".
504 Aug 2015 @ 10:21 PDTDatabaseReplyHow to ensure atomic nature of multiple table actions?Dieter, thanks so much for your response.  Very helpful, as always.  I was actually wondering if something like your suggestion was a common practice or not, sounds like it is.  I wi...
404 Aug 2015 @ 05:57 PDTDatabaseReplyHow to ensure atomic nature of multiple table actions?I did some testing and found that in my example above, each line would individually acquire a lock instead of waiting for the "END TRANSACTION" to do it all at once.  So, even if it ...
304 Aug 2015 @ 05:34 PDTDatabaseReplyHow to ensure atomic nature of multiple table actions?Padhia, thanks very much for your response.  That is certainly helpful. One question that your response brought to mind is this: Is it possible to do a single transaction with multiple SQL qu...
231 Jul 2015 @ 10:39 PDTDatabaseReplyHow to ensure atomic nature of multiple table actions?31 views and no replies.  Can I ask the question in a better way?  Is something unclear?  Too long of a post?  I can do something with incomplete answers if people don't wan...
130 Jul 2015 @ 10:56 PDTDatabaseTopicHow to ensure atomic nature of multiple table actions?I am working on an application which generates a result that I want to store in a Teradata database.  The database consists of several tables and the application's result will span multipl...