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 [mailtowner-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