MD5
Calculates the checksum of the input value. The function uses Message-Digest algorithm 5 (MD5). MD5 is a one-way cryptographic hash function with a 128-bit hash value. You can conclude that input values are different when the checksums of the input values are different. Use MD5 to verify data integrity.
Syntax
MD5( value )
The following table describes the argument for this command:
Argument | Required/ Optional | Description |
|---|
value | Required | String or Binary datatype. Value for which you want to calculate checksum. The case of the input value affects the return value. For example, MD5(informatica) and MD5(Informatica) return different values. |
Return Value
Unique 32-character string of hexadecimal digits 0-9 and a-f.
NULL if the input is a null value.
Example
You want to write changed data to a database. Use MD5 to generate checksum values for rows of data you read from a source. When you run a session, compare the previously generated checksum values against the new checksum values. Then, write the rows with updated checksum values to the target. You can conclude that an updated checksum value indicates that the data has changed.
Tip
You can use the return value as a hash key.