Not just another Java tutorial, this detailed guide takes you through everything you need to know about the AS/400's implementation of Java Book jacket.

& • Everything Java developers need to start building J2EE applications using WebSphere Tools for the WebSphere Application Server & & • Hands-on techniques and case studies: servlets, JSP, EJB, IBM VisualAge for Java, and more & & • Written by IBM insiders for IBM Press

Database access is the heart of iSeries web applications. There are two main techniques available: JDBC and Record Level Access (RLA). RLA is similar to using file I/O operations in RPG, while JDBC uses SQL. Which should you use for any given job? Whether you're creating web applications, client programs, or server-side code, you need to know how to effectively use JDBC or RLA to access your iSeries data. In this new, fast-paced 20-hour training course, Joe Pluta takes you step-by-step through many labs which allow you to compare and contrast both JDBC and RLA. Using these short, easy to understand labs, you'll create Java classes to read files sequentially and by key. You'll learn how to create complete CRUD classes (Create, Read, Update, Delete) using both RLA and JDBC. TOPICS COVERED IN THIS HANDS-ON COURSE INCLUDE: ?Sequential access with RLA and JDBC ?Creating and closing connections ?Working with records and fields from database files ?Using RLA and JDBC for keyed access ?Updating records using RLA and JDBC ?Error handling using the database access techniques ?Inserting new records with RLA and JDBC ?Creating a 3-tier client application to display, insert, update and delete data ?Using an Abstract Class to simplify Java development ?The JBUI classes to provide powerful user interfaces, far simpler than AWT or Swing NOTE: This course uses VisualAge for Java version 3.5 or 4.0, provided with the IBM WebSphere Development Tools for iSeries. Some experience with Java is assumed. When should you use JDBC? When should you use RLA? With this training you?ll always make the right choice to maximize Java Database performance and make your job easier.

Procedures, triggers, and user-defined functions (UDFs) are the key database software features for developing robust and distributed applications. IBM Universal DatabaseTM for i (IBM DB2® for i) supported these features for many years, and they were enhanced in V5R1, V5R2, and V5R3 of IBM® OS/400® and V5R4 of IBM i5/OSTM. This IBM Redbooks® publication includes several of the announced features for procedures, triggers, and UDFs in V5R1, V5R2, V5R3, and V5R4. This book includes suggestions, guidelines, and practical examples to help you effectively develop IBM DB2 for i procedures, triggers, and UDFs. The following topics are covered in this book: External stored procedures and triggers Java procedures (both Java Database Connectivity (JDBC) and Structured Query Language for Java (SQLJ)) External triggers External UDFs This publication also offers examples that were developed in several programming languages, including RPG, COBOL, C, Java, and Visual Basic, by using native and SQL data access interfaces. This book is part of the original IBM Redbooks publication, Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries, SG24-6503-02, that covered external procedures, triggers, and functions, and also SQL procedures, triggers, and functions. All of the information that relates to external routines was left in this publication. All of the information that relates to SQL routines was rewritten and updated. This information is in the new IBM Redbooks publication, SQL Procedures, Triggers, and Functions on IBM DB2 for i, SG24-8326. This book is intended for anyone who wants to develop IBM DB2 for i procedures, triggers, and UDFs. Before you read this book, you need to know about relational database technology and the application development environment on the IBM i server.