Field Level Encryption using FieldProc in IBM i V7R1
We would like to encrypt the following fields using field level encryption (field proc) on an IBM I (AS/400) at V7R1
FILE F0101
Fields ABTAX
ABTX2
FILE F0030
Fields AYTNST
ACYBNK
We have run into several oddities. For example, A Vendor Lookup (Name Search) on a particular vendor brought the vendor up three times, but they were all the same vendor number. We looked up another vendor number by name and could not find him at all. However, a search by vendor number brought him up but the Alpha name was blank.
There are more examples but my question is, are there anyone out there who is using or trying to use field level encryption and, if so, how are you handling this?