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
<
Monthly
>

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

Troubleshooting Solution

Zebra 105sl stops printing intermittently from AS400

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

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

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

Weekday to date

4

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

9

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

Exp.  

Troubleshooting Solution

AS400 TCP

52
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

1

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

52
Hi,
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

53
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

10

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

3

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

50
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.

2

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)

6

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

bybmutch
38
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

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

sql vs rpg

34
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

7

Hi Experts,


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

The field is

Troubleshooting Solution

QNTC link

34
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?

byststst
26
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

29
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

Collaborate

Monitor your Site

Explore solutions and more