AS400,iSeries,i5 etc Blogs

AS400, iSeries, i5OS – Whatever you want to call it, tips, tricks and how to guides.

How to automate IBMi data export to CSV

How to automate IBMi data export to CSV

The CPYTOIMPF command seems to ignore the PCASCII parameter. This blog explains how to fix this issue and export data from IBMI to ASCII CSV successfully from the command line or CL program.

AS400 Operating System Introduction

AS400 Operating System Introduction

So what makes the AS/400 Operating System so special? The AS400 Operating System is one of the most modern Operating Systems in wide spread use today.  I was at an interesting talk given by Doctor Frank Soltis the chief designer for the IBM AS/400 and the IBM System...

iSeries SQL failing to use an existing index.

Why would a perfectly good SQL based application which has been running well for years suddenly start to run slowly? It's easy for us iSeries users to forget about database administration because the OS/400 or i5/OS does such a good job of managing this for us. From...