From AS/400 to iSeries to System i to IBM i on Power
Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
IBM i, IFS, Programming, SQL
Not dying users, you big silly! Are your IBM i Users Passwords Expiring? Every IBM i User Profile can be created with an automatic expiration date set against it. This forces regular password changes. Pretty standard stuff right? This is rarely a problem for interactive users – who will see the change password screen: But, …
IBM i, IFS, Programming, SQL
How to delete first few rows from a file with IBM i SQL This morning I was working with a flatfile import from IFS into a DB2 database file. This should have been straight forward but the flat file contained several rows of crappy data at the start of the file. *ugh* Since I am …
AS400 DLS vs. IBM i IFS Do you work at a company that has people using the AS400 DLS? Do you work at a company with techies talking about the iSeries DLS? Do you work at a company that uses the IFS and the DLS? Are you confused about if your business server is an …
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 …
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! …
IBM i Data Obfuscation – Making Data Foggy Murky and Squinty 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 …
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 …
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 …
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 …
Talking to a colleague this morning, we were discussing a vendor supplied series of spreadsheets (in CSV format) that his team needed to process. “What’s the best way to read all the spreadsheets in an IFS folder so we can process them?” bald bloke in the office Well, we have a nice simple technique to …
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 …
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 …