Re: Using encryption/decryption of column data via a program

Vern, et al,

Thanks for the info. Trying to find the InfoCenter via the Search on ibm.com was a real hassle; still not sure I found it. In any event....

for you or others that can help, my research so far shows the ENCRYPT and DECRYPT SQL functions require the IBM Cryptographic Feature (old program product 5722-AC3, now supposedly called Network Authentication Enablement, 5722-NAE) be installed if you are as we are on V5R4. It appears like we have 5722-NAE is installed. However, when I go to STRSQL and invoke things like SET ENCRYPTION PASSWORD... or ENCRYPT, just to kick the tires, I get the messages like "SQL Not allowed or TOKEN not valid". So, how do you use in SQL?

As to Qc3EncryptData, is there anyone that has example code they'd like to share on how to invoke this. The manual I found so far was not very helpful in that regard. I'm hoping to invoke via REXX but will consider other languages that can be called from REXX.

I'd prefer to use the SQL solution but should consider both.

Thanks in advance,

Dave