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

debadatta_mishra said: > > 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. INSERT INTO permanent_table SELECT * FROM temporary_table; > 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. Ne pas comprendez... -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco Travel broadens a person. You look as if you have been all over the world. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed http://i2.photobucket.com/albums/y41/Obnoxio/thinkIfoundtheproblem.jpg sending to informix-list