AS400 – RRN of PF
FILE1 is a PF. I want to read 100th Record directly. I want to perform this operation without using LF, OPNQRY, Native I/O. want to achieve this using RRN value of File. How to code this in RPGLE Program
Answer Question
| January 20, 2009 11:43 AM
OPNQRY, PF, RPGLE, RPGLE Program, RRN
FILE1 is a PF. I want to read 100th Record directly. I want to perform this operation without using LF, OPNQRY, Native I/O. want to achieve this using RRN value of File. How to code this in RPGLE Program
Can embedded SQL in a SQLRPGLE program be used as a stored procedure?
I am successfully using (external) stored procedures with many RPGLE programs. (Some of these are SQLRPGLE programs because they return a result set.) All of this works fine. But if I try to replace some of the RPG I/O in a RPGLE program with embedded SQL, creating a SQLRPGLE program, and run it as a [...]
Answer Question
| January 15, 2009 10:09 PM
Embedded SQL, iSeries development, iSeries RPG programming, RPG, RPGLE, SQL, SQLRPGLE, Stored Procedures
I am successfully using (external) stored procedures with many RPGLE programs. (Some of these are SQLRPGLE programs because they return a result set.) All of this works fine. But if I try to replace some of the RPG I/O in a RPGLE program with embedded SQL, creating a SQLRPGLE program, and run it as a [...]
MSGW
Thank You for your reply But I need the process how I can write a program in order to get all the process to be done that is, giving opt7 & reply ‘G’ for a MSGW job. Or can I have any other process to do the same that means sending a reply to a [...]
Answer Question
| January 12, 2009 4:43 AM
AS/400 administration, CL, Message Waiting, MSGW, RPGLE
Thank You for your reply But I need the process how I can write a program in order to get all the process to be done that is, giving opt7 & reply ‘G’ for a MSGW job. Or can I have any other process to do the same that means sending a reply to a [...]
rpgle
I have a file value which is of length 15 with 2 decimal places.This value has to be assigned to an output file field whose length is 13 (eg:10.2).Can this assigned in RPGLE.The field from input file is a numeric field
Answer Question
| January 8, 2009 3:20 PM
RPG ILE, RPG Output File Field, RPGLE
I have a file value which is of length 15 with 2 decimal places.This value has to be assigned to an output file field whose length is 13 (eg:10.2).Can this assigned in RPGLE.The field from input file is a numeric field
Debugging service program
Hi anybody tell me how to dubug a service program in ILERPG…thanks
Answer Question
| January 7, 2009 5:07 PM
RPG ILE, RPGLE
Hi anybody tell me how to dubug a service program in ILERPG…thanks
rpg subdur
I’m doing a subdur to calc the number of days between mfg date and trans date. When mfg is 2008 and trans is 2009 (12/31/2008 01/02/2009) I get a result of -364 like it subdur is ignoring the year. Any idea how to fix?
Answer Question
| January 5, 2009 1:24 PM
RPGLE, SUBDUR
I’m doing a subdur to calc the number of days between mfg date and trans date. When mfg is 2008 and trans is 2009 (12/31/2008 01/02/2009) I get a result of -364 like it subdur is ignoring the year. Any idea how to fix?
Please explain RPG “Bind by Copy” and “Bind by Reference”?
Can you explain the terms with example BIND BY COPY BIND BY REFERENCE
Answer Question
| January 5, 2009 7:40 AM
AS/400 development, Bind by Copy, Bind by Reference, RPG, RPGLE
Can you explain the terms with example BIND BY COPY BIND BY REFERENCE
AS/400 development
Service Program contains 10 procedures. 5 Procdures in that service programs are defined with export keyword.5 Procdures in that service programs are defined with import keyword. i am calling the procedures from other ile program. How many procedures are available for me? How to hide the procedures in a service programs for other ile programs?
Answer Question
| January 5, 2009 5:59 AM
AS/400 service program, RPG, RPG/400, RPGLE
Service Program contains 10 procedures. 5 Procdures in that service programs are defined with export keyword.5 Procdures in that service programs are defined with import keyword. i am calling the procedures from other ile program. How many procedures are available for me? How to hide the procedures in a service programs for other ile programs?
MSGW in WRKACTJOB
How to end a job in MSGW how we can give in a program all the proces to give OPT-7 in front of a job which is in MSGW & giving ‘G’ to end that in RPGLE /CLLE progrm that too in a scheduled time
Answer Question
| May 3, 2012 5:46 AM
CL, CLLE, Message Waiting status, MSGW, RPG, RPGLE, WRKACTJOB in AS400
How to end a job in MSGW how we can give in a program all the proces to give OPT-7 in front of a job which is in MSGW & giving ‘G’ to end that in RPGLE /CLLE progrm that too in a scheduled time
CL AND RPGLE
can i call an rpgle prog from a cl by passing parameters from cl. Also how do i debug these two sources which are of different types.I am not able to use strisdb to link the modules.
Answer Question
| January 4, 2009 1:13 PM
Calling an RPGLE program from CL, CL, CL Parameters, RPG, RPGLE, RPGLE Program
can i call an rpgle prog from a cl by passing parameters from cl. Also how do i debug these two sources which are of different types.I am not able to use strisdb to link the modules.
AS400 Print Screen button on upper lefthand corner not working with new VISTA PC
Hi, A user reported a problem where she used to be able to print whatever’s on her screen from within any AS400 application by pressing the print screen icon on the upper lefthand corner of her screen (under the File button). Since she got a new pc with VISTA on it, it only prints a [...]
Answer Question
| December 23, 2008 6:10 PM
AS/400 Print Screen, RPGLE
Hi, A user reported a problem where she used to be able to print whatever’s on her screen from within any AS400 application by pressing the print screen icon on the upper lefthand corner of her screen (under the File button). Since she got a new pc with VISTA on it, it only prints a [...]
AS400 – RPGLE Module
Hi, I have created module mod1. and i have merged the mod1 with services programs sp1, sp2, sp3. how do i find what are all the service programs attached with that particular module?
Answer Question
| January 7, 2009 8:21 AM
AS/400 development, RPG, RPG Modules, RPG/400, RPGLE
Hi, I have created module mod1. and i have merged the mod1 with services programs sp1, sp2, sp3. how do i find what are all the service programs attached with that particular module?
Sorting data in RPGLE
How to sort data in rpgle program countrywise in program coding only?
Answer Question
| December 2, 2008 4:46 PM
RPG, RPG arrays, RPGLE, RPGLE Program
How to sort data in rpgle program countrywise in program coding only?
AS/400 file specification
Why sometimes we need to put “K” for file specification?eg: FSSDATA IF E K DISK
Answer Question
| November 17, 2008 6:18 AM
AS/400 file specification, FSSDATA parameter, RPG, RPGLE
Why sometimes we need to put “K” for file specification?eg: FSSDATA IF E K DISK
where does the file get created in AS/400 system when we fire embedded INSERT query in an RPGLE program
we are inserting deptid in departments table using the following INSERT statement: INSERT INTO departments (department_id, department_name ) VALUES (30, ‘:Purchasing’); so where does the departments file get created in As/400 system? when we are doing a runqry on departments file, it is giving the error that the file is not present in the library [...]
Answer Question
| November 12, 2008 2:14 PM
AS/400, INSERT statement, RPGLE, RPGLE Program, SQLRPGLE
we are inserting deptid in departments table using the following INSERT statement: INSERT INTO departments (department_id, department_name ) VALUES (30, ‘:Purchasing’); so where does the departments file get created in As/400 system? when we are doing a runqry on departments file, it is giving the error that the file is not present in the library [...]
How many files can be read in an RPGLE program?
How many files can be read in an RPGLE program?
Answer Question
| November 11, 2008 7:48 AM
RPGLE, RPGLEPGM
How many files can be read in an RPGLE program?
Print from RPGLE without closing program or PRTF
I just setup an Epson TM-H6000III POS printer on the AS400. This is used to print a receipt and then change to the check validation to print on the back side of checks. I got everything working except the receipt prints a ” – -1″ everytime I close the PRTF to release the print. Does [...]
Answer Question
| November 7, 2008 1:23 PM
AS/400 printing, PRTF, RPGLE
I just setup an Epson TM-H6000III POS printer on the AS400. This is used to print a receipt and then change to the check validation to print on the back side of checks. I got everything working except the receipt prints a ” – -1″ everytime I close the PRTF to release the print. Does [...]
Receiving an XML file to RPG
HI, I need to receive xml files ( of fixed format ) to my rpgle progrm ( not free format RPG ) and do some calculations. Can i do this without purchasing any tools ( free tools can be used). Please let me know if anyone has done something similar Regards, Kiron
Answer Question
| December 8, 2008 7:35 AM
AS/400 development, AS/400 import/export, RPG, RPG/400, RPGLE, XML
HI, I need to receive xml files ( of fixed format ) to my rpgle progrm ( not free format RPG ) and do some calculations. Can i do this without purchasing any tools ( free tools can be used). Please let me know if anyone has done something similar Regards, Kiron
Modules in RPGLE
Hi, Can anyone tell me what is module in RPGLE and how is it created? alos tell me how this can be called from rpgle?
Answer Question
| November 3, 2008 11:49 AM
RPG, RPG Modules, RPG/400, RPGLE
Hi, Can anyone tell me what is module in RPGLE and how is it created? alos tell me how this can be called from rpgle?
How to tell if a specific record comes before or after another specific record?
In RPG ILE, I have an externally described file. I am chaining out to the logical file with a key & find the first record. Now, I want to know if the second record I’m looking for is before or after the first record in the file.
Answer Question
| September 16, 2010 8:13 PM
RPG ILE, RPGLE
In RPG ILE, I have an externally described file. I am chaining out to the logical file with a key & find the first record. Now, I want to know if the second record I’m looking for is before or after the first record in the file.





