Re: How can I prevent duplicate rows in a table?

Lawrence S Tracey wrote:
>
> 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.

Creating a UNIQUE INDEX on the table will prevent Duplicate row problem.

-- 
Ashok Kapur (akapur_at_thomtech.com)
Thomson Technology Consulting Group
1375 Piccard Drive, Suite 250
Rockville, MD 20850