SAP Knowledge Base Article - Preview

3779082 - View column comments are removed after alter view recompile - SAP IQ

Symptom

When running ALTER VIEW VIEW_NAME RECOMPILE the View column comments are lost.

The issue is about preserving view comments when a REFERENCED view is altered.
ALL column comments disappear from ANY referencing view in doing so. 

Adding a column to a view that is referenced in a cascading manner by other views, with columns nicely commented, by adding that 1 column (that is not referenced elsewhere) to one view, columns in other views whose SELECT statement did not change lose their comment automatically. This is most likely due to an implicit cascading recompile. 


Read more...

Environment

  • SAP IQ 16.1 SP05.
  • SAP IQ 16.2 XX.

Product

SAP IQ all versions

Keywords

alter view recompile, view column comments, comments lost, column remarks, comment on column, preserve comments, metadata, view rebuild, recompile view, sap iq, sybase iq, view-level remark, dictionary comments, comment persistence, ddl behavior , 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.