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

NAME

       php_md5 - DB2 UDF and SP to generate an MD5 hash

SYNOPSIS

       >>-PHP_MD5--(--expression--)-----------------------------------><

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

DESCRIPTION

       MD5 hash. The php_md5 routine is compatible to the PHP md5 function.

       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(32). 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 md5 hash of the clear text testpwd to
       the table users.

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

       Example 2:

       SELECT php_md5( 'testpwd' ) FROM SYSIBM.SYSDUMMY1

       1
       --------------------------------
       342df5b036b2f28184536820af6d1caf

         1 record(s) selected.

       Example 3:

       CALL php_md5('testpwd', ?)

         Value of output parameters
         --------------------------
         Parameter Name  : HASH
         Parameter Value : 342df5b036b2f28184536820af6d1caf

         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



php_md5                            June 2015                        php_md5(8)