By submitting my Email address I confirm that I have read and accepted the Terms of Use and Declaration of Consent.

By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.

You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.

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 ==================================

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy