>I have a table with a lot of encrypted stuff in a bunch of fields. Because it is binary I have to use nocptrans and name each field. Is there an easyer way? I only want it to effect the one table and there are many others open at the same time. Is there a command that will affect an entire table or cursor?
>
>Thanks in advance.

You would have to field by field, but the code is easy to generate:

alter table mytable alter field_name C(30) nocptrans