Explore IBM System i on Experts Exchange

Expert Solutions for Your Tech Problems

IBM System i

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a me...

Read more
  • 3.9K Content
  • 954 Contributors

Expert Spotlight
Expert for hire: IBM i, AIX, Linux, Windows, DB2, Performance, Security. EDI

30+ year IT expert: IBM i/iSeries/AS400, AIX, Windows, Linux, EDI, security, performance, web, mobile, cloud, SQL, RPG, Java, .NET, more.

Leading Experts In
IBM System i

No Top Experts for this time period. Answer questions to earn the title!

Troubleshooting Solution

Zebra 105sl stops printing intermittently from AS400

We have an AS400 mainframe running green screen BPCS.  Intermittently
about once a week. …

SSH: Trying to send files in binary mode from STRQSH …

SSH: Trying to send files in binary mode from STRQSH (phase). Is there a command like the FTP …
Troubleshooting Solution

Weekday to date


Hi Experts,
I need a WEEKDAY calculation. 

There are enough examples for date to weekday, but I need

Troubleshooting Solution

IBMi CL command to merge files into one file


Hello Experts, this is an IBMi question.  What CL command merges IFS files into one file? 


Troubleshooting Solution


We have a CISC box V3R2 and a RISC box V3R7 running TCP/IP.  
The CISC box can ping the RISC.
The …
Troubleshooting Solution

Embedded SQL in SQLRPGLE program question on IBM i


Does anyone have an example of using a the wildcard  '%' in an SQLRPGLE program with embedded sql?

Troubleshooting Solution

Convert and Put OUTQ files to PC using VB6 if possible

I m a vb6 programmer. I have started a new job where they have main software running on AS400 …
Troubleshooting Solution

Updating Libraries using black and green screens or i Navigator

I am on an AS400/Power Series7 for those that don't call it AS400 anymore but anyway

 I need to …
Advice Solution

Display ANY NFS mounts on iSeries server


Does anyone know if there is a way via the Green Screen on the iSeries to show any NFS mounts

Troubleshooting Solution

Declare Global variable


Hi Experts,

I'm running into the limits of my imagination on how to deal with include members.
I hope

Troubleshooting Solution

Error message CPF4101 appeared during open

We have an AS400 that went down last week, we were able to recover but one program doesn't work. …
Troubleshooting Solution

Merge an file on IFS while file is open.


Hi Experts,

My program is using the procedures "_C_IFS_fopen" and "_C_IFS_fputs" to write data to an

Advice Solution

Determine all programs that use a field in a file.(All programs that uses a column in a table)


Does anyone know that, if given a field name, from a file, is there a way to determine every program

Troubleshooting Solution

Sql server linked server to view AS400 table data has gibberish in table's data

I have created a linked server to our AS400. Some tables come through fine, others have the data all…
Troubleshooting Solution

DB2/400 date query problem

Hi all, I have a numeric field wich is supposed to represent a date. Somehow a developer thought …
Troubleshooting Solution

sql vs rpg

I was told that essentially RPG and SQL
are the same and I somewhat perplexed.
As far as table …
Troubleshooting Solution

VarChar issue in RPG program


Hi Experts,

I have some trouble with a VarChar field that I get from an external program.

The field is

Troubleshooting Solution

QNTC link

We have our server connected to our I-series (5.4) the other day it dropped our server information. …
Troubleshooting Solution

Can anyone see an error on calculating the leap year days on my RPG program?

I have a subroutine to check if the day is leap year or not. OUr current program is not working.  …
Troubleshooting Solution

Export Data from AS400

I have a customer that is trying to retrieve data from an AS400 to import into a newer system.

I …

Do more with Experts Exchange.

Get Answers

Join a Group Discussion


Monitor your Site

Explore solutions and more