Yes, you can restore the previous version database backup to the new version binaries, and then upgrade the database.Functionally, this is the same as if you had upgraded the binaries on an existing server.Make sure that you follow the steps for upgr...
1) Create new dbfiles on raw devices as part of the same dbspace as the filesystem dbfileshttps://help.sap.com/viewer/a898e08b84f21015969fa437e89860c8/16.1.4.2/en-US/a611f30584f21015a9f283ac11bfa4ef.html2) Mark the filesystem dbfiles as READONLY (s...
The behaviour of ROWID has not changed between SAP Sybase IQ 15 and SAP IQ 16, but parallelism has increased in many ways.
You are likely now seeing the results of the speed improvements that were implemented by using parallel inserts in m...
This is an interesting issue, because the "original format" of 0x6861 is not a string "0x6861". It's a numeric value in hex. Getting a string representation of that value is not as trivial as it seems. The only way that I found was to take advantage ...