Re: Appending from a Cursor

On Thu, 12 Apr 2018, at 1:31 PM, Jean MAURICE wrote:

Hi Gene,

'append from' appends data from a file on the disk and a cursor is not a file !

A cursor may or may not have a disk presence depending on various factors.

But SQL is a a better way to do it.

insert into mytable (f1, f2, f3) select (f1, f2, f3) from mycursor