AS400 and SQL Tricks

DSPF keyword-ALARM ALARM is a record level keyword to tell IBM i operating system to activate the audible alarm when the record format defined in th…

Compilation error RNF5199 Hi, we are trying to create one display file that is created sucessfully and then the RPGLE program using DSPF and trying …

External stored procedure calling RPGLE program with Input and Output parameter In previous articles we've already mentioned about calling RPG …

External stored procedure calling RPGLE program with Input parameter Here, we will call an external program with Input parameter using External sto…

External stored procedure calling RPGLE program with no parameter An external stored procedure is a procedure that is written in a host language a…

TRFCTL Command in OPM CL Programs Transfer control command for CL programming TRFCTL COMMAND is used to call the specified program, pass the con…

CALL and CALLPRC command in CL CALL and CALLPRC Introduction CALL Command is used to call another program whereas CALLPRC command calls a bound…

Reading PF in CL program CL program to read a database file and show its field’s value on the console and help out every time before reading a new re…

Reading Record from multiple PF in CL If we want to declare more than one file in a CL program then we have to use the Open Identifier(OPNID) by sp…

Reading flat file in CL program Creating flat file The “CRTPF” command is used to create a flat file (physical file without any source but with a…

Read PF randomly by a record number in CL program Overriding the database file We can use OVRDBF command to override the database file in a CL pro…