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

NAME

       sha256_hex - DB2 UDF and SP to generate an SHA256 64-character hexadec-
       imal hash

SYNOPSIS

       >>-SHA256_HEX--(--expression--)--------------------------------><

       >>-SHA256_HEX--(--expression--,--hash--)-----------------------><

DESCRIPTION

       SHA256 algorithm. The sha256_hex routine returns a  64-character  hexa-
       decimal hash.

       The argument can be a character string that is either a CHAR or VARCHAR
       not exceeding 4096 bytes.

       The result of the function is CHAR(64). The result can be null; if  the
       argument is null, the result is the null value.

EXAMPLES

       Example 1:

       Inserting  the  user  test and the sha256 crypted clear text testpwd to
       the table users.

       INSERT INTO USERS (username, password)
         VALUES ('test', sha256_hex('testpwd'))

       Example 2:

       SELECT sha256_hex('testpwd') FROM SYSIBM.SYSDUMMY1

       1
       ----------------------------------------------------------------
       a85b6a20813c31a8b1b3f3618da796271c9aa293b3f809873053b21aec501087

         1 record(s) selected.

       Example 3:

       CALL sha256_hex('testpwd', ?)

         Value of output parameters
         --------------------------
         Parameter Name  : HASH
         Parameter Value : a85b6a20813c31a8b1b3f3618da796271c9aa293b3f809873053b21aec501087

         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



sha256_hex                         May 2017                      sha256_hex(8)