For DB2: What are some of the differences between OS/390 DB2 and other database servers that affect ADB?

For DB2: What are some of the differences between OS/390 DB2 and other database servers that affect ADB?

book

Article ID: KB0085386

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database -
Not Applicable -

Description

Resolution:
While it is difficult to compare database to database objectively, here are some areas that require custom-made changes:
„h Data Types
„h Date and Timestamp functions
„h Trigger statement syntax
„h Stored Procedures implementation
„h DDL statement syntax
„h Concepts of database instance
„h Physical implementation of DB objects
„h Varchar is popular in Oracle and Sybase whereas it is limited to hold free form text in DB2.
„h JDBC driver and ODBC driver
„h IBM OS is one of its kinds
„h Connectivity software is still proprietary. Installation and configuration are still OS platforms specific.

Issue/Introduction

For DB2: What are some of the differences between OS/390 DB2 and other database servers that affect ADB?