Author Description

Dive into the details of DB2 UDB for AS/400 advanced functions. This IBM Redbook aims to equip programmers, analysts, and database designers with all the skills and tools necessary to take advantage of the powerful features of the DB2 UDB for AS/400 relational database system. It provides suggestions, guidelines, and practical examples about when and how to effectively use DB2 UDB for AS/400. This redbook contains information that you may not find anywhere else, including programming techniques for the following functions: * Referential integrity and check constraints * Triggers * DRDA over SNA, DRDA over TCP/IP, and Two-Phase Commit * DB2 Connect * External stored procedures * SQL stored procedures (SQL Persistent Stored Modules language) * Java stored procedures (both JDBC and SQLJ) * DB2 Call Level Interface Programming (DB2 CLI) This redbook also offers examples developed in several programming languages (RPG, COBOL, C, Java, and Visual Basic), using native and SQL data access interfaces. Some knowledge of the relational database technology and application development environment on the AS/400 platform is required.