Re: Removing dublicate records in table and hostarray

Hi Bob,

> Could you process your transactions from X, putting the records to be
> inserted into :host_array, omitting the dupes. Then from :host_array
> INSERT into Y.
> Omitting the known dupes before hand will cutdown on Rollbacks due
> to Dupe PK and increase overall speed.

Yes, that is what i'm aiming at, but i'm thinking of how to do it fast.

Explanation:

I can read 1000 records to the hostarray. I want to find the dupes before inserting into the table. The hostarray may contain records that are in the table. I would like a select statement returning a status for each record in the hostarray, e.g. 0 if it's not a dupe, and 1 if it is. Then i would know which records to ignore, and which to insert.

Do you think this is possible?

Best regards,
Brian

Brian Rasmusson, Software engineer & analyst        e-mail: br_at_belle.dk
Belle Systems A/S                                   web   : www.belle.dk
Network, Internet and communication specialists     phone : +45 59442500
------------------------------------------------------------------------