AS/400 Links Partner with Rochester Institute Contact Us
Training Catalog Free Downloads Privacy / Usage
 
 
Take what you need.
 
FREE AS/400, iSeries, and System i / iSeries Downloads
HOME >> FREE AS/400, iSeries, and System i / iSeries Downloads
 
If you're not a subscriber, click here to confirm your subscription now
and get free access to AS/400, iSeries, and System i resources.
FREE RPG Cheat Sheets
 
This section includes your FREE RPG Cheat Sheets, PLUS everything on this page
(With exception of the training courses) is yours FREE!


RPG "Cheat Sheet" #1 - Create an ILE RPG Module
A module is an OS/400 object (type *MODULE). It is the starting point for creating program (*PGM) and service program (*SRVPGM) objects. A module is created using the CRTRPGMOD command. The module is not "called" like a program. Instead, other modules call procedures defined in the module or the... FREE! Download Now
      learn more


RPG "Cheat Sheet" #2 - Create a Service Program
A service program is an OS/400 object (type *SRVPGM). Service programs are created by binding one or more modules (object type *MODULE) together. A service program usually contains one or more procedure or data exports. The exported... FREE! Download Now
      learn more


RPG "Cheat Sheet" #3 - Binding Directories
A binding directory is an OS/400 object (type *BNDDIR). A binding directory contains a list of one or more module (*MODULE) or service program (*SRVPGM) objects that are used when creating other modules, service programs or programs... FREE! Download Now
      learn more


RPG - Code Procedure Prototypes with the Procedure
NEW This article describes a technique to code the prototype and the interface in the same source member. By using the compiler /DEFINE and /UNDEFINE directives, you can use the right code at the right time in the compile step... FREE!
      learn more


Use Program Cloning To Lessen Your Workload
What if you had a program that could write programs? Imagine what you could do. Suppose you need to change one thing or count items in a whole bunch of files. Or maybe you want to delete specific records in a number of files. Rather than writing a lot of separate programs to do these tasks, wouldn't it be great if you could just write one program and have another program make copies of it that were modified to work on... FREE!
      learn more


SQL - Using SQL with the iSeries
NEW This lab presents an overview of the SQL features available in the AS/400 Operations Navigator, V5R1. In the lab, you create an SQL collection and tables, work with key and check constraints and add a referential constraint... FREE!
      learn more


SQL - Visual Tools for SQL
NEW This is from a seminar conducted in October 2001. It shows some of the new SQL features available in AS/400 Operations Navigator, how to run SQL scripts (statements), how to change query attributes for optimization tests, how to create different types of views, and an overview of the new Visual Explain optimization tool... FREE!
      learn more


SQL - Using Aliases
NEW If you have multiple member database files, you will want to know how to create aliases for members in the files. Using aliases, you can easily access any file member using SQL statements... FREE!
      learn more


Just click a button and watch
an iSeries file open in Excel.

(Training Course)
Click a button to run an iSeries program or query and watch the results open in Excel! Now you can quickly and easily modernize your iSeries reports with Microsoft Excel with the iSeries. It comes with an illustrated manual and a CD containing all the exercise source code, a complete Excel workbook with buttons to run queries and a sample user request workbook... $495 Watch a brief video.
      learn more


HTTP Server - Create HTML files with Client Access
NEW What's the fastest, easiest way to create web pages from your iSeries / AS/400 data? Probably the Data Transfer to HTML option in the IBM Client Access Data Transfer program... FREE!
      learn more


HTTP Server - Overview of Certificates and Encryption
NEW This article describes basic concepts of how encryption is provided between a server and client sessions, and the role of digital certificates in identifying servers and clients. Read this before configuring your iSeries or AS/400 Digital Certificate Manager... FREE!
      learn more


HTTP Server - Working with Digital Certificate Manager
NEW To start an encrypted session between your iSeries or AS/400 server and a client (browser or Client Access Express), you need to install and configure a digital certificate. If you only need encrypted sessions for intranet and extranet applications, you can create your own server certificate using the AS/400 Digital Certificate Manager... FREE!
      learn more


Operations Navigator - Application Administration
NEW The Application Administration feature of AS/400 Operations Navigator helps you control users' access to your system. Using Application Administration, you can allow or prohibit users' ability to use features of AS/400 Operations Navigator, Client Access Express and other programs on your system... FREE!
      learn more


Operations Navigator - Backup Utility
NEW The Operations Navigator Backup Utility is an easy-to-use GUI backup program. You can use the backup utility to quickly select libraries and Integrated File System (IFS) folders for backup. The utility helps you create and manage tape sets and includes a scheduling function... FREE!
      learn more


Gain Powerful iSeries Modernization Skills
(Training Course)
One of the quickest and most effective ways to modernize your iSeries applications is to create web and windows front-ends built using the Microsoft .NET framework. Microsoft .NET for RPG Programmers shows you how to develop applications using the .NET Framework to extend the capabilities of your System i. IBM provides the tools to... $495
Watch a brief video.

      learn more


Operations Navigator - iSeries NetServer
NEW This lab shows you how to use the AS/400 Operations Navigator to effectively configure and work with NetServer. You also learn how to share folders and map network drives to your PC for easy access to iSeries folders... FREE!
      learn more


iSeries Server - AS/400 Service Table
NEW The AS/400 and iSeries Service Table is used to control TCP/IP ports. If you need to know what port is used by a TCP/IP service, you can look into the Service Table. You may also need to work with the Service Table if you ever have TCP/IP port conflicts... FREE!
      learn more


iSeries Server - IP Packet Filtering
NEW This article shows how to configure the IP Packet Filter and describes an example of using the filter to log a journal entry each time the FTP server is accessed... FREE!
      learn more


iSeries Server - Understanding CCSID
NEW The iSeries and AS/400 servers encode all data stored in database files using a Coded Character Set Identifier (CCSID). This article describes the concepts of CCSID and the OS/400 System Values used to work with it... FREE!
      learn more


Use Microsoft Word on your iSeries
(Training Course)
Create better looking, easier to read and understand RPG report printouts with graphics, fonts, underlines, and bolding using Microsoft Word with the iSeries! Generate personalized mail-merge mailings with company logo directly from your database... $395 Watch a brief video.
      learn more


iSeries Server - Send AS/400 Objects via E-mail
NEW If you work with more than one AS/400 system, you sometimes need to copy an object from one system to another. If you don't have compatible save/restore media, you can use the technique described in this article... FREE!
      learn more


iSeries Server - Improve DNS with LOCALHOST
NEW If you use the DNS server on your iSeries or AS/400 system, be sure to read this tip about improving performance of DNS lookups... FREE!
      learn more


Subprocedure Tips and Techniques
Incorporating the use of subprocedures into your applications should be on everybody's "to do" list these days. You don't need to drop everything and simply rewrite your applications to take advantage of subprocedures and many of the other benefits that the Integrated Language Environment (ILE) has to offer. But, when you are writing new applications or performing major updates to existing... FREE!
      learn more


iSeries / i5 Web Security Step-by-Step
Rochester Initiative is pleased to announce a no-charge online resource that will help you understand how to configure and work with iSeries / i5 Web Security. This fully illustrated, step-by-step resource is FREE! with your no-charge sign-up to the Lab400.com web site.
      learn more


An Easy First Step – the Remote System Explorer
It's easier than you think to get started with a new generation of workstation tools for developing and maintaining RPG and COBOL programs on the iSeries. The IBM WebSphere Development Studio Client for iSeries Version 5.1.2 (Development Studio Client) is based on Eclipse and contains everything you need to develop Java and Web applications, as well as powerful workstation tools for RPG and COBOL. The Remote System Explorer is... FREE!
      learn more


Plug into the power of RPG with SQL
(Training Course)
Instead of relying solely on limited RPG file operations, you'll add the power and convenience of SQL to your RPG programming. Developed by programmers for programmers, this hands-on SQL training shows you plenty of short-cuts, gives you tips and real-world advice on how to develop and test statements. SQL for RPG Programmers shows you how to... $595 Watch a brief video.
      learn more


Can You Dig It? Work-Flow Oriented Menus
Show What Needs to Happen Now

In my previous job at a local telephone company, we received calls requesting a "locate," a description of where utility cables and pipes were buried. Business owners call in to receive this information to avoid causing damage when digging. When these requests were received, the information was relayed via fax to the phone company's main building, where the requests were picked up and entered into the AS/400... FREE!
      learn more


Service with a Smile
With Web Services, you can define a virtual 'sign on the wall' in cyberspace. With Web Services, you can achieve the goal of application integration as provided by the iSeries Developer Roadmap. With Web Services, you can define the electronic services your business provides, instead of how (or where) they are implemented... FREE!
      learn more


Run WebFacing remotely to the iSeries
An iSeries WebFacing application consists of servlets, JavaServer Pages and other artifacts that are generated by converting display file DDS source members. The WebFacing application must be deployed to an application server that provides the run-time environment for the servlets and JSPs. In some environments, it may be advantageous to deploy the application server on a server other than the iSeries... FREE!
      learn more


Software Design, Part I
Define your goals before you start coding

This is the first article in a four-part series on software design. In this article, I introduce you to the basic software engineering principles you need to build applications that work right the first time. Even professional developers recognize the difficulty of achieving that claim but... FREE!
      learn more


11 Advanced RPG Programming Subjects,
each w/one or more labs

(Training Course)
Brad Stone's RPG Skills Accelerator covers 11 advanced RPG programming subjects, each with one or more labs. Hands-on stuff! This dynamic 25-hour training course comes with an easy-to-follow manual, and a CD with all the training exercise source code. You'll learn new RPG skills at your own pace by writing and testing code. Use what you've learned to... $495 Watch a brief video.
      learn more


RPG CODE COACH
ILE RPG Structure: subprocedures,
modules and service programs

In this series of articles, I will show you many examples of how to code subprocedures and other supporting code required to create the types of robust modules that can be created using RPG. I won't spend a lot of time teaching you syntax rules; you have the RPG reference manuals for that. Instead, I'll tell you why I use certain techniques and prefer one or another technique over others... FREE!
      learn more


Work with WebSphere Development Studio Client for iSeries (WDSCi) and Remote Systems Explorer (RSE)
How to work with the Remote System Explorer perspective in WebSphere Development Studio Client for iSeries (version 5.0 or 5.1, Standard or Advanced editions). The RSE is a replacement for PDM/SEU. This zip file also includes a save file image of example library APILIB.RSE. Complete instructions for restoring the sample library to your iSeries are included in the zip file... FREE!
      learn more


Web Design Basics
Although the Internet has been around for more than a few years now, many applications still haven't been ported to the Web. Maybe you haven't had the need, time, or resources, to move applications over yet. But eventually, you may find yourself needing to learn about this new way to provide applications to your users and customers... FREE!
      learn more


How to get started with IBM's WebSphere Studio
How to install, configure and apply software patches to IBM's WebSphere Development Studio Client for iSeries (version 5.0 or 5.1, Standard or Advanced editions)... FREE!
      learn more


Advanced Job Scheduler
One of IBM's Best Kept Secrets

For years, the IBM Advanced Job Scheduler (AJS) has been biding its time one of IBM's best kept secrets. It will soon be obvious why this clandestine tool is no longer a secret. With V5R3, AJS has burst forth with new innovations designed to take it out of the shadows and into the light... FREE!
      learn more


Write practical ILE RPG subprocedures
you'll use every day.

(Training Course)
Your RPG code can now be simpler to write, easier to maintain, readily reused in new applications, and truly modular. This new training developed by Craig Pelkie makes using power ILE RPG subprocedures easy. Subprocedures for RPG Programmers gives you hands-on labs that show you how to write practical ILE RPG subprocedures that you'll use every day. Upon completion you will have built your own Functions Generator. $495
      learn more


The Hidden Crevices of OS/400
Although they may seem like subtle issues, the areas of OS/400 discussed in this article could be giving unscrupulous users easy access to data or the ability to perform functions they shouldn't be allowed to perform. Read on to determine if you need to apply some sound OS/400 Security Principles to these areas on your system... FREE!
      learn more


Get to the Web Fast with IBM eServer i5!
Last year, I told many IBM eServer iSeries clients that 2003 was an exciting year for WebSphere on the iSeries. In hindsight, that wasn't true – 2004 is even more exciting! WebSphere's value just keeps getting better and better. And with the recent IBM eServer i5 announcements, the next generation of iSeries servers and the industry's first server based on IBM POWER5 technology, the opportunities to reap this value are... FREE!
      learn more


Follow the Path to iSeries Modernization
I'm a simple person by nature. I don't use big words, or live in a big house. I've got no need for an expensive sports car or fancy clothes. And instead of a meal at a fancy steak house with expensive wine, I'd rather cook up a bag of frozen chicken wings... FREE!
      learn more


Spice up your iSeries Applications with ABLE
Working with the Agent Building and Learning Environment (ABLE) has given me a chance to learn about software agents and a wide range of Java topics... FREE!
      learn more


iSeries Navigator for Programmers?
(Training Course)
iSeries Navigator is now one of the most powerful tools available to iSeries Programmers. With a mastery of iSeries Navigator, you can shorten your learning curve for acquiring new skills, like working with the Integrated File System and SQL. Developed by Paul Tuohy, specifically for iSeries programmers... $495 Watch a brief video.
      learn more


IBM Toolbox for Java
The right tools to have in your toolbox for Java development

(Training Course)
So you want to enter the world of Java and the Web, but you're not sure where to start? The IBM Toolbox for Java is a set of Java classes you can use to access iSeries resources such as jobs, printers, message queues, and data queues... FREE!
      learn more


Sizing up a downsizing task
Imagine you have an ERP database with many different companies loaded: AR files, GL files and inventory files. They coexist nicely because your software was designed to be company number driven. Then one day, your CEO announces - "We're closing company #3 because of poor performance and market pressures"... FREE!
      learn more


Easy RPG Library List Control
You can manipulate the library list by calling a CL program, which then calls the xxxLIBLE command to add or remove libraries from the library list. A cleaner, more portable, and easier way is to use an ILE service program that includes all the library list functions you need. Encapsulating library list processes into easy to use functions also makes them available in any... FREE!
      learn more


A Server for All Seasons
Unless you have been living in a cave for the past month or so, you have probably noticed one or more of the road shows, Webcasts, or articles on the new iSeries i5. What do the i5 announcements mean to those of us who dwell on the server consolidation, networking, and general infrastructure side? (As opposed to those folks who would rather write RPG than eat.) It means... FREE!
      learn more


Prescriptions for Ailing Software
Maybe we should be called Software Doctors because we have to diagnose the errors in a program and then fix them. To help you diagnose software problems, in this article, I take you through some time-saving techniques. I'll start with the search option in Program Development Manager (PDM) and end with a utility... FREE!
      learn more


Take your RPG skills to the web!
(Training Course)
This dynamic self-paced iSeries training from Brad Stone allows you to leverage your existing RPG skills to bring your iSeries applications to the web. By using the core RPG skill you already have, you will avoid resource intensive solutions with a long learning curve. $495
      learn more


Take the High Road to the Web
IBM's iSeries Developer Roadmap was designed to give customers and partners a path to modernize and extend their existing green-screen applications to the Web. The Roadmap has now taken on a life of its own with new versions coming out and multiple uses. In this article, I help you understand the Roadmap and the technologies IBM is promoting. I also explain Roadmap options, and the steps you need to... FREE!
      learn more


Create Table Like, But Different
As iSeries programmers explore the use of embedded SQL in their applications, the natural tendency is to try to understand new capabilities in terms of familiar techniques. The CREATE TABLE LIKE statement is often equated to the CREATE DUPLICATE OBJECT (CRTDUPOBJ) command. Unfortunately, that comparison can lead to... FREE!
      learn more


WebFacing without WebSphere
It's no secret that IBM wants iSeries shops to use WebSphere. A lot of IBM's development, technical and marketing efforts are devoted to making WebSphere Application Server a useful and useable product on the iSeries. What seems to be missing, though, is recognition of what current iSeries and AS/400 developers have to work with. Many of these shops have servers that are quite adequate for RPG workloads, but don't... FREE!
      learn more


Making Sense of the Misunderstood Concepts
of OS/400 Security

Over the years, I have received numerous questions about OS/400 security. The questions most frequently fall into one of the following categories. Of course, many would say that every aspect of OS/400 security is totally confusing! But this article tries to clarify, what seem to be, some of the most... FREE!
      learn more


Automate & Enhance Query/400,
save time & processor resources

(Training Course)
With this course you can now run a group of queries with one program selection and only enter the date range once for all the queries in that group. You will see which date range was last used, the last time the group of queries ran, who ran the group, and when it ran. This increases query accuracy and... $695 Watch a brief video.
      learn more


Get a New Window on Your iSeries with a Portal
A portal is a secure, single point of access on the Web where you can access information, applications, business processes, and people. A portal can be personalized to a particular type of user in a business or virtual organization to give them the tools and resources they need in an easy to access environment. Figure 1 illustrates an IBM hosted WebSphere Portal demo available at... FREE!
      learn more


Creating HTML based email on the iSeries
One of the easiest ways to distribute information is via email. The various types of content that can be incorporated into email makes it an especially powerful tool for communication and collaboration. Email is also being used to deliver automated messages when a given event occurs. It is now common practice for the shipment of an order to generate an email with a tracking number and a link to the carrier's tracking page... FREE!
      learn more


Visually create web database apps with WDSC
Want to learn to create iSeries e-business applications quickly and affordably? We'll look at using a new approach to building iSeries Java web applications: Visual Development Method© (VDM). Using IBM's WebSphere Development Studio Client toolset (WDSC), we'll see how to build a simple web application that... FREE!
      learn more


Develop dynamic RPG web apps with IBM's free toolkit!
(Training Course)
With e-RPG Powertools – Stone on CGIDEV2 RPG programmers quickly learn how to develop web applications using IBM's CGIDEV2 development tools with RPG. CGIDEV2, which is provided free of charge from IBM, is a powerful toolkit. It allows RPG programmers to easily create web applications with RPG. This course provides tools that make it a snap to write, test, debug, and maintain ILE-RPG IV CGI programs. $495
      learn more


Get your iSeries data on the web in under a day!
(Training Course)
WebFacing Now! (WAS-Express or Tomcat Edition) takes you step-by-step through the installation and configuration process. It covers converting DDS screens into WebFacing code in the WebSphere Test Environment or Tomcat Test Environment on your PC. You'll then see how to configure, start and test on your iSeries and bring up your new web apps served from your iSeries in your PC browser. $495
      learn more


e-RPG Supercharged: Free and Easy
Web Enablement with CGIDEV2

Every month, it seems I receive hundreds of emails from companies and programmers that are at a crossroads in their Internet development plan. After deciding that moving some or all of their business to the Web would benefit the company, they now are facing a decision as to which technology to use. Many times, this means choosing between WebSphere, Net.Data or e-RPG (RPG CGI programming), or... FREE!
      learn more


The Art of the Flexible Cursor
Can fetching an SQL cursor offer the same functionality and flexibility as proprietary RPG operation codes? The answer, I am happy to say, is a resounding yes! In this article, I show you how... FREE!
      learn more


Remote Journaling and its Benefits to iSeries High Availability
Unique and powerful data recovery capabilities are available for shops that use the remote journaling function of the OS/400 operating system. An extension of the standard journaling functions of OS/400, remote journaling essentially duplicates journal entries created on one iSeries machine and transmits them to another iSeries connected via high speed line... FREE!
      learn more


Understanding ILE
Practically all AS/400 and iSeries programmers are aware of the Integrated Language Environment (ILE) series of programming languages, including RPG, COBOL, C and C++. However, many shops not only continue to use programs developed with earlier versions of RPG, such as RPG III and RPG/400, but also continue development with those obsolete versions... FREE!
      learn more


Debugging variable length ILE RPG fields
In ILE RPG, you can define a variable-length character field by adding the keyword VARYING to the D-spec definition for the field. When you define a variable length field, you also specify its maximum length. Variable length fields are generally useful when you need to use the field in string operations, particularly when you concatenate several strings... FREE!
      learn more


Database access is the heart of iSeries applications.
(Training Course)
This fast-paced 20-hour training course, by 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. $495
      learn more


Faster, Better Queries with Encoded Vector Indexes
With EVIs, you create a new set of logical files on your computer. Each new logical file is a 1-key access path. The 1-key value ensures that the size of the file on the system is small or compact and reduces the likelihood that the annoying "building access path" statement will pop up... FREE!
      learn more


Passing Parameters with ILE RPG Subprocedures
You can pass a parameter to a subprocedure in three ways: • By reference • By read-only reference (constant) • By value FREE!
      learn more


Using the VisualAge for Java WebSphere Test Environment
VisualAge for Java includes an optional component called the WebSphere Test Environment (WTE). Using the WTE, you can test servlets and JavaServer Pages (JSP) at your workstation, without needing to export your code to WebSphere Application Server. While running the servlet or JSP, you can step through your code... FREE!
      learn more


Using the WebSphere JSP Tag Library
If you are just getting started with Java, WebSphere, or JavaServer Pages, you should start with these JSP tags. Using the JSP tags is probably the least difficult way to get dynamic web pages up and running with WebSphere.... FREE!
      learn more


Using JDBC with iSeries WebSphere Applications
Seminar handout that describes how to use JDBC on the iSeries 400. The document describes the two JDBC drivers provided with the iSeries 400, when and how to use each driver, how to configure WebSphere Application Server for connection pooling. Includes code samples to show how to prototype a JDBC application in VisualAge for Java, then convert the prototype to a servlet... FREE!
      learn more


How to Get AS/400 Net.Data Up and Running
Document that describes how to configure IBM HTTP Server for AS/400 (OS/400 V4R3 and higher) to provide an environment for AS/400 Net.Data. Use this as a "first step" if you do not already have IBM HTTP Server for AS/400 configured... FREE!
      learn more


Working with Net.Data Table Functions
Document that shows and describes how to work with Net.Data table functions. Use the Net.Data table functions to improve the appearance of HTML tables generated by Net.Data. Also shows how to create a clickable link from a table item to a detail Web page... FREE!
      learn more


Using Stored Procedures with Net.Data
As an alternative to coding SQL statements directly in your Net.Data macros, you can call AS/400 stored procedures. Using stored procedures, you can access secured AS/400 resources, modularize your Net.Data applications, and use traditional AS/400 programming resources effectively with your Web applications. Includes sample Net.Data macro and RPG code... FREE!
      learn more


Using "subfiles" with Net.Data
One of the most frequently asked questions about Net.Data is, how do I generate a multiple page listing, so that I can control the number of items displayed per Web page? This article shows how to use Net.Data functions to specify the number of items displayed per page, how to navigate forward or backward in the display, and a sample navigation scheme to help your users. Includes Net.Data macro code... FREE!
      learn more


How to update files using Net.Data
Although it is very easy to write Net.Data macros to for database inserts and inquiries, updating through Net.Data requires some additional code. This article shows an example of how to retrieve a record from a database file, present the record for update, then perform an update of the record. Includes Net.Data macro code... FREE!
      learn more


HTML for DDS Programmers
If you want to create usable and useful Web based forms to take the place of your DDS Display File applications, you will need to know how to work with HTML form elements. This document describes the commonly used HTML form elements you will use to create Web based data entry forms... FREE!
      learn more


JavaScript for DDS Programmers
If you want to create Web forms that edit data fields at the browser, you will need to use a scripting language with your HTML. This document and sample code shows how to attach field-level edits to browser fields and display error messages to the user... FREE!
      learn more


Six Cool Things you can do with IBM HTTP Server for AS/400
Alright, so the title's lame, but here is a description of six configuration options you can use with IBM HTTP Server for AS/400 that will add to its functionality... FREE!
      learn more


WRKHTTP
Command to edit, print, and backup the AS/400 HTTP server configuration file... FREE!
      learn more


FTPEXIT
Exit Point program for FTP and FTP Server Logon. Can be used to secure FTP Server, FTP Client, REXEC Server, TFTP Server, FTP Server Logon and REXEC Server Logon. All accept/reject options are set externally to the program... FREE!
      learn more


If you're not a subscriber, click here to confirm your subscription now
and get free access to AS/400, iSeries, and System i resources.