Positioned update and delete via CLIv2

Tools

Positioned update and delete via CLIv2

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.

Any help would be appreciated.

Regards

Ben
1 REPLY

Re: Positioned update and delete via CLIv2

I'm surprised at the lack of response to what would seem a fairly common thing to do. I notice there are a lot viewings on this topic, does this mean that no-one uses the Cliv2?