Archives of the TeradataForum
Message Posted: Mon, 16 Jun 2003 @ 19:26:58 GMT
| Subj: || || Re: Perl and DBD::Teradata 1.13 |
| From: || || Geoffrey Rommel |
| ||Now I opened two connections and used one to SELECT and another to UPDATE. My idea was to use the SELECT to drive a loop and then an
UPDATE to make certain corrections over the same data. And when I tried to do it, the script blocks.|| |
Since these are now two separate sessions, you should be able to get around this problem by using "locking row for access
select..." in the first session. Unfortunately, I don't have time to test this idea.