- RPG
 - SQL
 - DB2
 - Java
 - Security
 - Internet
 - WebSphere
   


 -  Top 10 List
 -  New Titles
 -  Products on Sale
 -  Close-out Specials
 -  Current Email Special
 -  College Texts
 -  At Work Series
 -  Step-by-Step Guides
 -  Certification Guides
 


 -  Contact Us
 -  Become a Distributor
 -  Give a Gift Certificate
 -  Privacy Statement
 -  Email Us
 -  Information for
     Distributors and
     Wholesale Accts
 

Browse | New Products | Bestsellers | On Sale | Close Outs | Shipping/Returns | Help
Click to enlargeRPG File Processing
This course is also available on CD-ROM

Presenter: Manta Technologies
Availability: Online
SKU: 3576


Course Description:
This course describes how to process database and printer files in an RPG program. The course begins by discussing how files are described in an OS/400 environment. You will then see how to code the file specification for a database file.

The course then covers the various RPG op codes that are used to process a database file. You will see how to perform basic file operations, such as how to read records (both sequentially and randomly), update a record, delete a record, and add a record to a file. You will also see how to perform more advanced file operations, such as how to set the file position without reading a record, how to use a composite key, and how to release a locked record.

The course then describes the various ways for an RPG program to detect an error condition and the ways to obtain information as to the cause of the error. Next, you will see how to code an RPG program that uses commitment control. The course ends by covering the coding requirements of a program that produces printed output.

Click here for pricing and order information

After completing this course, you should be able to:
   • Describe the difference between external data and program described data
   • Code the file specification for both a database and printer file
   • Identify the F-spec keyword used to specify a given database or printer file attribute
   • Detect an error condition in an RPG program
   • Obtain information pertaining to a file error
   • Code an RPG program that performs the file processing of reading records
   • Code an RPG program that uses commitment control
   • Code the output specifications for a program-described printer file

Audience: This course is intended for programmers new to the RPG programming language. It can also be taken by RPG III programmers who want to learn RPG IV.

Prerequisites: This course assumes that you are familiar with computer programming concepts. In order to satisfy this prerequisite, you should have some programming experience with another programming language. The course also assumes that you have a working knowledge of basic OS/400 concepts and facilities. You can satisfy this prerequisite by successfully completing the courses in the following Manta series:
· Using an iSeries System

In addition, the course assumes that you have a basic knowledge of DB2 UDB. You can satisfy this prerequisite by successfully completing the following Manta course:
· Introduction to DB2 UDB

Finally, the course assumes that you have a basic understanding of RPG programming concepts. You can satisfy this prerequisite by successfully completing the first course in this series:
· RPG Fundamentals

Course Outline:
   Externally Described Data
   Coding File Specifications
   Basic Database File Processing
   Advanced Database File Processing
   Error Processing
   Using Commitment Control
   Producing Printed Output

Course Details:
Length:2 hours
Format: Online Learning
Publisher:Manta




RPG File Processing
This course is also available on CD-ROM


Presenter: Manta Technologies
Availability: Online
SKU: 3576


© 2001-2003 MC Press Online, LP. IBM® and AS/400® are registered trademarks of IBM. All other product names are trademarked or copyrighted by their respective holders.

MC Press Online Privacy Policy