Subfile processing is an integral part of many data entry and display applications. The Subfile Programming with RPG IV workshop teaches you to design and program subfiles using the latest RPG IV techniques, including procedures, free-format RPG IV, indicator-free code, and embedded SQL. This class begins with easy-to-understand explanations of subfile concepts then goes on to offer advanced techniques
Recommended Schedule: 3 day lab workshop
Who Should Attend This class is appropriate for existing RPG IV programmers who need to build interactive applications that use subfiles.
Prerequisites
To successfully complete this course, students should have completed the following courses, or have equivalent knowledge/experience:
IBM i Concepts and Programming Tools
Introduction to RPG IV Programming
RPG IV and the Integrated Language Environment
Interactive Programming with RPG IV
Previous knowledge of another computer language may be helpful.
What You Will Accomplish At the end of the course, students will be able to:
Design and create subfiles for list-oriented RPG 5250-based interactive applications
Understand, enter and edit Data Description Specifications (DDS) for subfiles
Use Screen Design Aid or WebSphere Development Studio Client to design a subfile
Load subfile records and display subfiles
Manipulate database files using subfiles
Build database maintenance applications centered around subfiles
Display multiple subfiles on a screen
Use subfiles to select database records
Use a window subfile for selection lists
Manage cursor placement within a subfile
Build a subfile using embedded SQL
Use subprocedures with subfiles
Improve your application user interface with pop-up windows
What You Will Receive Each student receives:
Custom printed handout, containing class notes
Completion certificate
Course Outline
The class covers these topics:
Introduction to Subfiles
Subfile DDS requirements
Designing subfiles with SDA and RDP
Using RPG procedures
Using an indicator data structure
RPG specification requirements for subfiles
Subfile size and subfile page
Loading the entire subfile at once
Loading the subfile a page at a time
Loading very large subfiles
Paging with + or More...
Using SQL to load subfiles
Managing empty subfiles
Using drop and fold
Positioning the subfile
Selecting records
Using subfiles for data entry
Reading changed subfile records
Programming with multiple subfiles
Using hidden fields
Positioning the cursor
Window-based subfiles
Lab Exercises
Loading the entire subfile at once
Loading a page at a time
Positioning the subfile
Updating subfile records, using READC
Programming with multiple subfiles
Using embedded SQL
Limited Time!
Special pricing for the
Ontario area. Book a 5-day onsite class for as little as USD $900/day. Get a price quote today. Ask for offer CA900.
