Tag: IBM DB2

IBM DB2 CLP Help System

Target Audience: DB2 Developers DB2 developers may feel exhausting time when working with CLP when accessing help documents. IBM DB2 enables CLP help reference (like MAN in Unix/Linux). When SQL query is processed, in case of any failure DB2 returns the error using SQL codes. In CLP interactive mode type the following command to get help reference …

Continue reading

Permanent link to this article: https://blog.openshell.in/2011/02/ibm-db2-clp-help-system/

Registering XML Schema to IBM DB2 pureXML

Target Audience: DBA, DB Developers What you should know: XML, XML Schema, Understanding of IBM DB2 pureXML DB2 is unrivaled in its ability to manage both relational and XML data, enabling strong runtime performance and high levels of development time and cost savings. By integrating XML data intact into a relational database structure, users can …

Continue reading

Permanent link to this article: https://blog.openshell.in/2010/12/registering-xml-schema-to-ibm-db2-purexml/

IBM DB2 Security Mechanisms

For every e-business solution, the company should give more sound for database security. The database security plan should define: who is allowed to the instance and/or database where and how a user’s password will be verified authority level that a user is granted commands that a user is allowed to execute data that a user …

Continue reading

Permanent link to this article: https://blog.openshell.in/2010/11/ibm-db2-security-mechanisms/