Hi,
For surrogate key creation my client asked us to use MD5 function.
Sample function use:
UPCASE(GETMD5(ACCTG_PROJ:CHAR(9):ACCTG_ACT:CHAR(9):BUS_UN_GL:CHAR(9):BUS_UN_GL_FROM:CHAR(9):BUS_UN_BD:CHAR(9):RESRC_SUB_CAT:CHAR(9):WRK_LOC_CD:CHAR(9):HM_LOC_CD:CHAR(9):DEPT_ID:CHAR(9):BULK_ALLOC_CD:CHAR(9):PROJ_TRANS_CD:CHAR(9):OVHD_ALLOC_CD:CHAR(9):TEAM_CD))
Could you please explaine what is MD5? How can I implement this.
surrogate key
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I recommend a web search (Google, etc.) for MD5.
It's essentially a cryptographic hash function. It does not guarantee uniqueness, and therefore is a really poor choice for a surrogate key.
Resist stupid requirements!
It's essentially a cryptographic hash function. It does not guarantee uniqueness, and therefore is a really poor choice for a surrogate key.
Resist stupid requirements!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: surrogate key
Wikipedia wrote:In December 2008, a group of researchers used this technique to fake SSL certificate validity.,[7][8] and US-CERT now says that MD5 "should be considered cryptographically broken and unsuitable for further use." [9] and most U.S. government applications now require the SHA-2 family of hash functions. [10]
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.