Documentation
Manual in PDF format.
man pages
- db2-hash-routines
- bcrypt
- sha256_hex
- sha1_hex
- sha256
- sha512
- apr_crypt
- apr_md5
- apr_sha1
- apr_sha256
- php_md5
- validate_pw
Examples
db2 => values bcrypt('cleartext') 1 ------------------------------------------------------------ $2y$05$WCC47DM2xelWQCGDKEAeNOP9BCRE6IyuMjOtGH5hKMB392XuSWInG 1 record(s) selected. db2 => call bcrypt('cleartext', ?) Value of output parameters -------------------------- Parameter Name : HASH Parameter Value : $2y$05$vo.ybx/7TPTqB7w.RtdLf.M7rqjG5UIJ1wJpSRdIfOxg9CIBNDU3S Return Status = 0 db2 => call validate_pw('cleartext', '$2y$05$vo.ybx/7TPTqB7w.RtdLf.M7rqjG5UIJ1wJpSRdIfOxg9CIBNDU3S', ?) Value of output parameters -------------------------- Parameter Name : IS_VALID Parameter Value : 1 Return Status = 0 db2 => values validate_pw('wrong cleartext', '$2y$05$vo.ybx/7TPTqB7w.RtdLf.M7rqjG5UIJ1wJpSRdIfOxg9CIBNDU3S', ?) 1 ----------- 0 1 record(s) selected. db2 => values apr_sha256('cleartext') 1 ---------------------------------------------------- {SHA256}BQF0CEQFCEafJRsQjaPfZ8YBq5Fm80WqLBr9s90f8tw= 1 record(s) selected. db2 => values sha256('cleartext') 1 ------------------------------------------------------- $5$Yj7xpt8h$wkod.Gp8Uviu4OhYguPgUYq.aPGcIbWInz1fnvDC1I1 1 record(s) selected. Support
Having trouble with db2-hash-routines? Please open a ticket here.