Available Certifications for AS/400 Developers
Hi All, I have been working on AS400 as a Developer on RPG IV, CL and DB2/400 for around 4 years and i wanted to do any certification regards to AS400. Actually I’m planned to write RPG IV Certification Exam(Certification No :268), but recently i came to know from my friend that this certification is [...]

Answer Question   |  April 4, 2012  12:47 PM
AS/400, AS/400 certification, AS/400 development, RPG IV

How to create AS/400 user defined commands
I tried to create user defined command, but couldn’t understand the paramters to input in CRTCMD. CMD          > MSG                    >   MYLIB PGM          > MESSAGE                >   MYLIB SRCFILE        QCMDSRC                    *LIBL   SRCMBR         *CMD      THDSAFE        *NO  Here, I have created one CLP MYLIB/MESSAGE to run just one simple command DSPMSG. however I’m not sure what values to be [...]

Answer Question   |  February 4, 2011  9:53 AM
AS/400, AS/400 command functions, AS/400 commands, AS/400 user permissions, User Defined Fields

Using Query on 4 different files
Hi i have four different files each containing a Customer name ,number and sales amounts ,each file is for a different quarter of the year ,i would like to join the four files so that i can produce a report which lists across the page by quarter the sales for each customer,however not all the customers [...]

Answer Question   |  February 7, 2011  1:02 AM
AS/400 File Sharing, AS/400 Query, AS/400 Reports, Query

Usual type of work available in AS/400
whats the usual type of work in as 400 platform.whether more opportunities in technical or maintanance

Answer Question   |  February 7, 2011  3:52 AM
AS/400, AS/400 careers, IT career development, IT careers

CLRLIB on IG1
Hello I appreciate 2 answres but I would like to tell you that I have finished my program and I used option 23. 23. Clear lib on IG1. I used SBMRMTCMD AND FOR ddm FILE i JUST USED or called a “testfile” Now I use this in a CL program and program compiled. But I [...]

Answer Question   |  February 1, 2011  2:25 AM
AS/400 DDM Function, AS/400 Library, DDM, LPAR

Take a date and format to MDY in RPG IV
I have a date coming in from a file (ADDate Zoned 8 0) so it comes out 20090428 but I want to have it convert to 042809 how can I do that? thanks  

Answer Question   |  February 1, 2011  12:27 AM
AS/400 date format, AS400 RPGLE, RPG IV

Free IT Book: Computer Incident Response and Product Security
This week’s free IT book is a practical guide to building and running incident response and product security teams. To win Cisco’s Computer Incident Response and Product Security answer one of these five questions and post the link to your answer in the discussion area below. Good luck! Mitigating cloud server risks during DDoS attacks [...]

Answer Question   |  February 1, 2011  5:18 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

QZRCSRVS too many jobs
Hello. What could be the reason to have too many QZRCSRVS jobs in the log history. This job runs 24000 times per day. DSPLOG job(QZRCSRVS) msgid(cpiad09) doesn’t diplay anything which means no remote connection. This make crazy, why this job run for few seconds 3 to 4 times per second ????  Only these jobs are [...]

Answer Question   |  February 2, 2011  3:25 PM
AS/400, AS/400 jobs, iSeries V6R1, OS/400

as/400 disk utilization
Actually the problem is related with High disk utilization. When I login to as/400 server then there is no any job is runnig but the disk utilization is continously increasing after every 30 min . Increament is 0.5% per 30 min . But I could not find that job which uses that disk utilization can [...]

Answer Question   |  January 31, 2011  10:44 AM
AS/ 400 System - Disk capacity, AS/400, AS/400 Disk Space, AS/400 stored procedures

what mon msg would i use in my CLP when checking for modules under my SBS?
I have a clp that checks modules/jobs that run under my subsystems.  I’m not sure what mon message it is giving me since none is shown if the job is not active. Only thing that is shown to me is the wrkactjob screen with (No active jobs to display). I would like for when this event occurs, [...]

Answer Question   |  January 31, 2011  6:58 AM
AS/400, AS/400 subsystems, AS400 CLP, CLP

EVault Software IBM i Agent 6.1
We are using FIS Horizon and we just started testing with Vault software. If anyone is using it how do you like it?

Answer Question   |  January 28, 2011  5:28 PM
iSeries, iSeries administration, iSeries V6R1, OS/400

WRKDIRE
I have directory entries where the user profiles have been deleted years ago.  When you go to delete them it comes back with CPF9041 with recovery steps to take.  Message . . . . :   User *N, User ID and address JANE CLAYTON, cannot be   removed.                                                              How would I go about deleting them off [...]

Answer Question   |  February 3, 2011  4:13 PM
AS/400 Directory, OS/400, WRKDIRE

Interform400 printing on dot matrix printer
I use interform400 and want to know if anyone else is using this useful tool. What I really hunting is for the overlays to be wriiten on a dot matrix

Answer Question   |  February 28, 2012  1:42 PM
AS/400 printers, AS/400 printing, AS400 printing issue

AS400 query
I want to be able to write a query that says take xdate field plus a number of days. How do I do this

Answer Question   |  January 28, 2011  12:05 PM
AS/400, AS/400 date format, AS/400 Query

DCLF Command
how many DCLF commands are possible in 1 CLP program. Some says that depends on version also. Is that correct? If yes can someone please list the numbers of DCLF corresponding to the versions? Any documents r pdf would be much appreciated. Thanks all.

Answer Question   |  January 28, 2011  4:41 AM
AS/400, CLPROGRAM, DCLF, OS/400

Batch job running for long time
If there are millions of records in a database file and a job accessing this Physical file goes into infinite loop. What will be the steps to determine at what point does this occured or at which record?

Answer Question   |  February 2, 2011  4:02 AM
AS/400, AS/400 batch jobs, Batch jobs, OS/400

API QwpzHostPrintTransform failed
API QwpzHostPrintTransform failed hptopt = 30 while using the utility CVTSPLFPDF from freeware MMAIL utility. What to do? Is there some code that will convert scs spool file to pdf with overlay

Answer Question   |  February 1, 2011  6:22 PM
AS/400, AS/400 Spool Files, MMAIL

how to convert RPG to document
Ihave a rpg program ,my requirement is how to copy all rpg program source code to micro soft word document,please give any camands or cl programs or rpg programs

Answer Question   |  February 7, 2011  2:13 PM
AS/400, iSeries RPG programming, RPG Program

RPG Program Files in Update Mode
One RPG program P1 opens a file FILE1 in update mode and trailing program P2 opens the same file FILE1 again in update mode. Now P1 updates a particular record (say using CHAIN). Now P2 also want to update the same record (Say using CHAIN). will P2 recieve a new data or old data from [...]

Answer Question   |  January 28, 2011  12:56 PM
AS/400, iSeries RPG programming, OS/400, RPG Program

AS/400 record lock situation
I have two subfiles and each updates a file. A user uses the subfile and updates the record. At the same time the another user uses the same subfle and same program to update the same record. How to handle this situation?

Answer Question   |  February 1, 2011  12:54 PM
AS/400, AS/400 Subfiles, OS/400, Output Queues