HOW TO UPLOAD SAVF to IBM i Systems If you don’t use FTP anymore (or if FTP has been blocked by your network team) the easiest technique is to upload your SAVF to your IBM i’s Integrated File System and then copy it direct into a *SAVF — using IBM I Access Client Solutions. Launch […]
More Waffle
IBM i , IFS , iSeries , Programming
I was updating a little RPG utility this morning to add some more detail to a spreadsheet it generated. Adding the Library Description will help the non-propeller heads who read this stuff. This is super easy to do with a single line of SQL added to your RPG program. What is this spreadsheet you are […]
More Waffle
Some of IBM’s error messages are more cryptic than others. Copying files from the IFS using CPYFRMIMPF sometimes spits out error messages which are less than clear: CPYFRMIMPF FRMSTMF(‘/FOLDER/FOLDER/FILE’) TOFILE(*LIBL/FILENAME) MBROPT(REPLACE) RCDDLM(LF) STRDLM(NONE) RMVBLANK(NONE)FLDDLM(TAB) ERRRCDOPT(REPLACE) RPLNULLVAL(FLDDFT) File system error occurred. Error number 3021Copy command ended because of error. Internet Search for CPYFRMIMPF 3021 shows nothing! […]
More Waffle
IBM i , AS400 , IFS , iSeries , SQL
A little while ago, I wrote a data obfuscation tool – which I decided to call Data Fogging. This is specifically to solve the data privacy problems that we face when we want to suck down real data from production environments to our development and Test/QA boxes. Obviously we don’t want to implement any real […]
More Waffle
IBM i , IFS , Programming
Colleague asked me this question just a minute ago – as he said “its obvious when you know how but not when you dont” Simply use the IBM i RNM command: Personally, I find this command syntax a little annoying: fully qualifying the FROM string and then just using the unqualified NEW file name in […]
More Waffle
AKA – How to copy IBM i IFS folder and all subfolders and documents to a new Location I just upgraded a clients PRESTO Server to the current version 8.1 What is Presto? It’s commonly called an IBM i Modernization Application : Essentially transforming the old fashioned AS400 style Green Screen terminals to modern Webstyle […]
More Waffle
IBM i , IFS , Programming
An interesting question was lobbed at me this morning – “How can I change the data change timestamp in an ifs file?” One of the good folks over at Tire Rack (the software developers, not the blokes that change the tires) asked if I knew a way to update the timestamp for the data changed […]
More Waffle
IBM i , IFS , Programming
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
IBM i , IFS , Programming
So, yesterday I added a neat little snippet to my Control Language Program on this #IBMi system, and re-awakened an irritating feature thats bitten me before. I slept badly last night with this problem niggling away in my brain. But awoke to a bright chilly Las Vegas morning with a steamy coffee and a solution […]
More Waffle
IBM i , AS400 , IFS , iSeries , Programming
This morning I wanted to find a quick and dirty way to “Scan Replace text in IFS” files without writing a program to do it…. SPOILER ALERT – it’s really really insanely simple using JAVA QSHELL and the SED command So, before I start into techno-babble mode, here is some background of why I’m looking […]
More Waffle