SAP Knowledge Base Article - Preview

2679216 - Where is the data source for @@version? - SAP ASE

Symptom

  • When we connect to an ASE instance from within DBArtisan, it displays the version string beside the instance name.
  • For all ASE 15.7  and created 16.0 instances, it shows the version string that mathes the @@version output.
  • For ASE 16.0 server which has been upgraded (using sqlupgrade) from v.15.7 to v.16.0, it shows "Adaptive Server Enterprise/15.7.0/EBF 21202 SMP SP50 ...." while @@version shows "Adaptive Server Enterprise/16.0SP03 PL04/EBF 27869 SMP/P/pwerpc/AIX 7.1.3.15 ....".
  • We are trying to determine why the upgraded instance value in DBArtisan doesn't match the @@version value when it's an upgraded instance.
  • Where is the data in @@version sourced from in SAP ASE 16.0?


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 16.0

Keywords

hard-coded, hardcoded, boot , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.