Access LDA for job waiting on a JOBQ
Is there a way to access the LDA for a job that is waiting in the JOBQ? I want to write a program to monitor jobs in a JOBQ and move them to other JOBQs based on information that is in the LDA.

Answer Question   |  November 15, 2009  2:11 PM
AS/400, RPG

Need help using RUNRMTCMD
Greg is experimenting with the RUNRMTCMD on the AS/400 from a command line. He writes, “Can I run a VRPG exe on my local PC from the AS/400? If so, how? I keep getting a message CPE3447 ‘A remote host did not respond within the timeout period’. First, where can I get my local PC [...]

Answer Question   |  November 15, 2009  10:09 AM
AS/400, RPG

Unable to place file on the IFS drive
I have a vendor who is providing an update via download from their website. The instructions are to save the zip-file to a PC, then un-zip the contents to the IFS drive. When I specify the IFS drive (in the un-zip process) and hit enter, the message; Error, access is denied followed by, Cannot create [...]

Answer Question   |  October 11, 2005  11:41 AM
AS/400, RPG

SYSTEM OPENESS INCLUDES
Hello everyone, I wanted to install the OS/400 System Openness Includes (5722-SS1, opt13). I found 12 CD’s labeled 5722-SS1. I listed them below. I was wondering if someone knew which one to use to install the System Openness Includes. Any help is greatly appreciated. I_BASE-01 L2924_01 L2924_02 B2924_01 B2924_02 B2924_03 B2924_04 B2924_05 B2924_06 B2924_07 B2924_08 [...]

Answer Question   |  October 7, 2005  9:30 AM
AS/400, Database, DB2 Universal Database, RPG

iSeries Computer Based Training – Programming
Looking for information on training options. Has anyone worked with ATS [Automated Training Systems] or Manta Technologies? If so, did you have a positive experience? We would also appreciate any other suggestions. Thanks!

Answer Question   |  May 25, 2012  4:16 PM
AS/400, RPG

Triggers and commitment control
We are having problems finding a way to get trigger programs included in the needed commitment control boundary. The process starts with a JDBC connection to the 400, and via Java executing processes (SQL) that make changes to the DB files. The files are triggered, and any of the files the trigger programs (which are [...]

Answer Question   |  November 14, 2009  12:30 PM
AS/400, DB2 Universal Database, RPG

“map drive” IFS
Hello, We have a ?LAN without any server Windows OS in it? , so everybody is a client (with fixed IP). The only ?server? we have, is our iSeries i5 (V5R3) with iSeries Access(CA) installed (also on the clients). We cannot ?map drive? the IFS f.e. root with QS6555A8Aroot (or anything else on the iSeries; [...]

Answer Question   |  November 4, 2010  2:49 AM
390, Access, AS/400, Backup & recovery, Data analysis, Database, DB2, DB2 Universal Database, Desktops, Development, Hardware, IBM, Mainframe, Management, Microsoft Office, Microsoft Windows, OS, RPG, Security, Servers, SQL Server, Storage, Tech support

Automatic email notifications from iSeries
Nagi needs to write a code on his iSeries 870 to send a notifications to his e-mail, such as server rebooting, jobs not started or need reply, etc. He’s a Windows guy, and doesn’t know where to start. Can someone help him with the code and possibly send him steps on how to write it [...]

Answer Question   |  November 14, 2009  2:14 PM
AS/400, RPG

Variable length fields in RPG IV
Ed is wondering, “If you don’t yet use free-format RPG, is there a way to utilize variable length fields in RPG IV?” What do you think? Is it possible? – Michelle Davidson, editor, Search400.com

Answer Question   |  November 14, 2009  2:04 PM
AS/400, RPG

What is signature checking?
Nirmala is trying to figure out what signature checking is and when to use it. Can you offer some advice? – Michelle Davidson, editor, Search400.com

Answer Question   |  November 14, 2009  1:58 PM
AS/400, RPG

How to convert characters to numeric in CSV file?
Roy wrote the editors of Search400.com recently, looking for help with a CSV file. He said: “I’m using CRTCSVF to create a csv file. My problem is that my customer number is alphanumeric, but they want it to be numeric (without the quotes) in the CSV file and with the leading zeros intact. “Is there [...]

Answer Question   |  November 14, 2009  9:58 AM
AS/400, RPG

Error message in window subfile
i have window subfile. Error message is showing behinde the window. It should show within the window. Following is my coding A R SFLMSGW SFL A SFLMSGRCD(15) A MSGKEY SFLMSGKEY A PGMQ SFLPGMQ(10) A R SFLMSGWC SFLCTL(SFLMSGW) A OVERLAY A PUTOVR A 97 SFLDSP A 97 SFLDSPCTL A 97 SFLINZ A 98 SFLEND A SFLSIZ(0010) [...]

Answer Question   |  October 28, 2009  9:47 AM
AS/400, Database, DB2 Universal Database, RPG

Financial Calculations in RPG
Does anyone have sample code of the following calculations (Excel Equivalent in brackets): 1. Net Present Value (NPV) 2. Payment (PMT) 3. Principal Payment (PPMT) Any form of RPG to run on an iSeries would be great.

Answer Question   |  September 24, 2005  10:13 AM
Corporate Financial Applications, Data analysis, Financial services applications, RPG

Trigers
Can anyone give me an example of using a trigger when a record is inserted into a file? I am using RPGLE.

Answer Question   |  November 11, 2009  9:27 AM
AS/400, DB2 Universal Database, RPG

Problems with Stored Procedures
Hi, I have written a stored procedure in SQLRPGLE. I used option 15 to create a module, then CREATE PROCEDURE to define it. When I go into SQL to call it, it says External program SVLBR in V64BPCSUSR not found. This is where my module & stored procedure is located. Any ideas on what I [...]

Answer Question   |  November 11, 2009  2:28 PM
DB2 Universal Database, RPG

Superseded PTFs.
If there are special instructions for a superseded PTF that is not loaded or applied on your system in an ordered PTF cover letter, do you need to order the superseded PTF and follow the instructions for it before loading the PTF that will supersede it? I hope my question makes sense.

Answer Question   |  November 3, 2010  12:04 PM
AS/400, Database, DB2 Universal Database, RPG

Microsoft Terminal Services and RPG socket programming
Quick background: We are a software developer of medical billing software and have recently partnered with a document imaging company and have developed an interface between our AS/400 database and their document imaging server using RPG socket programs. Most of our clients are using Client Access to communicate with the 400 and our socket programs [...]

Answer Question   |  September 16, 2005  10:48 AM
AS/400, DB2 Universal Database, Desktops, Distribution/logistics applications, Management, Microsoft Windows, OS, RPG, Security, Servers, SQL Server

Data Transfer from AS400 into Excel
I am trying to transfer a file from the AS400 to Excel and I am losing some of my data. I am transferring several files (each with 50,000 records) into Excel using a Client Access icon in Excel (I believe Client Access). When I attempt to transfer the data, I receive error messages and a [...]

Answer Question   |  October 3, 2005  10:46 AM
AS/400, Data analysis, Microsoft Office, RPG

Create a stored procedure that can receive XML doc as parameter
Tammy needs to create a stored procedure on the iSeries that can receive an XML document as a parameter. Also, the stored procedure will then need to call an RPGLE program with the XML doc as a parameter to it. The first thing she’d like to know is if that is even possible. If so, [...]

Answer Question   |  September 13, 2005  1:52 PM
AS/400, RPG, XML

Need help figuring out compile error
Bob needs help figuring out this error he keeps receiving. He is writing a free-form RPG program, and he needs to use CALLP, prototypes, etc., to call another RPG program, passing parms both ways. The called program is also called by many other legacy programs using CALL. The compile error he gets is RNF3751 ‘External [...]

Answer Question   |  November 2, 2010  1:28 PM
AS/400, RPG