I wonder if anyone could help answer the following please.
I am trying out Teradata on windows and have the 8.1 demo CD. I am working on an application that is using the cliv2 to interface with the database and I'm currently trying to implement positioned updates and deletes:
I create and execute one statement similar to:
SELECT A FROM MYTABLE FOR CURSOR;
Which executes fine. I then try and execute a delete for example:
DELETE FROM MYTABLE WHERE CURRENT OF CURS0;
I have a couple of questions relating to this:
1: How can you specify the cursor name in the SELECT statement to use in the DELETE or UPDATE? - at the moment CURS0 is just made up 2: When executing the DELETE I get the following: Msg = 0x033ca508 "The facility of WHERE CURRENT cursorname has not been implemented yet." - this is wierd, because why would it be documented if it wasn't supported? I should say right now that I have set the DBCAREA.tx_semantics to 'A' so I should be using ANSI transaction semantics.