I need to update a field in a record being written prior to it being written. I want to do it with a trigger because many programs write and update this file. I have tried several things and the closest I have gotten is to do a *before *insert where I can see the values [...]
Answer Question | August 4, 2010 7:02 PM
RPG, RPG ILE, RPG IV, RPGILE, RPGLE
I need to know which fields from which files are being used in the program. The compilation listing helps but doesn’t tell me which file.
Answer Question | December 25, 2007 4:18 PM
How can I attain multiple and simultaneous record locks in a single file without using commitment control? (…in RPGLE…)
Answer Question | December 22, 2007 7:29 PM
I am trying to join our sales analysis file, all fields, with our accounts receivable file using SQL. I can extract the information okay but when I issue the following fetch command: FETCH NEXT FROM SALESSORT INTO :SALESREC ,:CUSTREC it skips the null records. I have spent the last 6 hours researching this problem with [...]
Answer Question | February 24, 2010 5:30 PM
In RPG, how do you change a date format to *longjul. I haven’t found this format in the definition specs. I can change dates from *longjul within the C specs: *longjul Move LJdate NewDate but I have to call a program for the reverse.
Answer Question | July 17, 2008 6:57 PM
I have a program that get a Record Lock. I have captured the *status, however, I need the Program & User that initially read the record first.
Answer Question | February 5, 2008 8:04 PM
AS/400, Record lock, RPGLE
Is there an easy way to trap a Record Lock in RPGLE
Answer Question | November 16, 2007 10:42 PM
If for example, I have a 5 page report, does anyone know how to make the report read page 1 of 5, page 2 of 5, etc without first having to print the report to see how many pages there are? (I am using RPGLE)
Answer Question | May 19, 2008 7:06 PM
RPG, RPG ILE, RPGLE
In Procedure what is the use of Prototype? What does it denotes?
Answer Question | September 13, 2011 2:39 PM
Hi All, If we have a primary file and INZSR then where the control will go when the program will be called. What will be the exact processing. Advantages of primary file and INZSR subroutine. Thanks, Navin Negi
Answer Question | October 9, 2007 5:29 AM
Posted on behalf of MelissaG: I have an RPGLE program that receives an XML character string generated using CGIDEV2, and it is supposed to parse this XML in order to print those values in a spool file. My problem is that the RPGLE program that parses the XML sends an error message like ‘Parse error [...]
Answer Question | November 8, 2012 2:46 PM
AS/400, iSeries, RPGLE, XML
Given that the conservative nature of Corporate thinking does not allow you to try the new features of RPGLE (XML, internet enabling APIs, etc.) How do you convince them that RPGLE is not a legacy system dinosaur that can’t compete with JAVA (or .NET, etc.)
Answer Question | September 27, 2007 12:13 PM
Hello, I want to know what methodology I should use to detect if someone has created, changed or deleted a document from the spool so that I can perform an action. Thank you
Answer Question | July 11, 2007 9:31 AM
Printing, RPG, RPGLE
How to connect AS/400(Client Express which is ruuning in Windows Xp) with HP printer?
Answer Question | September 27, 2007 5:12 AM
Application development, AS/400, RPGLE
Hi All, If 4 users works on in same library in one source file, How could we know which user has modified a source? Thanks Reddy
Answer Question | December 11, 2007 5:25 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
hi, i want to know about the answers of these questions.. 1.) If any data has been deleted from the PF then how can we recover that and what are the limitiations for that. 2.) If in run time user want to choose the Access Path of a PF then how can it be possible.
Answer Question | December 20, 2007 2:50 PM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security
Hi. I don’t know if this is possible but I want to read an interactive DDS display while it’s running and then input data from an external file into the display like a screen scraper does?is there any kind of overlay on a active DDS panel I can use in my program? any help anyone?
Answer Question | October 24, 2007 11:13 AM
Application development, AS/400, RPG, RPGLE
I’ve been landed with a project to convert a System 36 system to iSeries 520 with OS V5.4. I have never worked on a System 36 and do not know where to start. Have looked for some documentation in Red Books but could’nt find anything. Does anyone have something I can use – something like [...]
Answer Question | April 30, 2012 4:25 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, RPG, RPGLE
I am doing an auto refresh. To do this, I created my display file using waitrcd(15), used maxdev(*file) for my workstn file and instead of using exfmt, I turned on the indicator which controls my INVITE, wrote to my subfile control record ,read from my display file and then turned my INVITE indicator off. I [...]
Answer Question | May 24, 2012 8:58 AM
I need to check whether there are any data found in a data Q. Is there any way to do that? Appreciate if you can provide sample executable codes for me to test it on. Thanks…
Answer Question | January 21, 2010 2:20 AM