RE: How to transfer data from temporary table to permanent table

What are you using to insert the records - 4GL ? something else ? Via an app you can set "whenever error continue", and code around this problem (using an insert cursor) -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of debadatta_mishra Sent: 18 April 2005 12:04 PM To: informix-list@iiug.org Subject: 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 sending to informix-list