How can I prevent duplicate rows in a table?
From: Lawrence S Tracey <ltracey_at_ac-consulting.ch>
Date: 1996/07/31
Message-ID: <31ff483c.0_at_news.iprolink.ch>#1/1
Date: 1996/07/31
Message-ID: <31ff483c.0_at_news.iprolink.ch>#1/1
I have written a program which runs on an IBM mainframe and inserts
rows into a table on a server. There appears to be an intermitten bug
which causes some rows to be dropped. The next problem is when the
program has to be rerun. I get duplicate rows. I have put an index
on the table but this does not prevent the insertion of duplicate
rows. Is there a better way.
Also, the error messages returned vis SQL*NET are garbage in that I
get the same message "inconsistent data types" regardless of the error
on the server.
All help greatly appreciated. Received on Wed Jul 31 1996 - 00:00:00 CEST