Re: Decrypt_Char

["Mark S. Waterbury" <mark.s.waterbury@xxxxxxx>]

Hi, Doug:

Check this out:
   
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg247399.html?Open

HTH,

Mark

> Doug Palme wrote:
> I have been playing around with some encryption with SQL and I can get it 
> encrypted just fine......however, trying to decrypt it just is not 
> working.
>
> I have a table with one field created, its a char(25).
>
> I encrypted the data with the following command
>
> INSERT INTO DPTEST1 VALUES ENCRYPT_RC2('SCOTT', 'PASSWORD1','')
>
> it works, however when I try to decrypt it with the following, I get a 
> "ARGUMENT 01 of Function DECRYPT_CHAR not valid:
>
> SELECT DECRYPT_CHAR( SSN, 'PASSWORD1') FROM DPTEST1
>
> Any idea what I am doing wrong?
>
> This transmission may contain information that is privileged, confidential 
> and/or exempt from disclosure under applicable law. If you are not the 
> intended recipient, you are hereby notified that any disclosure, copying, 
> distribution, or use of the information contained herein (including any 
> reliance thereon) is STRICTLY PROHIBITED. If you received this 
> transmission in error, please immediately contact the sender and destroy 
> the material in its entirety, whether in electronic or hard copy format. 
> Thank you.
>