Get Sysname using SQL The IBM i System Name is not the same thing as the SQL Local DB Server name, although it may be the same by default. You can retrieve the SQL Local DB Server name using this SQLRPGLE code snippet: exec sql values current server into :systemName; If systemName = ‘my-ibm-i-system-name’; do

Read More

I was reading an interesting thread on Linkedin this morning, discussing another article about the much loved AS/400. The basic storyline is (a) some chap says the AS/400 is a really neat computer and he’s very pleased to have worked on it for many years (b) other chap says “its not called an AS/400” anymore (c)

Read More

Ever created an IFS file with a whacky file name? As part of my testing routines for the new IBMi Data Distribution commands (DSTDTA and DSTSPLF) I was creating and testing all kinds of documents in the integrated File system. Taking any file from the good ole iSeries and converting it to TXT, PDF, XML,

Read More