The iSeries Blog

Dec 12 2007   3:55PM GMT

DB2 DDS and SQL on the System i

Mark Fontecchio Mark Fontecchio Profile: Mark Fontecchio

This week I spoke with the CEO of Resolution Software, a company that wants to make it easier for Data Description Specifications (DDS)-based System i databases to talk to SQL-based applications.

Resolution has been around for almost two decades, but it was just two years ago that it decided to delve into the System i. Starting in January, the company will start offering its Xcase software to users, an application that will allow DDS-based System i databases like DB2 to more easily communicate with SQL programs.

“We think that the System i market is a market where there is a lot to achieve,” Resolution CEO Elie Myal said. “Many shops today have not yet done the move to SQL, although they’re talking a lot about that. It is the time to do it, not 10 years ago, but now, when there is so much talk about modernization and so much talk about SQL.”

Resolution’s work is based largely on a 2005 IBM Redbook, “Modernizing IBM eServer iSeries Application Data Access,” which details a complex process on how to reverse engineer a DDS-based DB2 database and move toward SQL. IBM recommended the process because it said that SQL Data Definition Language (DDL) had surpassed DDS as the industry-standard way to define relational database management system (RDMS) databases like DB2.

Since that process is so long, Resolution has Xcase to basically automate it for you. At the same time, it doesn’t alter your original DDS-based databases, and thus doesn’t throw everything out of whack.

“The System i is a wonderful database machine because the database is built right into the operating system,” Muyal said. “It works much more smoothly and in a powerful way than when trying to combine hardware, OS and database technology from different vendors. But the database solutions are scarce.”

In addition to the software product, which you’ll be able to buy in January, Resolution is offering a modernization service on the System i right now.

 Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: