>>>Have you ever done this? Every time I've tried to alter table with a cursor I get an error that says it is an invalid operation for a cursor.
>>
>>The cursor must be read-write, then it's "legal".
>
>I must have something wrong. This code fails for me.
>
>select * from tip into cursor temp readwrite
>alter table temp add column sc20 c(10)
>
Worked for me