Hi Tore,
Thanks for all your help. I've decided to use SQL INSERT instead of APPEND FROM because the INSERT statement works and the APPEND FROM seems to have a bug when appending from some cursors, so I am not going to pursue the APPEND FROM problem at least for now.
Best regards, Chaim

PS Thanks also to all who replied and offered suggestions on this thread.