Ask the Expert

DB2 versus Sybase

My company is considering a change from Sybase to DB2 in order to save money on licenses. Is there any Sybase functionality that I would lose? The main functions of Sybase ASE we use are:
  1. Stored procedures
  2. CT library and DB-Library routines
  3. Replication server
Does DB2 have similar capabilities?

    Requires Free Membership to View

Yes, DB2 does have similar capabilities. But, the manner in which DB2 supports these functions differs from Sybase's support - so you will not be able to, for example, take your Sybase Transact-SQL stored procedures and implement them in DB2; you will have to re-write those stored procedures using DB2's syntax.

This was first published in January 2003

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: