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.

This IBM® Redbooks® publication provides a technical overview of the features, functions, and enhancements available in IBM i 7.1, including all the Technology Refresh (TR) levels from TR1 to TR7. It provides a summary and brief explanation of the many capabilities and functions in the operating system. It also describes many of the licensed programs and application development tools that are associated with IBM i. The information provided in this book is useful for clients, IBM Business Partners, and IBM service professionals who are involved with planning, supporting, upgrading, and implementing IBM i 7.1 solutions.

This IBM® Redbooks® publication is focused on melding industry preferred practices with the unique needs of the IBM i community and providing a holistic view of modernization. This book covers key trends for application structure, user interface, data access, and the database. Modernization is a broad term when applied to applications. It is more than a single event. It is a sequence of actions. But even more, it is a process of rethinking how to approach the creation and maintenance of applications. There are tangible deliveries when it comes to modernization, the most notable being a modern user interface (UI), such as a web browser or being able to access applications from a mobile device. The UI, however, is only the beginning. There are many more aspects to modernization. Using modern tools and methodologies can significantly improve productivity and reduce long-term cost while positioning applications for the next decade. It is time to put the past away. Tools and methodologies have undergone significant transformation, improving functionality, usability, and productivity. This is true of the plethora of IBM tools and the wealth of tools available from many Independent Solution Providers (ISVs). This publication is the result of work that was done by IBM, industry experts, and by representatives from many of the ISV Tool Providers. Some of their tools are referenced in the book. In addition to reviewing technologies based on context, there is an explanation of why modernization is important and a description of the business benefits of investing in modernization. This critical information is key for line-of-business executives who want to understand the benefits of a modernization project. This book is appropriate for CIOs, architects, developers, and business leaders. Related information Making the Case for Modernization, IBM Systems Magazine

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.

InfoWorld is targeted to Senior IT professionals. Content is segmented into Channels and Topic Centers. InfoWorld also celebrates people, companies, and projects.

This IBM® Redbooks® publication explains how to configure and manage independent disk pool (IASP) functionality of IBM i 6.1. It is designed to help IBM technical professionals, business partners, and customers understand and implement independent disk pools in the IBM i 6.1. In addition, this publication provides the background information that is necessary to plan, implement, and customize this functionality to your particular environment. It provides guidance on running user applications with either application data or most application objects residing in an independent disk pool. Considering that you can also use independent disk pools in a cluster environment, this publication shows you the basic steps to make your independent disk pool switchable between two Power SystemsTM servers or a single server with multiple LPARs. Independent auxiliary storage pools have many business and technical advantages for Power Systems using IBM i. Not only are independent auxiliary storage pools (IASPs) easy to create and maintain, most applications can use them by simple work management changes. IASPs can provide immediate benefits to your enterprise.