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