Hi,

I'm using DB2 v8.1.1.40 and FixPak "4"

When I try to insert data into Federated table using load cursor, it doesn't work .. but if I use select insert, it works fine.

I'm running the following script (doesn't work) :

create nickname ORFED01.TEST for db2base.ORTMP01.TEST;
declare cpy_credit_data cursor for select * from ORDWTB.TEST;
load client from cpy_credit_data of cursor replace into ORFED01.TEST statistics yes nonrecoverable;

I'm getting the following error :
SQL3015N An SQL error "" occurred during processing

When I run the following script, it works :
create nickname ORFED01.TEST for db2base.ORTMP01.TEST;
insert into ORFED01.TEST select t.* from ORDWTB.TEST t

I don't understand why it doesn't work with load cursor; as load cursor is much more faster than select insert, I need to use load cursor process to insert data into the table.

Please let me know what you think.

Thanks in advance,
Mridul

Mridul, AFAIK, you cannot use LOAD to load data into a remote object ...

LOAD is not SQL

Sathyaram

Why not try turning it around. Instead of federating from the source to the target, federate from the target to the source. Make a nickname for the source table on the target server, then use load from cursor by running it on the target server. I do not know if this will work, but it should be worth a try.

Andy

Andy, That will work ... I have used it successfully in the past ..

Sathyaram

Thanks to both of you for your valuable input. I know it would work if I do the stuffs in the trager server, but for this I had to open a new port instead of the existing opened port.