All Posts by NickLitten

Follow

About the Author

IBM i Software Developer, Digital Dad, AS400 Anarchist, RPG Modernizer, Alpha Nerd and Passionate Eater of Cheese and Biscuits. Nick Litten Dot Com is a mixture of blog posts that can be sometimes serious, frequently playful and probably down-right pointless all in the space of a day. Enjoy your stay, feel free to comment and in the words of the most interesting man in the world: Stay thirsty my friend.

Sep 11

Innies, Outies in SQL #bellybuttons

SQL

Going for the Guinness Book of Records for vague blog titles I decided to waffle about inner joins and outer joins in the world of bellybuttons *cough* Structured Query Language. Since plagiarism is the best form of flattery, Chirag Sharma (over at Guru99) wrote a very nice article about the finer points of SQL INNER […]

More Waffle
Aug 18

Going the (Levenshtein) Distance in RPG Free

IBM i , Programming

Over on the RPG Cafe website, a nice chap called Smit Dixit published a sample of his RPGLE code calculating the Levenshtein distance between two words. What is the Levenshtein Distance? The Levenshtein distance is a string metric for measuring difference between two sequences. Informally, the Levenshtein distance between two words is the minimum number […]

More Waffle
Jul 29

5733XJ1 IBM i Access Client Solutions – QuickStartGuide

IBM i

The content of this document was last updated on: March 29, 2019 Contents: 1.0 Introduction2.0 Installation for Windows3.0 Installation for Mac4.0 Installation for Linux5.0 Installing Updates6.0 More Information7.0 Uninstall 1.0 Introduction This guide provides instructions on how to deploy this product on a local disk drive for a single user. There are a variety of […]

More Waffle
Jul 08

IFS File system error occurred. Error number 3021?

IBM i , IFS

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
Jul 03

How to rename IFS Files

IBM i , IFS , Programming

rename IFS Files

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
Jun 29

How to copy IBM i IFS folder

IBM i , IFS

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
1 2 3 61