Tag Archives for " #as400 "

Dec 05

Cleaning messy IBM i Integrated File System (IFS) file names

This morning I had an email from a blog subscriber ( Hi Rick! ) asking for a code tips on how to cleanup IFS file names to remove erroneous characters and/or malformed directory name slashes. Rather than reply with a plethora of programming options — here is an old, but functional, RPG code snippet that […]

More Waffle
Oct 04

Email every spool file in an output queue – EMLOUTQ for IBM i

Email an OUTQ – should be simple? Here you are, you have this output queue filled with reports and you want to email them to your Boss/Colleague/whoever! You dont really want them in smelly old text format you want them to look nice in something like PDF format…. That should be easy right? IBM i […]

More Waffle
Aug 16

Send IBM i Email including SQL Table Data automatically

Have you ever wanted to extract some data out of an IBMi/AS400 file using SQL and then email that data to someone as an Excel Spreadsheet? Now you can… all from one IBMi command without having to write any CL code to do it. Projex4i: DSTDTA command now handles SQL STRINGS for selecting data   […]

More Waffle
Aug 15

I remember the IBM AS400

Discussing a data interchange process with a software vendor today (who shall remain nameless), they told me that their product could talk to an AS400 but had no experience of iSeries or IBM i…. *sigh* I am not telling you the company name because I don’t wan to  to embarrass them in public… but if […]

More Waffle
Aug 11

How to ZIP AS400 library and Email it

Now, before you get all bent out of shape and point your grubby little index finger at me cackling “you called it an AS400 na-na-nu-na-naaah“, I do have a legitimate reason. It’s a shallow SEO based one (the grey haired brigade keep searching for “zip AS400 library”) but it’s legitimate. I only used the wrong […]

More Waffle
Aug 04

Interview Question and Answer – AS400 iSeries

Twenty years ago these are the kind of things you had to know to work on the old AS400 systems. I found these on an old dusty corner of my homeserver. Enjoy the trip down memory lane or to use old RPG lingo AS400NERD CABEQ ‘1’  START AS400 Questions What is the Configuration of the […]

More Waffle
Jul 19

AS400 Modernization starts with Modernizing RPG Applications

RPG Modernization

Modernizing RPG Programs – Learn the RPG History first I had email email from an old work colleague this morning. He was a windows programmer, with limited exposure to RPG, but works in a company that is driven by a huge, old, complex RPG3 application that has changed little over the last decade. He is […]

More Waffle
Feb 22

Download and Install IBM i ACS (Access Client Solutions)

RDi 9.6 powered by coffee

Client Access is DEAD – get over it! Client Access was much reviled, much loved and mucho mucho confusing for users of AS/400, iSeries and the newer IBM i Power Systems. As it evolved and got rebranded as IBM i Access with new releases of the operating system, many people from the technical end of […]

More Waffle
1 2 3 4