Archives of the TeradataForum
Message Posted: Fri, 22 Apr 2005 @ 13:23:51 GMT
| Subj: || || Re: Updatable cursors via CLI |
| From: || || Geoffrey Rommel |
| ||I am trying to use updatable cursors via CLIv2 library but I cannot find how to do it. Could anyone give me a clue?|| |
I can't answer your question, but this statement from the Database Design manual may be of interest: "Cursor updates must be performed within
the same transaction as the SELECT statement that defined the cursor." So, if you're in Teradata mode, you will have to have BT ... ET around your
select/update; if in ANSI mode, a COMMIT after all updates.