DDS or SQL
DDS, SQL, Ddl, COBOL
We have an existing COBOL application using files defined in DDS format. We are considering to move from DDS to DDL for future development. What is the best strategy to take this approach?
Question
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
That is one broad topic! :-)
If you haven't already done so, you may want to review Modernizing IBM eServer iSeries Application Data Access - A Roadmap Cornerstone, a redbook IBM put out a few years ago discussing the movement from DDS and traditional data management to SQL.
One of the nice things is that, with some considerations, SQL can work with files defined using DDS and traditional data management (as used by COBOL) can work with tables defined using SQL DDL. So a staged migration is certainly doable.
Hope this helps,
Bruce Vining
http://www.brucevining.com/
Browse more Questions and Answers on AS/400 and Development.
Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.
