My team is working on an in-house encryption solution using FieldProcs. We are storing all of our customer sensitive data on a single database and encrypting each field using a Fieldproc exit routine.
I am attempting to change the program name on one of the fields and think that I must first drop the fieldproc and then re-add with the new program name. In dropping, I am getting an error. My sql code looks like this:
ALTER TABLE mylib/mytable ALTER COLUMN field2 DROP FIELDPROC
I am getting this error:
Field procedure on column field1 returned SQLSTATE 09501.
Note that the error is not on the field that I am trying to drop the field proc on but one that comes earlier in the file. They have different exit routine names.
Is my code wrong? Can you drop a single fieldproc. Is there a better way to change the name of the exit routine?
Thank you for any help you can provide!