FIELDPROC encryption - where is the encoded value stored?

[jayvaughn]

I cannot find the answer to this anywhere except "it is stored in the database" - where? is it proprietary? I'd like to query the appropriate file and see it. The encoded value not the sysfields fieldproc description.

Anybody know?

[tomliotta]

I can't make sense of the question. Can you provide a specific example scenario that demonstrates the point that needs an answer? The question sounds to me like, "I have a table with a CustomerName column. Where is the CustomerName value stored?"

[jayvaughn]

If you have any knowledge of fieldprocs utilized as endpoint pgms for encryption then the question should stick out like a sore thumb.
Where does the db2 engine store the encoded value at rest? Even if the value is unintelligible, can it still be queried from it's at rest location? And where is that location?