OK now that I have graduated from iseries SQL encryption 101 (OK the first hour of class anyways):
Is it possible to encrypt a 10 byte character field in place? (Lets assume it was created with FOR BIT DATA).
TaxFile contains 9 digit SSN.
Is it possible in SQL to:
update TaxFile set SSN=Encrypt_RC2(SSN) to provide an encrypted SSN?
It doesn't seem possible since the receiving field is larger than the source field.
Any ideas or other methods that can encrypt a field in place (without expansion)?
It doesn't seem theoretically impossible (although maybe less secure).
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com