AS400 iSeries Applications
Hi all that read this. This is less of a technical question, more of an opportunity. (please don’t hate me, just spreading the ibm love) The organisation i work for is offering incredible offers to organisations on the IBM i (AS400/iSeries) platform. H/A – D/R – Multi – licenses and orders placed before 2014 will [...]

Answer Question   |  May 20, 2013  3:05 PM
AS 400, i5, iSeries, iSeries AS/400, RPG, RPGLE, V5R4

Importing a .dbf file into IBM DB2 table
I have a .dbf database file I want to upload to our IBM i5 and into a DB2 table. Is there an easy way to do this or am I going to need to convert the .dbf file into a .csv file? I’ve tried using the CPYFRMIMPF command, but have had no such luck. Any [...]

Answer Question   |  July 19, 2012  3:02 PM
AS/400, CPYFRMIMPF, DB2, DBF file, i5, V5R4

i5 Query Security
Are there any commercial security programs that will secure the query function on the as400? We have user menus that keep users from viewing and changing critical files. However, we also have users who go into query and save the results of the query anywhere on the system.  I’m concerned that someone will save the results of [...]

Answer Question   |  March 31, 2012  7:01 PM
AS/400 Query, i5, I5 security, Query, Security

Problems with AFP respool in mapping program redpaper Infoprint server/Psf
We work with the mapping program of the Ibm redpaper Printing VII. Everything works without problems (creating PDF and respool PDF) except the AFP respool does not work. We get no error messages en there are no joblogs. The AFPOUTQ keeps empty. Who can help us please with this problem. Albertus Land

Answer Question   |  March 31, 2012  7:10 AM
AFP, AS/400, i5, InfoPrint Server, iSeries, Mapping Program

Journaling on i5 when updating from .net
We need to update some i5 files (under v6r1) from SQL in a .NET environment. Can I control this process via SQL or will I need to call CL commands from .NET to start/stop journaling & commitment control?

Answer Question   |  May 2, 2011  3:41 PM
.NET, AS/400 journaling, CL Commands, i5, iSeries V6R1, SQL Server

How can I concatenate files for transfer from the iseries
I have 3 files with a common layout in a common library on the i5. The source files (query results) have different definitions so I am unable to append the result of query2 to query1. So what I want is to perform a UNION or concatenate them into a single download file. I have tried a [...]

Answer Question   |  February 28, 2011  3:12 PM
AS/400 Query, Concatenate, i5, i5 Commands

Need to display a PDF on i5
I need to display a PDF file that was created using OVRPRTF with WSCST(*PDF) on the user’s i5 screen. I have tried IFS command DSPF but only garbage displays. This program used to do a DSPSPLF but we had to change it to use an overlay and only the data shows (none of the text [...]

Answer Question   |  September 26, 2011  12:17 AM
i5, iSeries printing, OVRPRTF, PDF

How to include a signature on a spooled rpt to be emailed
Hello We want to email letters that we currently are printing off the I5..We have scanned the signature on to the I5..how can we include this signature at the bottom of each letter to be emailed? Thanks

Answer Question   |  January 29, 2011  8:40 PM
AS/400 printing, AS/400 Signatures, AS/400 Spool Files, i5

Copy Spooled File to a Source Physical File Member
How do I copy a spooled file listing into a member of a source physical file? I accidentally deleted the source member, but have a spooled copy taken via option 6.  I would like to convert the spooled file back into the deleted member.

Answer Question   |  December 9, 2010  4:13 PM
AS/400, COBOL, Copy File, i5, iSeries, Source Physical File, Spooled File

i5/OS PASE program not found or in use
I’m calling the following in a job submitted from the job scheduler CALL QP2SHELL PARM(‘/Sites/PCF/sftp2pcf.sh’) I continue to receive the error i5/OS PASE program not found or in use. I have confirmed the name of the script in the ifs and there are no locks on it. Why can’t it find the script to run?

Answer Question   |  December 6, 2010  1:45 PM
i5, i5/OS, PASE, QP2SHELL, Scripting

Retrieve the iSeries user ID using only password
Is there any way to retrieve the user ID from their i5OS user profile using inly their password

Answer Question   |  December 7, 2010  9:58 PM
i5, iSeries, iSeries User Profiles, Security, User authentication

Will the SQL performance improvements in V6R1 affect QUERY?
Will the SQL performance improvements in V6R1 affect QUERY? Does QUERY use SQL under the hood?

Answer Question   |  September 17, 2010  3:13 PM
i5, SQL performance, SQL queries, SQL Query, V6R1

Receiving result sets in RPG (prior to release 7.1) from an SQL SP
I have read through the IBM manual “Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries” for information related to returning a result set(s) from a stored procedure into an RPG program. The manual states that a Global Temporary table must be used for this as it cannot access the result set [...]

Answer Question   |  August 26, 2010  5:45 PM
i5, RPG, SQL, SQL stored procedures, Stored Procedures

Function PGM-QWASSTRSVR In JVAW using 95% of CPU, how to reduce it?
We have a WAS Job using 95% of our CPU ( got it from wrkactjob) we tried to tunning garbage collection and appeared that worked cause it (after restart) the job went down and was working with 25% OF cpu.Suddenly it started to use amonge 95 to 99 % of CPU again, any solution to [...]

Answer Question   |  August 4, 2010  4:41 PM
AS/400, i5, iSeries, Java, WAS, WebSphere Application Server

Numerous Job Logs for QZSOSIGN after upgrade from V5R4 to V6R1
Just upgraded our Dev box from V5R4 to V6R1. I am now noticing numerous job logs being generated for QZSOSIGN, Signon Server Job. I can tell by the joblog entries that request is for user Qsecofr, how do I track it back to what job is actually making this request ?

Answer Question   |  October 26, 2011  3:01 PM
AS/400, i5, iSeries, OS/400, Upgrade from V5R4 to V6R1

System i Navigator connection error to Central Management System.
I am getting an error message in System i Navigator when I try to connect to Central Management System. “Unable to complete the connection to central system `system name`”. I am trying to retreive the System Operator Messages. Also under Basic Operations – Messages click on the bottom panel on View System Operator Messages, nothing [...]

Answer Question   |  June 16, 2010  4:44 PM
AS/400, i5, iNavigator, iSeries Navigator, iSeries Navigator Application Administration

IOPLess Storage Adaptors
Does i5/OS collection services report on IOPless adaptors? I cannot find any information on FC57xx storage adaptors in any of the QAPM* performance files.

Answer Question   |  May 7, 2010  11:52 AM
Collection Services, fc57 storage application, i5, IOP, IOPLess, qapm performance

call php script from CL – slow
Hello, i try to call a php-script on our 520. CHGVAR     VAR(&CMM) +                                                VALUE('/usr/local/Zend/Core/bin/php +                    /www/zendcore/htdocs/test.php') QSH        CMD(&CMD) i try to send an email in the php script and i was wondering why it takes about 5-8 seconds to send the mail. So i tried to find out where the script is slow. [...]

Answer Question   |  March 31, 2010  12:45 PM
CL, i5, PHP, Qshell

HTTP ADMIN – 500 Internal Server Error
We have 525 with V4R5M0 ipaddreess ipaddress1 and LPAR2 ipaddress2 with lastest PTFs. In Internet explorer or Mozilla Firefox: http://ipaddress2:2001 (ipaddress2 is LPAR2) and hit enter it shows i5/OS Task page -When I click on IBM Web Administration got error message 500 Internal Server Error The server encountered an internal error or misconfiguration and was [...]

Answer Question   |  March 22, 2010  9:57 AM
i5, i5 525, V4R5M0

Remote Location Services – i5/OS
To All, We are located in Concord, NH and are looking for an out of state service that would provide remote redundancy for our Production Servers.  We are primarily interested in a Disaster Recovery Solutiion, not necessarily a High Availability solution. Thank You, Bill

Answer Question   |  February 17, 2010  8:06 PM
i5, i5/OS, Windows Server 2003