How to transfer data from temporary table to permanent table

Hi all, Need help. 1. I have two tables with same schema one is temporary and another is permanent. How do we move all the data from temporary table to permanent table at once. 2.while using dbload command for a file if I have duplicate records in 1st and 4th , 10th and 15th then my error log is showing error in 1st to 4th then 15th record. But I need only records those having error to be printed in my error file. If I commit dbload on each record the error comes properly but that would be like I am inserting each record through insert command. Please suggest Regards Deba sending to informix-list sending to informix-list