db2 hash functions

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • mvahlu@gmail.com
    #1

    db2 hash functions

    Hi,

    Could someone please tell me whether DB2 supports hash functions such
    as MD5sum and SHA-1 or checksums like CRC-32. I would like to know
    whether the DB2 database would have a function like SQL server and
    Oracle have that takes an input of a certain length and computes a
    hash. I do not want to write a JAVA MD5 class and run it on someone
    else's DB which happens to be DB2 because that would take time. So,
    if DB2 supports an in-built hash function, please advice.

    Thanks
    Tags: None
    • Ian
      #2
      Re: db2 hash functions

      mvahlu@gmail.co m wrote:
      Hi,
      >
      Could someone please tell me whether DB2 supports hash functions such
      as MD5sum and SHA-1 or checksums like CRC-32. I would like to know
      whether the DB2 database would have a function like SQL server and
      Oracle have that takes an input of a certain length and computes a
      hash. I do not want to write a JAVA MD5 class and run it on someone
      else's DB which happens to be DB2 because that would take time. So,
      if DB2 supports an in-built hash function, please advice.
      It does not. You would have to use a UDF.


        Comment

        Previous template Next
        Working...