AS400 and SQL Tricks

Welcome to the Launch of www.AS400andSQLTricks.com Welcome and Happy New Year First of all a very warm Welcome and a prosperous Happy New Year t…

Load All Subfile in RPG AS400 Load-All Subfile You can read about the  Load-all subfile introduction . How to code a Load All subfile for Enquir…

Introduction to Subfile and its Types in AS400 Using Subfiles Subfiles allow us to handle multiple records of the same type on the display screen…

Fully free statements in RPG AS400 For writing Fully free RPG source statements we need to use special directive **FREE which indicates that the R…

Using QCMDEXC API in CL program QCMDEXC The Execute Command (QCMDEXC) API is an IBM-supplied program that executes/activates another single command.…

Parts of a CL source program Each CL source statement is a CL command and these CL source commands can be divided into basic parts as follows. A CL…

Process for creating a CL program or CL procedure Steps for creating CL programs There are the following steps to create a CL program. Create…

Use and Limitations of CL programs and procedures Use of CL programs and procedures This can be used for many purposes listed as follows: CL …

IBM i Objects Objects An object occupies storage on which operations are performed by OS. IBM i objects are the basic units on which commands perf…

CL programs and Procedures CL programs and Procedures We can write CL commands as a source statement in a CLP or CLLE source member and can create…

Introduction to CL (Control Language) Control Language (CL) Control Language (CL) allows AS400 programmers or administrators to write CL programs…