In this post, we are going to see a slightly advanced and very useful concept related to Stored Procedures…. returning Output from Stored procedures. This can be achieved in two ways: 1) Through Output parameters 2) Through Result Sets Returning data from Stored procedures through output parameters is fairly a simple concept and the below … More Stored Procedures which return Results!

In this post, we look at a very useful concept – programming message subfiles! Message subfiles are special subfiles designed to hold messages. Message subfiles allow users to view second level help text associated with a message without any programming effort. Message subfiles make it possible to set up a consistent group of information, warning … More Message Subfiles

When a SELECT statement retrieves multiple rows – called a Result Set, a cursor must be used for processing the individual records. The cursor can be thought of as a Buffer in memory that holds the result table and it also has a cursor that points to the current record being processed. Working with a … More SQL on the iSeries – Part IV (Selecting Multiple Rows in Embedded SQL)

The examples we considered in the previous part of this post were all Static SQL statements. The clauses and conditions which needed to be used were fixed at the time of the program creation. However situations arise wherein the filtration and grouping clauses can be determined only at run time. In such cases, the SQL … More SQL on the iSeries – Part III (Dynamic SQL)

We are going to start with a simple example of how to write an Embedded SQL RPG program in Free format with the aim of understanding the syntax. The code below selects the name of the employee (EMPNAME) from EMPPF  database file whose empno is 10 and displays it on the screen. The variable NAME … More SQL on the iSeries – Part II (Embedded SQL)

SQL , without doubt, is one of the mandatory skills a modern day programmer should possess. The majority of database files on an iSeries server may be created using DDS (Data Description specification) but SQL is the future. As most of you might be knowing, STRSQL is the command to start the interactive SQL session. … More SQL on the iSeries – Part I (Intro)

Here we are at the last and final part of this post on Modular Programming! In this part, we will be looking covering the below two topics: API’s Data Areas API API’s are Commands or Programs built into the the Operating system that allow you to access lower level machine functions or system data not … More Everything you need to know about Modular RPG Programming! – Part IV

In this part, we will look at the below topics: CALLB (Call a Bound Module) Op code. Using Prototypes effectively. Using Import and Export. CALLB Op code The CALLB opcode can be considered as an older version of CALLP. It is not as versatile and does not support all features that CALLP does. The limitations … More Everything you need to know about Modular RPG Programming! – Part III

In the previous post, the surface of modular programming was scratched. In this post, we will move on to the next set of concepts that need to be considered. Dynamic and Static Binding. CALL Operation. Procedures and Subprocedures. Dynamic and Static Binding Dynamic Binding – Dynamic binding is simply the method by which a program, … More Everything you need to know about Modular RPG Programming! – Part II

The main things to understand when trying to learn Modular Programming is: -> How RPG Programs communicate with one another by passing data values as Parameter Arguments. -> How to code Procedures, Procedure Interfaces and Prototypes to code your own Functions. -> How to call API’s from within Programs -> How to share data among … More Everything you need to know about Modular RPG Programming!