© Copyright IBM Corp. 2005. All rights reserved. 29
Chapter 4. Modernizing database definitions
Starting from V5R1 of OS/400, IBM introduces the ability to reverse engineer database
objects created via Data Definition Specification (DDS) to SQL Data Definition Language
(DDL) schema. There are several reasons behind this enhancement, some of which are:
Provide access to database enhancements that are only being made to SQL-created
databases.
Provide portability capabilities to PC-based data modeling tools that only support SQL.
Provide compatibility with other IBM DB2 Universal Database (UDB) products and
strategic application development platforms such as WebSphere Development Studio
Client.
Provide an easy way to move the data definition to SQL.
In this chapter we describe the methods and considerations in the process of modernization
of the database definition.
4
Note: There is not a unique solution that fulfills all the application development
environments. We introduce some guidelines to help you to modernize your applications to
use and exploit the features of SQL.
Get Modernizing IBM eServer iSeries Application Data Access - A Roadmap Cornerstone now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
