Using NextkeyGen() to create and insert surrogate key in target table . Jobs are in schedule. But due to regular insert surrogate key value exceeding the column limit . So its not able to insert data in table.
What is the process should i use in project to refresh the surrogate key values keeping data consistency and integrity within the tables.
Maintaining Surrogate key
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 59
- Joined: Thu Mar 20, 2008 12:11 am
The permanent solution is to increase your column length.
That won't help you maintaining the integrity among the tables.again re-generate it from starting
Last edited by kris007 on Wed Aug 11, 2010 12:25 pm, edited 1 time in total.
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
First define what you mean by "refreshing", generally rolling over a surrogate and starting to reuse them is not a good idea so I assume you mean something else.
ps. That really should be the permanent solution as well, properly sized key values should never overflow... unless we're talking about gi-nor-mous amounts of records here?
ps. That really should be the permanent solution as well, properly sized key values should never overflow... unless we're talking about gi-nor-mous amounts of records here?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers