Symptom
Currently, SAP IQ does not support the change of the name / the owner for the stored procedure by using sp_iqrename.
Therefore, the following procedure has failed with the following error.
#1. Change the procedure name
(dba)> sp_iqrename "dba.sp_tableA", "sp_tableA2", "procedure"
Could not execute statement.
RAISERROR executed: This feature is not yet supported
SQLCODE=-17965, ODBC 3 State="HY000"
#2. Change the owner of the procedure
(dba)> sp_iqrename "dba.sp_tableA", "UserA.sp_tableA", "procedure"
Could not execute statement.
RAISERROR executed: This feature is not yet supported
SQLCODE=-17965, ODBC 3 State="HY000"
Read more...
Environment
- SAP IQ 16.x
Product
Keywords
rename , sp , recreate , sp_rename , CR#825266 , CR825266 , 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.