Results 1 to 2 of 2

Thread: Decrypt_char

  1. #1
    Join Date
    May 2003
    Posts
    1

    Unanswered: Decrypt_char

    I'm unable to use the dcrypt-char funtion, each I use it like :

    select decrypt_char(password_field, 'schumacher') from table where login = 'eriche'"

    I have always the same error:

    SQL0171N The data type, length or value of argument "1" of routine
    "SYSIBM.DECRYPT" is incorrect. SQLSTATE=42815

    help!

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    According th the SQL Reference the data type for arg1 must be CHAR FOR BIT DATA or VARCHAR FOR BIT DATA.

    If not, you will get the error you got.

    You can try casting the data to one of these types.

    HTH

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •