Duplicate Key

Post by **admin** » Wed Sep 06, 2000 1:04 pm

What could possible be causing this?

I have the ODBCStage set up to Clear Rows then Insert. The key in Universe is SCR67496 and it only exists once.

SQLSTATE=23000, DBMS.CODE=2627
[Ardent][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint PK_REP. Cannot insert duplicate key in object REP. SQLSTATE=01000, DBMS.CODE=3621 [Ardent][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

Post by **admin** » Wed Sep 06, 2000 11:30 pm

Mike:

Are you normalizing on an association as you come out of UniVerse? If so, you are generating multiple rows per record key.

Bill

-----Original Message-----
From: Roosa, Mike [mailto:Mike.Roosa@getronics.com]
Sent: Wednesday, September 06, 2000 6:04 AM
To: informix-datastage@oliver.com
Subject: Duplicate Key

What could possible be causing this?

I have the ODBCStage set up to Clear Rows then Insert. The key in Universe is SCR67496 and it only exists once.

SQLSTATE=23000, DBMS.CODE=2627
[Ardent][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint PK_REP. Cannot insert duplicate key in object REP. SQLSTATE=01000, DBMS.CODE=3621 [Ardent][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.