sha512(8) DB2 User Defined Function and Stored Procedure sha512(8) 

NAME

 sha512 - DB2 UDF and SP to generate an SHA512 hash 

SYNOPSIS

 >>-SHA512--(--expression--+---------+--)----------------------->< '-,--salt-' >>-SHA512--(--expression--+---------+--,--hash--)-------------->< '-,--salt-' 

DESCRIPTION

 SHA512 algorithm. The sha512 routine returns a glibc2's crypt hash. If the system's crypt does not support sha-512, an SQLSTATE 39702 is returned. The argument can be a character string that is either a CHAR or VARCHAR not exceeding 4096 bytes. An optional salt can be specified, which must be a eight-character string chosen from the set [a-zA-Z0-9./]. If the salt is not exactly eight characters long, an SQLSTATE 39703 is returned. If the salt contains invalid characters, an SQLSTATE 39704 is returned. The result of the function is CHAR(98). The result can be null; if one the arguments is null, the result is the null value. 

EXAMPLES

 Example 1: Inserting the user test and the sha512 crypted clear text testpwd to the table users. INSERT INTO USERS (username, password) VALUES ('test', sha512('testpwd')) Example 2: SELECT sha512('testpwd') FROM SYSIBM.SYSDUMMY1 1 -------------------------------------------------------------------------------------------------- $6$cD33haq7$dl.RqEaLamlesTPVzSIQr4N1MY3BsVZ76VS8qNte0IOIWO2XorMg8U797KKOFGmX8dJhT3WuF6p17HmvvoQ6Q/ 1 record(s) selected. Example 3: CALL sha512('testpwd', ?) Value of output parameters -------------------------- Parameter Name : HASH Parameter Value : $6$1W.m9JN1$Dh.VPl7vy.igGaeDUdDWw6ZlD0xufwDWm0ukpOYknPtdjxiSM2yzWBkzHffalb/2axNHPqEi9UUzXUbSm4LGa/ Return Status = 0 Example 4: SELECT sha512('testpwd', '12345678') FROM SYSIBM.SYSDUMMY1 1 -------------------------------------------------------------------------------------------------- $6$12345678$tlHrypdWTz6FqubBpgL/ePlxr4lZuQ8OK1zfV6zWUmGJSz.5kGWwQGjg69Qm1Bm3.DvILruqA61o3EHsxSoko1 1 record(s) selected. Example 5: CALL sha512('testpwd', '12345678', ?) Value of output parameters -------------------------- Parameter Name : HASH Parameter Value : $6$12345678$tlHrypdWTz6FqubBpgL/ePlxr4lZuQ8OK1zfV6zWUmGJSz.5kGWwQGjg69Qm1Bm3.DvILruqA61o3EHsxSoko1 Return Status = 0 

AUTHOR

 Written by Helmut K. C. Tessarek. 

BUGS

 Hopefully none :-) But if you find one, please report it at: https://github.com/tessus/db2-hash-routines/issues 

WEB SITE

 http://tessus.github.io/db2-hash-routines sha512 May 2017 sha512(8)