Symptom
- IQ can be stored in the column of encrypted data.
- Encryption and decryption of data uses AES_ENCRYPT functions and AES_DECRYPT function.
- However, data extraction facility of IQ cannot be converted numeric types of AES_DECRYPT:
Data exception - data type conversion is not possible.
-- (dfo_Root.cxx 2192)
SQLCODE=-1001006, ODBC 3 State="HY000"
Read more...
Environment
- SAP IQ 15.x
- SAP IQ 16.0
Product
SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4
Keywords
TEMP_EXTRACT_NAME1, aes_encrypt, aes_decrypt, int, CR753327, 753327 , KBA , BC-SYB-IQ , Sybase IQ , Problem
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.