Skip to Content

Sybase 16 SP03 Upgrade from Sybase 15.7

Hi Team,

We are planning to upgrade our database to Sybase 16 SP03 from Sybase 15.7.

Could you please let me know

Whether it is required any code level changes (stored procedure, view, data type etc.)?

For Example :- Code syntax which was working in 15.7 may not support in 16 SP03.

Is there any documents which will give some details related to what are changes got implemented as part 16 SP03.

Is there any performance impact ?.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 02 at 07:38 AM

    Hi Avinash,

    Could you please confirm whether you are referring to below document ?

    https://help.sap.com/doc/5f8c23557c0a4831bb191f0378647d41/16.0.3.3/en-US/SAP_ASE_Whats_New_en.pdf

    As per this document, there is no existing command which got depreciated as part of 16 SP03. Could you please confirm on this ?

    Add comment
    10|10000 characters needed characters exceeded

    • Correct.

      I searched your link for terms "depracate" and "obsolete" in the document and got only one hit and thar is related to MDA tables.

      HTH

      Avinash

  • Apr 30 at 03:19 PM

    Hi Uday

    I assume that this ASE is not for SAP business suite.

    SAP/Sybase has documents titled "What's New" for each release. You can find one for ASE 16 SP03.

    There will be a release bulletin for your too which willl be OS platform specific.

    And there is installation guide which is also OS platform specific.

    SAP/Sybase have done execellent job of T-SQL backward compatbility between two successive ASE versions (e.g. 15.x and 16.x).

    If some feature/procedure/command is depracated they are clearly mentioned.

    You may have to check your code for if it uses hints, forced plans and specific compatibility settings if any.

    I would foucus on two areas

    - most frquently SQL/procs (e.g. a few thousand times a day)

    - long running SQL / procs (e.g. run times in 10s/100s of minutes)

    Also if replication is involved (which most SAP/Sybase shops have) then deal with extra caution. Again all this is well documented in the sets of manuals for each ASE 16.x SPnn PLmm

    HTH

    Avinash

    Add comment
    10|10000 characters needed characters exceeded

  • May 07 at 11:44 AM

    Hello Uday,

    What kind of application do you run on your ASE 15.7 database today?

    This is the ASE 16.0 SP03 release note for SAP NetWeaver applications: https://launchpad.support.sap.com/#/notes/2505861

    There is a Feature Overview Webinar planned for May 16. This may help you as well.

    Best regards, Matthias

    Add comment
    10|10000 characters needed characters exceeded