DB2 versus Sybase

Published: 13 Jan 2003

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:

Stored procedures
CT library and DB-Library routines
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...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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.

Dig Deeper on IBM DB2 management

IBM assimilates the competition Porting a database from one vendors offering to another has always been difficult. To try and ease the pain vendors have product porting guides, third party tools companies have products that will ...

Examples of single and bulk XML shredding of XML documents In this guide, learn how to perform single and bulk XML shredding, plus find plenty of examples of documents being shredded.

IBM platform convergence is a step closer with DB2 9 Hot skills: Original relational database evolves for integration

Copying SQL Server database tables SQL Server expert Greg Low explains how to copy tables from one database into another.

SQL view that SELECTS on functions This user was having an issue with his SQL view on his iSeries that SELECTS on a few functions. Db2 Expert Kent Milligan explained what was going on.

Have a question for an expert?

Please add a title for your question

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

Meet all of our Data Management/Data Warehousing experts

View all Data Management/Data Warehousing questions and answers

SearchBusinessAnalytics

Please create a username to comment.

Salesforce acquisition of Tableau finally getting real

Tableau analytics platform upgrades driven by user needs

Tableau or Qlik: What separates the data visualization tools?

A complete guide to AWS re:Invent 2019

AWS SysOps certification exam guide outlines admin responsibility

AWS data lake and data warehouse options for the cloud

Box cloud content management helps simplify digital work

Acquia cloud CMS on AWS, Vista cash flow raise user expectations

Adobe Sign introduces updates targeting mobile device users

Oracle Autonomous Database shifts IT focus to strategic planning

Oracle Autonomous Database features free DBAs from routine tasks

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

SAP Data Warehouse Cloud may democratize data analytics

How to use Qualtrics employee experience tool to gather feedback

SAP partner program strives for long-term relationship with customers

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

Dig Deeper on IBM DB2 management

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.