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
asked by:
45 pts.

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
asked by:
330 pts.

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
asked by:
1,880 pts.

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
asked by:
50 pts.

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
asked by:
1,880 pts.

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
asked by:
40 pts.

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
asked by:
15 pts.

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
asked by:
CUK
5 pts.

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
asked by:
400 pts.

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
asked by:
525 pts.

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
asked by:
115 pts.

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
asked by:
275 pts.

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
asked by:
525 pts.

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
asked by:
525 pts.

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
asked by:
95 pts.

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
asked by:
95 pts.

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
asked by:
275 pts.

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
asked by:
275 pts.

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
asked by:
15 pts.

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
asked by:
525 pts.