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 WaffleIBM 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 WaffleIBM i , AS400 , iSeries , Website
So, I just did an upgrade of the BCD Software GUI Client (now owned by Fresche Legacy by the way) for a client. This upgraded their older version of Presto to PRESTO 8.1 Server. This also comes with a new Presto Client and Screen Designer adding some nice new tweaks. Compulsive Library Naming Tendencies The […]
More Waffle
Unicom (who bought out ‘Softlanding Systems’) recommend upgrading to TURNOVER V101 before implementing iASP technology. The main thing to remember is that you need to set your job, or session, to use the iASP before going into TURNOVER. You can do this by controlling your job with the JOBD ASPGRP or by issing a command […]
More Waffle
The independent auxiliary storage pool (IASP) is the strategic building block for availability on IBM i. There is a lot of mythology around migrating to an IASP environment, and some extremely wild estimates about the complexity of migrating. The reality is usually considerably easier than most people would imagine! IASPs can be used as a […]
More Waffle
By default, the IFS lives in the *SYSBASE ASP. But, we can move the IFS Directories, and all documents therein, to the iASP location easily: Let’s assume your ASP is called ‘my_iasp’ 1) Vary on iASP WRKCFGSTS CFGTYPE(DEV) CFGD(ASP) 2) Create your new directory on the iASP, if it doesn’t already exist CRTDIR DIR(‘/my_iasp/dir_name’) 3) […]
More Waffle
Many IBM shops have FTP locked down for supposed security reasons. But before I start ranting about sloppy security measures in IBM-i shops all over the world; locking down things like FTP while leaving file uploads wide open, *public rights on file shares, inherited authority on commands line access, SQL scripts that are just waiting […]
More Waffle
I got the SNIP recently, but that’s whole different story to this very boring technical one… How to assign a keyboard shortcut to the Windows Snipping Tool I’ve been using the windows snipping tool a lot recently — to capture various 5250 screens and document them. I just remembered how to setup the tool against […]
More Waffle
I was emailed a little IBM i programming question this morning: An input parameter @Account is a 100 character string for one to x number of 8 digit accounts separated with a comma (,). Each account can be entered with commas between each account. Example: The string @Account could be “123,00574, 12,142 … “. Spaces […]
More Waffle