Q

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?

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

Dig deeper on IBM DB2 management

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSOA

SearchSQLServer

Close