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 …
Tag: IBM DB2
Permanent link to this article: https://blog.openshell.in/2011/02/ibm-db2-clp-help-system/
Dec 27
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 …
Permanent link to this article: https://blog.openshell.in/2010/12/registering-xml-schema-to-ibm-db2-purexml/
Nov 27
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 …
Permanent link to this article: https://blog.openshell.in/2010/11/ibm-db2-security-mechanisms/