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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
hi, how can i know the configuration of my AS400 system, like virsion….etc thanks
Answer Question | September 5, 2008 6:12 AM