IBM System iSponsored by Flatiron School

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.

Share tech news, updates, or what's on your mind.

Sign up to Post

I have a CL Program that runs continuously for processing Orders.
Salesman are out in the field and communicating orders as soon as they have finished taking a customer order.
I want to send an email to a specific user when a new order have been added to the Order DB.

The iSeries has never been used for email so I need to do the full setup.
I only want to be able to send an email from the CL program.
I read a couple articles but it is not working.

can someone please advise?


Get expert help—faster!
LVL 12
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

We have an odd issue on one of our IBM i servers. It appears that every Thursday at 5:00 PM - our hand held devices lose connectivity to our IBM i server.  It looks like our services go up and down for about 20 minutes and then stabilize.  If I look at QHST - I see that there are a lot of devices disconnecting - but i don't see the IBM i actually being unresponsive - but I don't know that for sure.  

I was wondering if there was any detailed logs somewhere related to TCP/IP that I could look to verify if the server actually lost connectivity during that timeframe or if OTHER devices connected to it lost the connectivity.  I have included a couple of snapshots of the show what I am seeing around that 17:00 PM timeframe.

Hi All,

I'm assisting a friend in changing the field length in an existing physical file on an AS/400,iSeries.  We are trying to understand two things:

1. What is the best way of going about this.

2. What is the best way of updating all supporting programs which use the PF or LF.  

Attached is a document we received from a guy who responded to our post on an IBM website.  This has been helpful; however, there are hundreds of programs that reference that PF that we are changing.  

If anyone can shed some light on a more effective way of making these changes, it would be greatly appreciated.

Thank you.

please this is the error i get when i try installing oracle 12cplease this is the error I get anytime i try installing oracle 12c
LVL 39

Expert Comment

by:Geert G
well yeah, the reason is in the fine print of the installation manual
java -version probably won't help

Expert Comment

by:Vince Mabary
It would identify what if any java is installed, and thus lead to knowing where the gap exists.  The error makes it pretty clear JRE is not available on the system, but it could be a version issue.
We would like to set up FTPS (SSL FTP) between our mainframe and IBM i (V7R1 currently). Our mainframe system programmer sent me a certificate (MAINFRAME.CER).  I went into the digital certificate manager on our IBM i and imported the certificate and then added it to the "access" list for FTP.

Does anyone know what else is needed to be able to do FTPS between the IBM i and Mainframe?

I appreciate any help
Hi All,

I would like to include the PNG file or EPS file via AFPRSC to generate the PDF.
Is it possible. If it possible, please send me the sample command with PNG JPG.

Or do you have any other way to include the PNG or EPS file in Printer file to generate the PDF?
Note: I'm using *IPDS printer configuration to print the JPEG via AFPRSC to generate the PDF and it's working fine.

JPG in AFPRSC with 23 works fine. But PNG with 65 is not printing.

0.0 0.0 (*PATH '/JP/STAT'))

Open in new window

Need help on how to get it work? or is 65 the correct component ID for PNG?
I have My data in  IBM AS400 server in data base file format I try to fetch my data from my windows Excel via ODBC but most of the fields are not converted to columns and even not presented in any format . (some numeric fields only we able to see in that excel sheet)
Hi Experts.
I have a customer that wants to be able to access an AS400/iSeries database file from their website.   The Website is hosted offsite and the AS400/iSeries is onsite.  I have googled quite a bit and having trouble finding a lot on how to do this.  I have done iSeries stuff for years, but this out of the ordinary for this.  Any help appreciated.
Hi All,

I am very new in PCOMM VB script and facing the below issue  which is creating obstacle to promote my code in  production...

I am invoking the below program(logcapture.mac) in a AS400 system after logging in to the main screen. It is running properly approx 36 Hrs and after that suddenly
getting stopped. Getting below error if trying to re-initiate from the same screen/session.

"PCSWS041 - The system has insufficient resources or the Script Engine is not properly installed"

But able  to re-initiate if I run with a fresh session by closing the previous.

DESCRIPTION=  ** TLPV - Log Capture v1.0 **

Dim Logger, Domain_Id, atm_LoginID, atm_LoginPassword

'Domaid_ID =============>

Domain_Id = "xxxxxxx.xxxx_xxx"
atm_LoginID = "xxxxxxx"
atm_LoginPassword = "xxxxxxxxx"



Dim Record_Low, Previous_Record_High, Record_High, Nw_Record_Low, Sub_System, Library, Current_ZNL, Pre_Library, Product, path, Node_Name, Nw_Node_Name, Iteration, s,nw_entry, filename,workpath, objFSO, RecordsFile, outFile, objFile,rAwdaTaU, rAwdaTaL,mystring,string_loop_count, k, Remaining_len, count, Logout_indicator
Set objFSO=CreateObject("Scripting.FileSystemObject")

Private sub Main()

Open in new window

Upgrade your Question Security!
LVL 12
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

How a calculate  log base2 (X) (any value to log base 2 )  in rpgle ?
Hi Experts,

I prefer to use a Webservice for this kind of requirements, but that is not in scope in this question

So I have to write a trigger (or trigger-like program) on the IFS, that will be fired when a File is added to a specified path (or even a specific file extention)
Writing a NEP is no option because of the immediate action I have to take.
I found the next options:
  1. Use an ExitProgram on QIBM_QP0L_SCAN_CLOSE
  2. set Journaling to the specific IFS-path
  3. .... any other sugestion is more then welkome

Defining the Exit program keep telling me :
CPF3CE5 ; Exit point QIBM_QP0L_SCAN_CLOSE with format SCCL0100 will not allow exit program MyEXIT library MyLIB to be added.                    
I also not convinced that this is the right way, because every close action in the IFS will trigger this program (not only one specific path I assume)

Journaling is maybe better but:
RCVJRNE seems to loop through all entries and give unreadable data to my program (lots of questionmarks).

I'm out of ideas... don't know what I have to specify to solve this.
Hi Experts,

I have to transform XML files from the IFS to CSV. In the past I did that with a XSL file and execute the next command from QSH;
java -classpath /QIBM/ProdData/OS400/xml/lib/xalan241.jar:/QIBM/ProdData/OS400/xml/lib/xerces411.jar:. org.apache.xalan.xslt.Process -IN file.xml -XSL file.xsl -OUT file.csv -TEXT

Open in new window

It seems that this command is no longer supported in V7R3, what is the alternative, to convert XML to a CSV or  a Physical-file
We have recently upgraded from V7R1 to V7R3 on a number of our IBM i servers.  Since upgrading, our user's job logs are being sent to their assigned printer when they log out of the system.  Does anyone know what system setting would have changed that is causing this to happen? I would like to set things back to normal ASAP.

I appreciate any insight into the issue!
In our as400 hardening doc, we currently allow 3 concurrent sessions per userid but our HQ new generic security policy recommends 1 session per Id

Was told that a user will require to run different types of jobs concurrently and often the jobs can take a while to complete even in our upgraded faster system I os400 v7 r2

What’s the practices out there?

CIS does not publish any hardening guide for os400
We have an issue right now where when our cust service team runs a credit card they at times receive a handshake error. We run a IBM i AS/400 that connects to a backend called Curbstone. Here is a break down of how this works Here is what is supposed to happen.

When credit cards are run curbstone opens a connection to paymenttech.
At this point the IBM I sends along “cipher suite, decryption keys” this information is accepted by paymenttech and the transaction continues.

Here is what is happening now.
Curbstone opens a connection to paymenttech.  At this point the IBM I sends along “cipher suite, decryption keys” this information is now rejected by paymenttech the transaction fails and the handshake error pops up. I have run a trccnn on the IBM i and in wireshark. Both curbstone and paymenttech don't see any issues on their end. I did call paymenttech today and a transaction that I saw on the IBM i didn't get to them resulting in the handshake error. I don't think its an issue with our network because it isn't a constant issue. I thought perhaps there was some job running at the time of the handshake error but that doesn't seem to be an issue. This issue ramps up at between 4pm and 6pm on Fridays. Why? I can't seem to find a reason.
When I try to SSH into our iSeries (V7R1) - I get the following error:

-bash: cannot set terminal process group (-1): No such device or address
-bash: no job control in this shell
-bash-4.2$ logout

I am using Putty to try to connect.

Anyone have any ideas what might be going on? I attempted to recycle the SSHD server (ENDTCPSVR *SSHD) but that didn't resolve the issue.


RPGLE programmer using IBMi v7r1, need to insert/update data on a MS SQL database easily. I'm familiar reading and processing ifs file using bnddir('QC2LE') in my RPGLE programs.
Surely there's a way to push records to an MS SQL server?
Hello Experts,

I have a RPGLE question concerning looping though field names instead of having multiple routines with each field name.

Exp.   I have field names FIELD1, FIELD2, FIELD3, etc.   I know in the past(I've been away from AS/400 for years) I would use a DOU loop something like this.

DOU I = 10
FIELD,I      CHAIN    FILE       99

How do I do that in RPGLE?

Keep up with what's happening at Experts Exchange!
LVL 12
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.


Been looking for reference material for the SQL for this system.

Connecting using app to query. Went to IBM site but pages are no longer available. What’s the best app to query the DB? Used winsql in the past for other work,


Dear Gurus

   I hope you're all doing great, I have a question regarding iSeries AS400 for Windows Macro/Scripting (Workstatin Program 6.0)

   As you probably know, there is a size limit for macro files (Not VBScript) and I'm building a user-friendly applet in excel that creates macro files

   In some cases there are lists of 6000 operations that have to be done, and mi Excel macro generates for example 220 AS400 macro files  (same number, all numbered)

saving screen for iseries for Windows emulator for macros
   Do you know which instruction may I use to call the "next macro" file in the text format?  "[wait app], [wait app inh], etc."

  Thanks as always for your wisdom

Hi Experts,

I have to start a remote job from As/400 using RUNRMTCMD, to run a program on a Windows 2012 server.
On some other servers  the program cwbrxd.exe is running, but this 2012 server has "Access Client Solutions" installed, so the cwbrxd.exe is no longer available.

I am aware that this cwbrxd.exe is a security risk, but is there an replacement for this service?
Or do I take an other direction to solve this?
Hi Experts,

After upgrading an as/400 (i5, iSeries, etc) from V7R1 to V7R3, is there a log available where I can find info about what is added, replaced and removed ?
We currently have our IBM ISeries configured to send email thru our on premises Exchange 2013 server. The internal IP of the Exchange Server is and I have a corresponding Host Table Entry on the ISeries pointing to that ( On the Exchange Server I have also setup a FrontEnd Receive Connector with the scope set to the internal IP of the ISeries ( Everything works well and has for years.
However, we will be moving from hosting our Exchange on premises to using Rackspace's hosted Exchange and I was unsure how to route the email from the ISeries to Rackspace?
How to read a flat file and get data in as400??

IBM System iSponsored by Flatiron School

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.

Top Experts In
IBM System i