Hi jayesh! I was reading your reply to Chris and I have the same problem. I want to insert a cursor into the SQL. Can we send the cursor in one shot?
Before I read this message, I tried the same that suggest to chris. I made a remote view from the SQL. After that I execute an append from my_cursor (into the view of course). Then I execute a TableUpdate. It's was very bad!. It's not true that the cursor goes in one shot. I open the SQL trace application and I saw 20000 lines Insert into my_table Values(...). Maybe I configured in a wrong way the remote view. What do you recommend me? Asyncronicus, batchmode?
However, I also tried with a DoWhile, Sqlexec (Store procedure) EndDo and It's faster then the remote view. Anyway,... I would like to send the cursor directly, in one shot, and I think that maybe there is a command in ODBC like the Call or something.

So, What do you suggest?