Automation of AS/400 Jobs Monitoring and Voice Message Alert
This is not Question. This is an Idea. Hope this might be useful for any of you to Automate your Job Monitoring on AS/400. We have human team to monitor jobs running on our AS/400 production servers and alert OnCall person when they find any issue. The human dependency is avioded. I have built component on [...]

Answer Question   |  October 9, 2011  3:24 PM
AS/400, iSeries

Replication MIMIX
Can anyone tell me how to estimate the time/network bandwidth required in relation to data load?

Answer Question   |  October 9, 2011  3:14 AM
MIMIX for AS/400

Retrieving unique RPG fields
I have patients name in Master File.In the master file there is not Key Field and there is no Unique also.In the Master File there are the names of patients,time,date etc. Now i want to retrieve the name of the Patients but when i pull the records from File the name shud not repeat. How [...]

Answer Question   |  October 11, 2011  2:46 PM
AS/400

Reading only the active records in a flat file
I have a physical flat file which has thousands of deleted records. (I can’t get exclusive use of the system to do a reorg) I am doing a sequential read of the file because the file only has a few active records. However, it is taking the program awhile to finish and I’m guessing it is [...]

Answer Question   |  March 31, 2012  7:05 PM
AS/400 flat file, RPG, RPG ILE, RPG IV, RPG/400, RPGILE, RPGLE

FTP check for file transfer success
Is there a way from within the FTP script to check for successful GET without exiting FTP session ?

Answer Question   |  March 31, 2012  6:27 PM
AS/400 FTP, FTP, FTP management

Restored Journal receivers that are deleted by system
Sir Tom: I somehow perceived that it’s kinda related to restoring journal receivers so i decided to just attached my concern to Leah Rosin’s “Restoring journal receivers”. Well, going back to the issue, my question was ” i’m able to restore previous journal receivers to the library but after a short time, the restored journal [...]

Answer Question   |  March 31, 2012  11:52 AM
AS/400 journaling, iSeries Journalling, Journal receiver management, Journal Receivers

What could be the reson for OVRDBF and OPEN on file is not working in RPGLE program.
Hi All, Can anyone please help me with below issue. The is a program abend in our production system in RPGLE program and with in that following operations happening, but i found errors while running program as below. following are the breif Sequence of operations written in RPGLE: 1. File(FMABCF)is declared as USROPN in F [...]

Answer Question   |  March 31, 2012  6:00 AM
OVRDBF, RPG ILE, RPGLE

Cannot run Malwarebytes, HJT, SuperAntiSpyware
Cannot run Malwarebytes, HJT, SuperAntiSpyware. The icons for these on the desktop are a white box. Error message when opening “Windows cannot access the specified device, path, or file. You may not have the appropriate permissions to access the item.” DDS and GMER logs follow. . DDS (Ver_2011-08-26.01) – NTFSx86 Internet Explorer: 8.0.6001.18702 Run by [...]

Answer Question   |  March 31, 2012  5:19 PM
File systems, HiJackThis, Malwarebytes, SuperAntiSpyware

EXTENDED: IT Scripts Contest now ends October 17
It’s not too late! IT Knowledge Exchange is extending its latest contest: Is your script 3-dimensional? You don’t have to be an IT Script Shakespeare to get in on the contest: Did you know you can win a Nintendo 3DS for just leaving a great comment on one of the entries? Check out the entries [...]

Answer Question   |  March 31, 2012  3:30 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Scripts, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Job Scheduler affecting environment variable
In CL program I am using QIBM_QSH_CMD_OUTPUT environment variable to direct output to STDOUT and then overriding this to database file. This is to capture logging from sftp server, accessed via batch script. When I run the CL program using SBMJOB from command line it outputs logging to DB file. When I call the CL [...]

Answer Question   |  March 31, 2012  2:21 PM
CL Program, iSeries job scheduler, Job scheduling, QSH environment variable, SBMJOB

create 39 barcode using PCL commands
what is PCL command for 39 barcode sent from AS400

Answer Question   |  October 6, 2011  12:34 PM
AS/400 commands, CL Commands, PCL, RPG/400

Printer files on an iSeries
Why can’t I get the SIZE keyword defined in DDS for Page Segments to work?  The Positioning keywords (Pos Down, Pos Across) work fine, but when I enter the image width and height, the image does not print. The image (in this case, the company logo) was created on a PC with a particular size and [...]

Answer Question   |  March 31, 2012  8:56 PM
DDS Printer files, iSeries printing, Printer files

AS/400 COBOL
one physical file have 6 key fields,now i want to retrive the 10th record based on one key field,how to retrive in cobol/400 with without using logical file ex:- emp pf have 6 key fields,and emp have records,now i want to retrive particular record in emp(10 th record only),in my cobol pgm some times use [...]

Answer Question   |  March 31, 2012  10:07 AM
AS/400, AS400 physical file, COBOL/400

INZSR with RETURN & INLR
Hi There, How INZSR will work with RETURN & *inLR *ON. 1:->I mean Pgm A is calling Pgm B.Pgm B is using INZSR & RETURN .So how INZSR  will work during the 2nd call to PgmB .I mean when Pgm B got called 2nd time then control will pass to INZSR or Not? 2:->Pgm A [...]

Answer Question   |  March 31, 2012  7:29 AM
*INZSR, Coding, RPGLE

RPGIV Coding Approach for 1 billion records
I have 1billion records in a PF.Key filed  is Date.I want to generate a report based on Key field.Which approach will be best for me (I mean shall i go with OVRDBF or any other approach)Please suggest.(RPGIV-Free Format-V5R4)

Answer Question   |  March 31, 2012  7:21 AM
OVRDBF, RPG Code, RPGIV, V5R4

Indicator Off with RPG
How can we put all indicator off in single statement or in rpg code (It might be RPGIII Or IV)

Answer Question   |  March 31, 2012  7:14 AM
RPG Code, RPG indicators, RPGLE

Parsing a XML file with Chinese Characters in AS/400
I am working on a project which require to parse a XML file (in UTF-8 encoding) and put the value into a AS/400 physical file by using JAVA. However, one of the tags in XML may contain both Traditional Chinese and Simplified Chinese characters. The field in the physical file has already defined as DBCS [...]

Answer Question   |  March 31, 2012  4:33 AM
AS/400, CCSID, Java, UTF-8, XML, XML development, XML File Creation

Using Data Queues To Monitor Output Queues
I understand that a Data Queue is an efficient way to monitor an output queue. Using QRCVDTAQ will allow the program to “sleep” until a new spool file appears on the output queue or if a spool file in the output queue changes from HLD to RDY. However what about the RDY spool files that [...]

Answer Question   |  March 31, 2012  12:09 AM
Data Queue, OS/400, OS400 Data Queues Output Queues, QRCVDTAQ

Typographic/proportionally spaced fonts
I would like to use a proptionally spaced font for a column report, my first go was a mess, is there someting that I should be doing to ease the tidying up process?  Or is it a case of trial and error?

Answer Question   |  March 31, 2012  4:14 PM
iSeries, iSeries administration, V5R4

Parm Value Changed on Dynamic Call in free
I have a prototype in my free program to call an external program. The parms on my prototype include two fields that are defined as 2S 0. The value of these two fields are 00 and 01 at the time of the call tothe prototype. Using debug, I step into the program being called and [...]

Answer Question   |  March 31, 2012  3:08 PM
IBMi RPGLE, iSeries V6R1, Parameter Stored Procedures