How to find out which embedded SQL taking more time in RPGIV program
Hi All, I have 4 Embedded SQLs in my RPGILE program. Can any one tell me how to find out which SQL taking more time to execute ? are there any commands/methods to find out ?

Answer Question   |  March 31, 2009  12:42 PM
Embedded SQL, RPG IV, RPGILE

Embedded SQL in an RPG FREE program
I am developing an on-line screen program, where the user can select a view of the data from a list of “views”. This is my first crack at embedded SQL, Basically i issue the Prepare, declar the c1 scroll cursor, and then open c1, and then do the fetch. At this point I am loading [...]

Answer Question   |  March 26, 2009  5:17 PM
Embedded SQL, RPGILE, SQL

ISeries System Debug Manager
I have recently started using the ISeries System Debug Manager (I know, finally making the move to RPGLE). I have having trouble setting up the library list for it. We do not use the SYSVAL library lists normally for our users. We have a menu system that controls the users library list outside of the [...]

Answer Question   |  March 18, 2009  6:30 PM
AS/400 debugging, iSeries System Debug Manager, RPG, RPG debugging, RPGILE

RPGILE comparing values
i have a value say for example ASD12246. i need to check this value against afile which contains similar values lik this. i need to pick the value that has maximum matches with this number. Sa y for example if the File has ASD122 and ASD1224 i have to selct the code corresponding to ASD1224 [...]

Answer Question   |  March 4, 2009  6:13 AM
RPG, RPG ILE, RPGILE

Result fields in RPG/400 vs ILERPG
When coding in RPG400, the result of a calculation can be larger than the size of the result field, like this: D Fld1 s 2 0 Inz(20) D Fld2 s 2 0 Inz(10) D Fld3 s 2 0 Inz C Fld1 mult Fld2 Fld3 Fld3 will contain a value of 0 after the code is [...]

Answer Question   |  March 3, 2009  5:34 PM
ILERPG, RPG/400, RPGILE

MOVEA Equivalent command in free format RPG
Hi, I have to move each character in a string to an array. In RPG, I can very well use the command MOVEA for this purpose but I don’t know exact command in free format RPG. Can anyone help me on this regards?

Answer Question   |  March 17, 2009  7:25 AM
Free Format RPG, MOVEA, RPGILE

(AS/400 – RPG(ILE)) Date-Conversion
Date-Conversion ——————— I have a date in 7-digit format in ’1YYMMDD’ format. e.g 1071231 for representing 31st of December 2007.(where ’107′ represents 2007; 12 represents December & 31 represents 31st Day of the month). Now i need to convert this into ’31/12/2007′ (European format). Now my question is: Is there any direct function/method/facility available in [...]

Answer Question   |  February 11, 2009  11:22 AM
AS/400 development, Date conversion, RPG/400, RPGILE

Java on iSeries
We have a java program running on web sphere on linux. The java program is zipped as jar and deployed in an IFS directory and we use RPGILE to call the java program. Would it be possible to deploy war file instead of jar file in IFS directory and call the java program in the [...]

Answer Question   |  February 5, 2009  4:12 AM
IFS Directory, iSeries, iSeries development, JAR file, Java, Java ARchive, RPGILE, WAR file, Web ARchive, WebSphere

How to convert system date to other format using RPGILE
please advice how can convert system date to other format using rpgile.

Answer Question   |  March 17, 2009  11:20 AM
RPG, RPG/400, RPGILE, System date

ILE – module change
Hi, 1) How to find the list of programs using a module (other than find string or hawkeye) which needs to be modified? 2) If a module used by more than 15 program needs to be changed, what are the ways to update the impacted programs (apart from running UPDPGM command)?

Answer Question   |  January 28, 2009  9:39 AM
ILE, ILE for iSeries, ILE Program, ILE RPG, iSeries, RPGILE

as/400
Hi I have a flaftfile programe in rpgile. I need to write the header details (which is given by user in display screen ) to flat file. When user given company is 50 then that should to write header part like company=50 programe is sucessfully write the records to flat file addition to that i [...]

Answer Question   |  January 6, 2009  2:48 PM
RPG/400, RPGILE

System date and RPG/400
please advice me how to less 1 day from system date in rpgile. please send me the syntex.

Answer Question   |  December 24, 2008  8:54 AM
OS/400 System Date, RPG, RPG/400, RPGILE

How to manage allocated register problems in RPG?
Hello. I’m having troubles with many allocated registers for update, when 2 users try to modify the same data. How is the correct way to prevent this situation in ILERPG ? Thanks!

Answer Question   |  December 12, 2008  2:56 AM
Concurrency, ILE RPG, Mutex, Mutual exclusion, RPG, RPG ILE, RPGILE

How to get the row count of a PF with RPG ILE?
Hello, I’m looking for an example of how to get a row count of a PF from a ILE rpg program. Thanks everybody.

Answer Question   |  December 10, 2008  2:10 AM
AS/400 database, AS/400 development, PF/LF, Physical File, RPG, RPG ILE, RPGILE

Can the field exit key be programatically triggered?
The user doesn’t want to have to use the field exit key when entering numbers in a display file input field defined as 3 0. Can field exit be triggered programatically?

Answer Question   |  December 4, 2008  4:57 PM
RPGILE, RPGILE Field Exit Key, RPGILE prg

Reading a Microsoft Word file (.doc) in a ILE RPG program
I need to read the text of a Ms Word file without opening word, reading it in a ile rpg program, and put the text in a string. How can I do ? Thanks in advance

Answer Question   |  November 11, 2008  12:38 PM
ILE RPG, Microsoft Word, Microsoft Word 2003, MS Word 2003, RPG, RPG ILE, RPGILE, Word 2003

Can we recover deleted spool file?
hi all, please tell me is it possible to recover any deleted spool file. if yes then how………………??? thanks

Answer Question   |  December 13, 2011  7:40 AM
AS/400 backup, RPGILE, Spool files

Encrypting fields in the AS/400
Greetings, We are required to encrypt credit card fields in the AS/400 files. I am looking for something convenient to encrypt/decrypt field while in the RPG ILE program. Do we need to buy a software? Does As/400 has its own APIs? Please advise. Thanks Gary Liberman

Answer Question   |  October 19, 2009  2:19 AM
AS/400 security, Decryption, Encryption, Encryption Software, RPG, RPGILE

There is a way to order one SQL union file?
I have to conect 2 files, the current and the historic. Both has the same structure but the fields names are diferent. This is the complete command but i can not order to put the records in a subfile in the order that i need: C/EXEC SQL C+ DECLARE S1 CURSOR FOR SELECT IQUSER, IQFMOV, [...]

Answer Question   |  September 10, 2008  10:54 PM
RPG, RPGILE, SQL/400

How can I know the configuration of my AS/400 system?
hi, how can i know the configuration of my AS400 system, like virsion….etc thanks

Answer Question   |  September 5, 2008  6:12 AM
RPG, RPGILE