2022

External stored procedure that writes to a data queue

External stored procedure that writes to a data queue What is Data Queue? Data queue is the type of system object that one can create to which a …

ALTNAME (Alternative Record Name) keyword for display files

ALTNAME keyword in DSPF ALTNAME keyword is used in display files to specify alternative name for a record format. The alternative name can be used …

ALTHELP (Alternative Help Key) keyword for display files

ALTHELP keyword in DSPF ALTHELP keyword is used in display files to assign a command attention (CA) keys as an alternative help key. It is a file l…

ALIAS (Alternative Name) keyword for display files

ALIAS keyword in DSPF ALIAS keyword is used in display file to specify an alternative name for a field. It is a field level keyword. Syntax of AL…

ALARM (Audible Alarm) keyword for display files

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

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

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

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

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

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 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

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

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

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

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…

OVRDBF and DLTOVR CL commands

OVRDBF and DLTOVR commands in CL Introduction to override commands We can override either a database file or a DSPF or PRTF file. command used to…

Using outfiles in CL

Using outfiles in CL What is Outfile in CL? Outfile is used to retain the output information in a file. DSPPGM command does not have outfile s…
© AS400 and SQL Tricks. All rights reserved. Developed by Jago Desain