The Fortress Platform :)

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)