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,iSeries,i5 etc Blogs
AS400, iSeries, i5OS – Whatever you want to call it, tips, tricks and how to guides.
AS400 Operating System Introduction
So what makes the AS/400 Operating System so special? The AS400 Operating System (also known as AS 400 System) is one of the most modern Operating Systems in widespread use today. I was at an interesting talk given by Doctor Frank Soltis the chief designer for the...
How to find the Tech Refresh Level on IBM i (iSeries, os400, AS400 etc)
I've just updated my blog about how to find the OS/400 version you have installed on IBM iSeries to also cover how to find the tech refresh level on IBM iSeries (os400). This was prompted by a comment left on the blog. We do love to hear back from you and have...
How to delete or change DB/2 SQL Stored Procedures with duplicate/same name.
Using DB/2 for IBM i (aka IBM AS/400 or iSeries) I was trying to drop a stored procedure using the command DROP PROCEDURE TEST/TEST_FTP; But was getting a message Message: [SQL0476] Routine TEST_FTP in TEST not unique. Cause . . . . . : Function or procedure TEST_FTP...
How to find out what version of OS/400, AS/400 (IBM iSeries / IBM i) Operating System you have installed.
This brief article explains how to quickly find what version of the AS/400 OS/400 Operating System you have installed on your IBM iSeries, i5 system.
AS400 Command Cheat Sheet (aka iSeries and IBM i)
My IBM As/400 (IBMi) FAQ and Command cheat sheet.
How to find what version of JDE World (J D Edwards ERP) is installed.
I thought I'd write this up as a quick post because this is one of those things I always forget how to do. I'm sure in earlier versions there used to be a menu or screen that showed the version number but when I needed to do this last week I couldn't find any trace of...
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...