We have to encrypt two columns on one DB2. We have set it up as a varbinary with a with of 32 characters.
Using an insert statement we added the column not problem;
INSERT INTO YCCFSSC5.BANK_ACCOUNT (TX_PRVD_ACCTN_NMBR)
Accessing using a select statement works also
SELECT DECRYPT_CHAR(TX_PRVD_ACCTN_NMBR, 'CTKIND')
How do we incorporate this into a DataWindow so we can retrieve, insert and update the columns