Multiload data from a table to another

Database
Enthusiast

Multiload data from a table to another

Hi,

For an upcoming project, I am required to pull data from a table on database A and load it into a table on database B.

I used FASTLOAD in my scipt for this purpose. It works fine, but in case there is any error and the script fails, the target table gets locked and we have to drop and create the table to use it again.

Therefore, I was wondering if Multiload can be used for this purpose.

Please let me know your views and suggestions for this.

Tags (1)
1 REPLY
sin
Fan

Re: Multiload data from a table to another

Multiload behaviour is the same. To release lock in Multiload you can use command RELEASE MLOAD (I can't remember exactly command syntaxis now). Or you can run empty multyoad/fastload task - without INSERT statement - to release lock on the table.