SAP Knowledge Base Article - Preview

3080876 - Cannot change the name / the owner for the stored procedure with sp_iqrename

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

SAP IQ 16.0 ; SAP IQ 16.1

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.