This content was created to help customer when applying new Support Packages (SP) to determine if the current ASE version is compatible for upgrade. This sttared in SP100. The example here is based in SP102
Based in output from select @@sbssav and contents of asemanifest.mf file we can determine the compatibility for upgrade
Determine the current ASE version compatiblitiy for upgrade
Run this isql query:
1> select @@sbssav
Check if the @@sbssav number is in "sourcesps" property in the <install_image>/archives/asemanifest.mf file. If it is, proceed with the following instructions.
The '<install_image>' is the directory where you uncompressed the SP.
The contents of asemanifest.mf file (Windows platform)
sourcesps: 15.7.0.000 15.7.0.001 15.7.0.002 15.7.0.003
15.7.0.004 15.7.0.005 15.7.0.006 15.7.0.007 15.7.0.008
15.7.0.009 15.7.0.011 15.7.0.012 15.7.0.013 15.7.0.020
15.7.0.021 15.7.0.030 15.7.0.031 15.7.0.040 15.7.0.041
15.7.0.042 220.127.116.11 18.104.22.168
Related SAP Notes/KBAs