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.

Google Online Preview   Download