Re: Embedded SQL Delete statement is not work

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

This looks like it should be possible, as of 7.2 - that looks like when 
the fetch clause was added to the DELETE statement.

But you would not need to read using the cursor - unless you are doing 
something else with each fetch along the way, maybe keeping track of how 
many?

I don't remember the other things you wanted to do, apologies if this 
reply doesn't fit.

Cheers
Vern

On 1/4/2021 7:38 AM, Timothy Feldmeier wrote:
> What is unique from what I am trying to do --- after reading the cursor, I want to delete a specified number  of records with the key coming from the cursor.
>
>
>
> Read Cursor................................
> If SQLCOD = 0..............
>
> EXEC SQL
> DELETE TIMSFILE
> WHERE ALXXX = :ALXXX
> FETCH FIRST :numberOfRows only;
>
> Enddo.......
>
>
>
>
>
>
> The information transmitted is intended only for the person or entity to which it is addressed and may contain proprietary, business-confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer.