SAP Knowledge Base Article - Preview

2438890 - Update operation attempted on non-updatable remote query on ENCRYPT/DECRYPT - SAP IQ

Symptom

  • When running an UPDATE or DELETE command with the ENCRYPT or DELETE clause, an error is returned.

  • For example, running the following command:

create table test(a varchar(352));
insert into test values (encrypt('test2','key','aes256'));
update test set a = (encrypt('test3','key','aes256')) where 1=1

  • Returns the following error message:

Update operation attempted on non-updatable remote query
SQLCODE=-728, ODBC 3 State="42000"
Line 1, column 1
update test set a = (encrypt('test3','key','aes256')) where 1=1


Read more...

Environment

SAP IQ 16.0

Product

SAP Sybase IQ 15.4

Keywords

KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.