If I understand correctly, DB2 Universal Database support would be coming soon on the iSeries. What's the difference...
between the DB2 we use and DB2 UDB?
While SQL is supposed to be SQL, each database provider has their own "flavor" of commands, procedures and syntax rules. This is also true for IBM's DB2 Universal. DB2 Universal is divided into areas based on operating systems. The first "flavor" in the IBM world is DB2 Universal for AIX, Linux, HP-Unix (or HP-UX), Sun and Windows. The second is for the iSeries. The third is for z/OS and OS/390 and the last is for VSE & VM. Most of these differences surround file and table naming, field name lengths, data type differences and storage methods. While I haven't been through all of the changes surrounding the latest release yet, I think the majority of changes surround the database catalog. These changes allow developers to access database information such as schema, authority (privileges) and table information in a consistent manner across the product line.
MORE INFORMATION ON THIS TOPIC
Search400.com's targeted search engine: Get relevant information on DB2/400.
The Best Web Links: tips, tutorials and more.
Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.
Dig Deeper on DB2 UDB (universal databases)
Related Q&A from John Brandt
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.