JDBC and Record Level Access
with IBM AS/400 Toolbox for Java

Course Code: JRLA Price: £ 435

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 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. The course is an ideal follow-on to Practical Java Programming for WebSphere. 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.