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?
FTP a file from AS400 to VOS Stratus
Need to transfer an AS400 physical file to VOS Stratus operating system and store file in a library on the remote system (Stratus0. I would like to seutp a CL program on the AS400 server to initiate this file transer to the VOS Stratus operating system. What would be the commands to use for my [...]
Answer Question
| May 13, 2013 11:00 PM
AS/400, FTP, VOS Stratus
Need to transfer an AS400 physical file to VOS Stratus operating system and store file in a library on the remote system (Stratus0. I would like to seutp a CL program on the AS400 server to initiate this file transer to the VOS Stratus operating system. What would be the commands to use for my [...]
AS/400 batch commands – make changes to user profiles
We are supporting OS/400 V7 R 1 and we need to know the commands to make the following type of change. (We are new to AS/400). We need to know how to change the OWNER field to *GRPPRF for all user profiles that belong to the group profile of (DEVUSERS). There are over 1,000 user [...]
Answer Question
| May 13, 2013 5:27 PM
AS/400, AS/400 batch job, OS/400
We are supporting OS/400 V7 R 1 and we need to know the commands to make the following type of change. (We are new to AS/400). We need to know how to change the OWNER field to *GRPPRF for all user profiles that belong to the group profile of (DEVUSERS). There are over 1,000 user [...]
How can we add monitoring of messages in SDMC and send emails to particular group?
Hi, How can we add monitoring of messages in SDMC and send emails to particular group. for example…CPI1468(System job tables nearing capacity) and system threshold. Thank you, GK
Answer Question
| May 13, 2013 4:32 PM
AS/400 administration, iSeries administration
Hi, How can we add monitoring of messages in SDMC and send emails to particular group. for example…CPI1468(System job tables nearing capacity) and system threshold. Thank you, GK
Why there is a partial library backup?
Hi , Greetings for the day, The backup job went in to MSGW state with CPF3777 (800 libraries saved, 1 Partially saved, 0 not saved) We used to take backup using Flash copy as we are using V7R1 OS with backup cluster. Kindly understand me what happened in that backup. Why there is a partial [...]
Answer Question
| May 13, 2013 4:01 PM
AS/400 administration, AS/400 backup, iSeries administration
Hi , Greetings for the day, The backup job went in to MSGW state with CPF3777 (800 libraries saved, 1 Partially saved, 0 not saved) We used to take backup using Flash copy as we are using V7R1 OS with backup cluster. Kindly understand me what happened in that backup. Why there is a partial [...]
Using pointers
I need to update a lot of fields in a record testing on an internal array if that field is “updatable”. This should be: FILEFIELD001 = DSFIELD001 for each updatable field. I wonder if could be possible to use pointers to change values in a record and then update that record? In other words, instead [...]
Answer Question
| May 13, 2013 9:53 AM
AS/400, AS/400 Fields, Pointers
I need to update a lot of fields in a record testing on an internal array if that field is “updatable”. This should be: FILEFIELD001 = DSFIELD001 for each updatable field. I wonder if could be possible to use pointers to change values in a record and then update that record? In other words, instead [...]
CPYF alternative
Hi, One of out Auto start job is locking a file (A). (triggers are used and it is designed like that only) And another program which copies the file (B) in to (A) by CPYF is going to MSGW, telling the object is locked. How we can overcome this…are there any alternate solutions to copy [...]
Answer Question
| May 13, 2013 6:26 AM
AS/400, AS/400 jobs, CPYF
Hi, One of out Auto start job is locking a file (A). (triggers are used and it is designed like that only) And another program which copies the file (B) in to (A) by CPYF is going to MSGW, telling the object is locked. How we can overcome this…are there any alternate solutions to copy [...]





