When I use the WRKFLDENC command the display shows that encryption is *ACTIVE (see screen print below)
but when I view the value for data in field that should be encrypted , it is NOT encrypted.
When I try to Deactivate via opt# 8 , then I get message in joblog (see below):
Error A field Procedure does not exist for this field
Can you tell me how I can get Field Encryption working again in my environment.
This was setup and working correctly at one time, then I restored a file and now it does not work.
We are on IBMi V7R1M0 and CRYPTO v3.57
Thanks
John M. Petenes
Sr Programmer/Analyst
Bunzl Retail Services, LLC
8338 Austin Avenue | Morton Grove IL 60053
Direct: (847) 967-4958
------------
Display Field Encryption Entry (DSPFLDENCV)
Type choices, press Enter.
Field identifier . . . . . . . . JADVPDTA_F0030_AYCBNK
Status . . . . . . . . . . . . . *ACTIVE
Database field name . . . . . . AYCBNK
Database file name . . . . . . . F0030
Library . . . . . . . . . . . JADVPDTA
Database field type . . . . . . *CHAR
Database field length . . . . . 20
Database field decimal pos . . .
Encryption key label . . . . . . BANK_ACCOUNT_KEY
Encryption key store name . . . KEYSTORE
CRYPTOKEYS
Decryption key label . . . . . . BANK_ACCOUNT_KEY
Decryption key store name . . . KEYSTORE
CRYPTOKEYS
Encryption algorithm . . . . . . *AES256
Algorithm mode . . . . . . . . . *ECB
Calculated cipher text length . 24
Calculated block length . . . . 24
Masking option . . . . . . . . . *OPTION2
Char/digits to show on left . . 0
Char/digits to show on right . . 4
Masking value . . . . . . . . . '*'
Auth. list for full value . . . CRYPTOFULL
Auth. list for masked value . . CRYPTOMASK
Auth. list caching . . . . . . . *NO
Not authorized field value . . . 'X'
Store values in external file . *NO
Use triggers to auto encrypt . . *NO
Use DB2 field procedure . . . . *YES
Field procedure return value . . *AUTH
Last modified by user . . . . . THECRYPT
Last modified date/time . . . . '2017-08-30-15.56.37.956000'
