Oracle to DB2 Conversion Guide: Compatibility Made Easy
IBM ? Information Management Software
Front cover
Oracle to DB2 Conversion Guide:
Compatibility Made Easy
Move Oracle to DB2 efficiently
and effectively
Learn about DB2 10.5 Oracle
Database compatibility features
Use Oracle PL/SQL skills
directly with DB2 10.5
Yvonne Chan
Nick Ivanov
Olaf Mueller
redbooks
International Technical Support Organization
Oracle to DB2 Conversion Guide: Compatibility
Made Easy
September 2013
SG24-7736-02
Note: Before using this information and the product it supports, read the information in
¡°Notices¡± on page ix.
Third Edition (September 2013)
This edition applies to IBM DB2 for Linux, UNIX, and Windows Version 10.5.
? Copyright International Business Machines Corporation 2009, 2013. All rights reserved.
Note to U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP
Schedule Contract with IBM Corp.
Contents
Notices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix
Trademarks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . x
Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xi
Authors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xii
Acknowledgements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
Now you can become a published author, too! . . . . . . . . . . . . . . . . . . . . . . . . xiv
Comments welcome. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiv
Stay connected to IBM Redbooks publications . . . . . . . . . . . . . . . . . . . . . . . . xv
Summary of changes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii
September 2013, Third Edition. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii
Chapter 1. Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
1.1 DB2 family of products . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
1.1.1 DB2 editions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
1.1.2 IBM DB2 10.5 Advanced Enterprise Edition features . . . . . . . . . . . . . 6
1.1.3 DB2 10 autonomic computing features . . . . . . . . . . . . . . . . . . . . . . . . 7
1.1.4 Introduction to PureData . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
1.2 DB2 Oracle database compatibility features overview . . . . . . . . . . . . . . . . 9
1.2.1 Concurrency control . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
1.2.2 Data types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
1.2.3 Implicit casting. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
1.2.4 SQL Standard . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
1.2.5 PL/SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
1.2.6 Built-in packages. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
1.2.7 Oracle specific JDBC extensions . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
1.2.8 SQL*Plus scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
1.2.9 Oracle Call Interface and Pro*C . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
1.3 DB2 educational resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
1.3.1 IBM professional certification . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
1.3.2 Other resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
1.3.3 DB2 10 videos and topics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
Chapter 2. Language compatibility features. . . . . . . . . . . . . . . . . . . . . . . . 21
2.1 DB2 compatibility features references. . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
2.1.1 SQL compatibility setup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
2.1.2 PL/SQL record and collection types . . . . . . . . . . . . . . . . . . . . . . . . . 27
2.1.3 Subtypes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45
? Copyright IBM Corp. 2009, 2013. All rights reserved.
iii
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- oracle connect string sample schema hr duszyk
- format number to string oracle
- oracle bq migration guide google cloud platform
- obiee training functions and variables
- convert function in oracle example
- dealing with json data in oracle dos and don ts indico
- data transformations with oracle data pump
- converting to transparent data encryption using active data oracle
- oracle to postgresql migration a hard way
- oraclerdb sqlreferencemanual volume1 oracle software downloads
Related searches
- fractions made easy for adults
- fractions made easy for kids
- dosage calculations made easy pdf
- fractions made easy cheat sheet
- statistics made easy to understand
- statistics made easy free
- nursing made easy pdf
- emergency nursing made easy pdf
- nursing made easy books
- biology made easy online
- biology made easy to understand
- cellular respiration made easy video