About SQL Code 0803N
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
About SQL Code 0803N
Hi,
One of my loading job is loading records into a DB2 table. Before loading into table I'm removing the duplicates on the primary key defined in DB2 table. Still I'm getting a lot of following warning msg:
"Hist_Tab: FAILURE
.Error code SQL0803N. Execute array one element at the time"
How can I avoid this msg?
-Nripendra
One of my loading job is loading records into a DB2 table. Before loading into table I'm removing the duplicates on the primary key defined in DB2 table. Still I'm getting a lot of following warning msg:
"Hist_Tab: FAILURE
.Error code SQL0803N. Execute array one element at the time"
How can I avoid this msg?
-Nripendra
Code: Select all
SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by index-id constrains table table-name from having duplicate rows for those columns.
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
[quote="skcwong"]I'm having the same problem with DB2 UDB stage (upsert option). Anyone got the solution? Thanks![/quote]
Is there any solution to this problem..I too getting the same issue..sql code SQL0803N i am getting the warnings ..i am using an upsert option..although the records are getting updated properly.Since there is a warning limit set i am getting the abend due to exceeding the warning limit
Is there any solution to this problem..I too getting the same issue..sql code SQL0803N i am getting the warnings ..i am using an upsert option..although the records are getting updated properly.Since there is a warning limit set i am getting the abend due to exceeding the warning limit