DATAAREA
I have a variable that contains the name of a data area How can I access the data area? Without using CL
Answer Question
| May 22, 2013 9:03 AM
AS 400, Data Area, RPGLE
I have a variable that contains the name of a data area How can I access the data area? Without using CL
Can I move a data structue(along with positional-values) into a Data area of same length.
Can I move a data structue(along with positional-values) into a Data area of same length. Can I move a data structue having positional-values exactly into the same positions of the data area. my code is as follows:- 0014.00 FCS86C00 CF E WORKSTN 0015.00 * 0016.00 I@DS001 DS 452 0017.00 I 1 256 @DTA 0018.00 I [...]
Answer Question
| May 22, 2013 7:10 AM
AS/400, RPG/400
Can I move a data structue(along with positional-values) into a Data area of same length. Can I move a data structue having positional-values exactly into the same positions of the data area. my code is as follows:- 0014.00 FCS86C00 CF E WORKSTN 0015.00 * 0016.00 I@DS001 DS 452 0017.00 I 1 256 @DTA 0018.00 I [...]
Windows Subfile
From a Subfile, can I make a “call” to a window subfile?
Answer Question
| May 21, 2013 12:45 PM
AS/400, RPGLE, Subfile
From a Subfile, can I make a “call” to a window subfile?
Securitiy Auditing in AS400
Dear all ! In our company we are using power 720 server for our application. Some of us in the Admin side we have the access to all the objects and can do any changes. But i as a super admin i just want to record all the activities of another person like changes in [...]
Answer Question
| May 20, 2013 12:08 PM
AS400 admin, Security auditing
Dear all ! In our company we are using power 720 server for our application. Some of us in the Admin side we have the access to all the objects and can do any changes. But i as a super admin i just want to record all the activities of another person like changes in [...]
More than 50 files in RPG?
How can i declare more than 50 files in RPG/400 program?
Answer Question
| May 20, 2013 11:54 AM
AS 400, RPG, RPG Code
How can i declare more than 50 files in RPG/400 program?
crtdevprt
I have created a printer device using the command crtdevprt for a HP Laserjet CP2025n. I am running V5R1M0. The device is created and documents will print but only in 10 cpi. I isend it 12 cpi and dtill will only 10cpi even though the attributes of the spool file show it at 12 cpi. [...]
Answer Question
| May 18, 2013 12:33 AM
CPI, CRTDEVPRT, HP CP2025
I have created a printer device using the command crtdevprt for a HP Laserjet CP2025n. I am running V5R1M0. The device is created and documents will print but only in 10 cpi. I isend it 12 cpi and dtill will only 10cpi even though the attributes of the spool file show it at 12 cpi. [...]
Creation and dump of a user space iSeries
Hi all, I’m trying to recreate an old user space with the next code: QUSCRTUS(qname, "LSTOBJS ", 64000, "", "*EXCLUDE ", "Text decription ", "*YES ", &zero, "*USER " , 16 , optimum ) When I dump the old one there is a -extended data- section but that section does not exist in the dump [...]
Answer Question
| May 17, 2013 5:03 PM
AS/400, iSeries
Hi all, I’m trying to recreate an old user space with the next code: QUSCRTUS(qname, "LSTOBJS ", 64000, "", "*EXCLUDE ", "Text decription ", "*YES ", &zero, "*USER " , 16 , optimum ) When I dump the old one there is a -extended data- section but that section does not exist in the dump [...]
Join files using OPNQRYF
I’m not much familiar with complex OPNQRYF statements. I need to select records from a file say FileA which has a field AccNo. I need to select those accounts whose country code =’002′. Country code comes from another file say FileB. FileB has account number as key. I know this is simple, but I am [...]
Answer Question
| May 17, 2013 12:16 PM
AS/400, OPNQRYF
I’m not much familiar with complex OPNQRYF statements. I need to select records from a file say FileA which has a field AccNo. I need to select those accounts whose country code =’002′. Country code comes from another file say FileB. FileB has account number as key. I know this is simple, but I am [...]
Transferring data between iseries without using DDM/FTP
Is there any better way of transferring data between iSeries without using DDM/FTP?
Answer Question
| May 16, 2013 1:04 PM
DDM, iSeries
Is there any better way of transferring data between iSeries without using DDM/FTP?
Convert time stamp to dd/mm/yy
How can I convert a timestamp field(declared with type ‘Z’ in database) to dd/mm/yy format in RPG?
Answer Question
| May 16, 2013 11:39 AM
AS/400, AS/400 date format, RPG
How can I convert a timestamp field(declared with type ‘Z’ in database) to dd/mm/yy format in RPG?
Dynamic operator on WHERE statement
I have a file that has 2-fields that will be used to select records from file B. File A, field 1 = date_a & field 2 = Operator. I want to select records from File B and based on the value within the operator ( EQ, LT, LE, GT, GE) and the date_a. Ex: If [...]
Answer Question
| May 16, 2013 9:54 PM
iSeries, SQLRPGLE
I have a file that has 2-fields that will be used to select records from file B. File A, field 1 = date_a & field 2 = Operator. I want to select records from File B and based on the value within the operator ( EQ, LT, LE, GT, GE) and the date_a. Ex: If [...]
WRKOBJPDM license?
I have a new AS/400 V7R1 and each time I use WRKOBJPDM, it gives a CPF9E72 message in *SYSOPR (Usage limit exceded) in product 5770WDS feature 5103! What’s wrong?
Answer Question
| May 16, 2013 9:14 PM
AS/400, WRKOBJPDM
I have a new AS/400 V7R1 and each time I use WRKOBJPDM, it gives a CPF9E72 message in *SYSOPR (Usage limit exceded) in product 5770WDS feature 5103! What’s wrong?
Sessions disconnecting from AS/400
I have 10 users accessing a remote AS/400 using Windows PCs via Client Access. We have been connecting without problems since 2006. Last 2 months we are having many disconnections. PCs are setup OK Time out is set up as unlimited Broad band is stable Cisco firewall is OK Cat 5 cabling is OK At [...]
Answer Question
| May 15, 2013 4:17 PM
AS/400, AS/400 Client Access, AS/400 sessions
I have 10 users accessing a remote AS/400 using Windows PCs via Client Access. We have been connecting without problems since 2006. Last 2 months we are having many disconnections. PCs are setup OK Time out is set up as unlimited Broad band is stable Cisco firewall is OK Cat 5 cabling is OK At [...]
3812 printer fonts
Is there a way to change the font thru the override print file command. The printer emulation is 3812, I am looking for a “softer” font. The font that is being used looks too much like a typewriter.
Answer Question
| May 15, 2013 3:00 PM
OS/400, OS/400 printers
Is there a way to change the font thru the override print file command. The printer emulation is 3812, I am looking for a “softer” font. The font that is being used looks too much like a typewriter.
COBOL/400 – Time stamp
Hi, could anyone please advice me how to use time stamp in COBOL/400?
Answer Question
| May 15, 2013 4:58 AM
AS/400, CLLE, COBOL
Hi, could anyone please advice me how to use time stamp in COBOL/400?
How to run JSP with Tomcat on OS/400 V6R1
I’m replacing an iSeries by an I5 V6r1 but it appears that I cannot use Tomcat any longer to run JSP applications. What should I do?
Answer Question
| May 14, 2013 4:03 PM
iSeries, OS/400, Tomcat
I’m replacing an iSeries by an I5 V6r1 but it appears that I cannot use Tomcat any longer to run JSP applications. What should I do?
How to send mails to group when error receives in QSYSOPR
We have 5 admin users, So We need to get an email when system will reach threshold or system jobtable nearing capacity. For that how to monitor the messages, and when it reaches the error point How to send mails to a group.
Answer Question
| May 14, 2013 3:50 PM
AS/400 administration, AS/400 Monitoring, iSeries administration
We have 5 admin users, So We need to get an email when system will reach threshold or system jobtable nearing capacity. For that how to monitor the messages, and when it reaches the error point How to send mails to a group.
Trigger
Guys, we got a problem here…our file is associated with Insert and delete trigger. So will an SQL delete query execution trigger the job attached?
Answer Question
| May 14, 2013 4:24 AM
AS/400, CLLE, DB2, RPGLE
Guys, we got a problem here…our file is associated with Insert and delete trigger. So will an SQL delete query execution trigger the job attached?
Trigger removed
How to know if some one had removed the trigger from the file? We have a situation like this so how to know who did that? Shall we get the data from journaling?
Answer Question
| May 14, 2013 4:03 AM
AS/400, DB2, RPGLE
How to know if some one had removed the trigger from the file? We have a situation like this so how to know who did that? Shall we get the data from journaling?





