Export AS/400 to MS Access
My auditor wants me to export files from my AS/400 to MS Access and I don’t have a clue how to do that or if it can be done. I hope someone does.

Answer Question   |  June 29, 2010  7:00 PM
AS/400 import/export, export file, iSeries, MS Access

How can I see when a user signs onto iSeries to check their profile?
I need to know a user signs on the iSeries so I can check the profile aganist a file to disable the profile or not. How can I get this information??

Answer Question   |  June 22, 2010  5:30 PM
iSeries, iseries v5r4, V5R4M0

Trimming just one leading zero (if present) in SQLRPGLE
I have a SQLRPGLE program and have 6A character field. How to I trim just one leading zero(if present) Eg- if 001300 then I should insert 01300. Thanks!

Answer Question   |  June 29, 2010  5:37 AM
iSeries, OS/400, SQLRPGLE

Robot/SCHEDULE passing scheduled run date and time
Is there a way to get the [strong]scheduled[/strong] run date and time passed into the called program as parameters.  for example, it is supposed to run at 23:00 on 6/15, but due to a power outage, it is now 01:15 on 6/16.  Is there a way to setup the “Reserved Variables” so that the program receives the [...]

Answer Question   |  September 14, 2011  12:48 PM
iSeries, iSeries V6R1, V6R1

Spool file in DFR status
Hi, I have this spool file queued in a RMT printer but in DFR status. I already checked the output queue and the “Maximum spooled file size” is set to *NONE. How can I get rid of this DFR status and prevent it from coming back. . . . THANKS

Answer Question   |  June 16, 2010  1:05 AM
AS/400, iSeries, iseries v5r4, Output Queues, RMT printer, V5R4

Inserting DB2 records on iSeries to SQL Server 2005 Table
I need to insert records from a DB2 file residing on an iSeries to a SQL Server 2005 table on a remote system. How can I do this in a CL or RPG ? Thanks

Answer Question   |  June 20, 2011  12:27 AM
DB2, iSeries, SQL Server 2005

Activation Groups, RPGLE, and Open Files
Hello Everyone, We have a couple question regarding activation groups, RPGLE, and Open files. In our H specs for RPGLE and SQLRPGLE programs, some of our programs use dftactgrp(*yes), some use dftactgrp(*no), and some use dftactgrp(*no) actgrp(*caller). What are the differences? And, should all of our programs be something? 90% of our programs are using [...]

Answer Question   |  June 16, 2010  7:28 PM
Activation Groups, iSeries, RPGLE, SQLRPGLE

Free format compilation error
My compilation fails when columns 1-5 of my source code is not blanks using CRTSQLRPGI.  Columns . . . :    1 100                                      Browse  SEU==>                                                               FMT **  …+… 1 …+… 2 …+… 3 …+… 4 …+… 5 …+… 6 0558.00 Z001   //**************************************************** 0559.00 Z001   //* @Create_Header_Record file in QTEMP               0560.00 Z001   //**************************************************** 0561.00 Z001   BegSr @Create_header_Record [...]

Answer Question   |  June 10, 2010  11:25 PM
iSeries, iSeries error messages

Getting an electronic copy of BRMS report
BRMS prints a daily report that can be used to recover the iSeries. Is there a way to make this an electronic report?

Answer Question   |  June 9, 2010  7:47 PM
AS/400, BRMS, iSeries, V5R4M5

Excel Transfer from iSeries ERROR
Hi. I have created a query on the iSeries machine and then stored the results in a database file (pf). I then try to transfer the file to excel using the iAccess plugin. However I get the following error: CWBDB0052 – Error during data conversion. Any help would be greatly appreciated. Thanks

Answer Question   |  June 11, 2010  1:01 PM
Access to Excel, AS/400, iSeries

Plus signs in fields when using a date from a file compared to the month and year function
I have included the complete SQL statement. I keep getting +++ in ontime and percent. select c.totallines, c.ontime, decimal(((c.ontime/c.totallines)*100),15,2) as percent from (select decimal(sum(b.totallines),15,2) as totallines, decimal(sum(b.ontime),15,2) as ontime from (select a.ord as ord, a.line as line, a.custreqdate as custreqdate, a.qtyord as qtyord, a.qtyship as qtyship, a.shipdate as shipdate, a.qtyinv as qtyinv, a.invdate as invdate, [...]

Answer Question   |  June 1, 2010  2:08 PM
iSeries, iSeries SQL, SQL statement

Phantom locks
Our nightly backups consist of a series of saves to save files, followed by a save of the save file library to tape. For the past 10 days or so the program has been receiving CPF3761 – Cannot use FILE EC#FILE in SAVELIBS. milliseconds after the SAVLIB command is issued. The second-level text reads FILE [...]

Answer Question   |  June 29, 2010  3:13 PM
AS/400, iSeries, OS/400, SAVLIB

QSYSOPR does not have authority to perform upgrade
we were trying to perform the Prepare for Install from GO LICPGM and loaded the CD’S as QSYSOPR and we were NOT AUTHORIZED, is OS upgrade on iSeries not a part of QSYSOPR profile?

Answer Question   |  May 27, 2010  10:42 AM
AS/400, iSeries, iSeries AS/400, QSYSOPR

Avision AV2800 Scanner
I am almost at the point of purchasing a new Avision AV2800 Network Scanner for our Company. Problem I have is whether it will enable us to save our scanned files directly on to an iSeries5 IBM Server. I have heard other companies with a “Windows” file server do not have any problems with this, [...]

Answer Question   |  May 27, 2010  5:39 AM
IBM Servers, iSeries, iSeries networking, Network Scanners

unlock multimember file
I have an unusual problem with an RPGLE program. This is called inside of other programs that were originally a package software. The file is multi-membered and I am not able to remove locks on the member even when I exit the program, use other programs, etc. I am on an iSeries and commitment control [...]

Answer Question   |  May 27, 2010  9:06 PM
File locks, iSeries, iSeries File Members, RPGLE

Has the certification for AS/400 v5r4 operator ceased?
Am trying to find certification for 000-975 ( i think ) for iSeries v5r4 operator, has it been taken of record because all I see is v5r4 administration and no operations.

Answer Question   |  May 19, 2010  1:37 PM
AS/400 certification, iSeries, iSeries Certificates, V5R4

Download from iSeries directly to an Excel xls file – no CSV
I need a little help! Is there anything out there that I can incorporate into a CL program that will download a database file to Excel with an xls extension so no further converting is necessary. I tried the CVTPFXLS but get Pointer not set for location referenced.

Answer Question   |  May 20, 2010  11:56 AM
CL Program, iSeries, iSeries programming commands, Microsoft Excel, XLS

List all file members from a multi member AS400 File
I need to be able to retrieve a list of the members of a multi member file  so that I can process the members that meet certain criteria.  I need to be able to do this from a PC application. If there is anyone with any ideas I would be grateful.   Thanks

Answer Question   |  May 15, 2010  6:37 PM
AS/400, iSeries, Multi-Member, ODBC Microsoft Access Driver Login Failed

Batch jobs disappear
Batch jobs show under WRKUSRJOB while the job is active but then disappear once the job finishes, even though there are spool files for this job. Any ideas on how to change this so the job remains visable to the user so that they can easily find the spool files for the job?  Happens for both [...]

Answer Question   |  May 17, 2010  2:33 PM
Batch jobs, iSeries, Spool files

Transfer Or copy savf from Iseries Server to Other Without use ftp
Hi How copy savf file from iseries server to other without need to user FTP because it not working with me

Answer Question   |  May 10, 2010  10:42 AM
iSeries, SAVF