Hi, Do I need to modify the store procedures if sybase version is enhanced
A:
Depending on how you've written your stored procs they may need modified but I highly doubt it unless you're using esoteric things or querying system tables directly (they changed a bunch of sys* tables so if you are using them, you might get bad data).
Sybase generally keeps backward compatibility and I'm not aware of any major T-SQL deprecations in 15 (rowcnt() and some traceflags). ASE 15 has a greatly enhanced query processor but if it screws up your queries you can back it out to ASE 12.5 mode.
Anyway, as always you should test out your upgrade beforehand, but I doubt you'll see many issues.
Matt Rogish
2009-10-28 00:51:52
One I'm aware of is that in 12.5 you can create a nullable field from a non-nullable field in the SELECT list of a SELECT INTO using the ISNULL function. In 15 that's changed. Ref: http://groups.google.com/group/sybase.public.ase.upgrades+migration/browse_thread/thread/404dd9c2c397fff7#
martin clayton
2009-10-31 01:26:53