Executing sp_encryption ‘remove catalogs’ fails to give error message  Encrypted column license display

Release Bulletin Adaptive Server® Enterprise Version 12.5.3a for Windows

Views and encrypted columns used with bcp

[CR #395749] If a view uses an encrypted column in the where clause, such as bcp out using -C fails:

create view v as select custid from customer where
ssn = '123 44 5678'

Workaround: Put the results of the view into an intermediate table using select into or insert-select. You may use bcp out with -C on the intermediate table.





Copyright © 2005. Sybase Inc. All rights reserved. Encrypted column license display

View this release bulletin as PDF