Advanced Trigger question for *insert *before to allow update of field value
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 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
How can I tell what fields from what files are being used in a rpgle program?
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
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
RPGLE
Multiple record locks in a single file.
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
RPGLE
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
RPGLE
RPGLE/SQL PROBLEM
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
RPGLE, SQL
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
RPGLE, SQL
Changing date fields to *longjul
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
RPGLE
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
RPGLE
RPGLE Record Lock Data
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
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
Locked Records
Is there an easy way to trap a Record Lock in RPGLE
Answer Question
| November 16, 2007 10:42 PM
AS/400, RPGLE
Is there an easy way to trap a Record Lock in RPGLE
Answer Question
| November 16, 2007 10:42 PM
AS/400, RPGLE
PAGE X OF X
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
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
RPGLE Procedure
In Procedure what is the use of Prototype? What does it denotes?
Answer Question
| September 13, 2011 2:39 PM
AS/400, RPGLE
In Procedure what is the use of Prototype? What does it denotes?
Answer Question
| September 13, 2011 2:39 PM
AS/400, RPGLE
INZSR and primary file
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
RPGLE
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
RPGLE
Problems with Expat in RPGLE
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
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
How do you convince Corporate Mindset that RPG is not a dinosaur
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
RPGLE
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
RPGLE
Detect is someone created, changed or deleted a document in the spool.
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
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
Connecting AS/400 to HP printer
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
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
Source Modified User
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 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
AS400
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 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
DDS Screen scraping
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
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
Converting from System 36 to iSeries V5R4
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’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
Staying on the Same Subfile Page When Auto Refreshing
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
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
RPG, RPGLE
Data Q
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
CLP, RPGLE
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
CLP, RPGLE
