Is there any way to ... except any method proven to work?
SQL isn't an add in - it IS native. There's nothing on a system without
57##-ST1 stopping them from setting this up. You can hold your breath
until you turn blue in the face waiting for IBM to enhance DDS to add
function.
Look up FIELDPROC in the 7.1 infocenter.
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzhctabl.htm
Another way is column level security. Back on the AS/400 you had to do
this by disallowing direct access to the PF and all access was via LF's.
And the LF just wouldn't include that column. Doesn't count as encryption
though.
See also:
DECRYPT_BIT, DECRYPT_BINARY, DECRYPT_CHAR and DECRYPT_DB
The DECRYPT_BIT, DECRYPT_BINARY, DECRYPT_CHAR, and DECRYPT_DB functions
return a value that is the result of decrypting encrypted data. The
password used for decryption is either the password-string value or the
ENCRYPTION PASSWORD value assigned by the SET ENCRYPTION PASSWORD
statement.
or
ENCRYPT_AES
The ENCRYPT_AES function returns a value that is the result of encrypting
data-string using the AES encryption algorithm. The password used for
decryption is either the password-string value or the encryption password
value (assigned by the SET ENCRYPTION PASSWORD statement).
ENCRYPT_RC2
The ENCRYPT_RC2 function returns a value that is the result of encrypting
data-string using the RC2 encryption algorithm. The password used for
decryption is either the password-string value or the encryption password
value (assigned by the SET ENCRYPTION PASSWORD statement).
ENCRYPT_TDES
The ENCRYPT_TDES function returns a value that is the result of encrypting
data-string using the Triple DES encryption algorithm. The password used
for decryption is either the password-string value or the encryption
password value (assigned by the SET ENCRYPTION PASSWORD statement).
at
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzscale.htm
SQL is also mentioned in the special cryptography section of infocenter.
Rob Berendt
midrange.com
