3336007 - sp_help viewname may show numericn or decimaln as column data types - SAP ASE

sp_help viewname might show numericn and/or decimaln as column data types for the view if base tables referred by the view have column with nullable numeric and/or decimal data types.
This will be seen if a view contains a derived table expression including a UNION clause and precision or scale of nullable numeric or decimal columns are different between SELECT lists in the UNION clause.

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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

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