Explanation
During a CREATE or ALTER TABLE, you attempted to add a primary key, but one had been defined either earlier in the current statement or at a previous time.
The SQLSTATE that equates to this SQL return code is 42889.
User Response
Modify the statement to define only one primary key per table. You may use CA Datacom Datadictionary to determine what primary key already exists, or you may query the SIT.
|
Copyright © 2014 CA.
All rights reserved.
|
|