IBMi WRKRDBDIRE- I want data from that box.. A bit of background to start with today, I’ve recently been learning how to setup NodeJS on IBM i (again big plug here for Andy Youens series to get you started.) After completing a few tutorials, I started looking at pulling data out of the local tables using the
IBMi A NodeJS Website on IBM i - Database Access Continuing my Node.js website on IBM i, in this article I’ll show you how we can access a file/table and display the results on a web page all neatly formatted. We will take our employee table, do some record selection and sort for a certain order. Before
IBMi How to get the Latest and Greatest Within a few days the latest Technology Refresh for IBM i 7.4 and 7.3 will be available. The official planned availability day is 15 November 2019. For details please have a look at these two links IBM i 7.3 Technology Refresh 7 and IBM i 7.4
IBMi IBM Must Gather Tool – Your Best Friend In Times Of Trouble Oh no! and just when everything was running so well. There’s a problem with the system and you have logged a Problem Management Report (PMR) with IBM. You get a response from IBM asking you to manually collect all kinds of disparate information from areas of the system you
IBMi A Worldwide Marketing Manager for IBM i, that’s sounds Champion! PowerWire.eu had the pleasure last week to interview the newly appointed, Worldwide Head of marketing for IBM i, Brandon Pederson, who had kindly given us some of his time out of his day to answer a few questions. PowerWire: Brandon, for our readers who don’t know about you
IBMi Download Director - now with less Oracle For those of you who haven’t already read it, I’d highly recommend starting with Steve Bradshaws article “Do I need to pay for Java?” from January. After following the setup guide on the IBM site so that I was using OpenJ9 I was left with the question “I’
IBMi A NodeJS Website on IBM i – The Secure Version Now we have our basic Node.js website up and running, let me show you how easy it is to make it a secure site. By secure, I mean making the transport layer secure, ensuring the site uses Secure Sockets Layer (SSL) to ensure all communications between the client and
IBMi F8 – Back to the Future II GREAT SCOT !! No I’m not talking about Mr Forstie but of course borrowing from Doc Brown in the Movie Back to the Future. This is something he would say whenever he saw something incredible. Now that is exactly how I felt when I was shipped a test PTF by
Featured Time to Say Byebye to the POWER7+ Those of you with first generation POWER7 processor (the models that end in B & C) will be all to aware that on Monday this week (30th September 2019) IBM ceased their mainstream hardware support for these models. Some of you will of managed to negotiate and EOS Extension of
IBMi Who invited SYSMSG Another in my catalogue of “everyone and their mother has done this if they needed to, but here’s a slight twist on it” articles. To set the scene, a customer of mine decided they want their Power server in an enquiry state and so setup some new generic profiles
IBMi A screen a Story Being a system administrator in the GUI era, it seems almost impossible to ignore the IBM i GUIs. Having said that it is my experience that a lot of sysadmins try to ignore those GUI, which were not part of day-1, when they started working. They are, as would I
Featured Tic-Tock, Tic-Tock; time's running out for IBM i 7.2 IBM announced on the 10th September that you will be able to order a 7.2 version of IBM i until the 30th April 2020, and with the announcement came the news that support for the 7.2 will also cease on the 30th April 2021. However you can upgrade
AIX IBM i & AIX now available on Microsoft Azure and Amazon AWS Clouds From the start of this year there have been a few announcements that came across my desk and caught my attention about IBM i, AIX and Linux being available on Microsoft Azure and Amazon AWS Clouds, and I thought I would condense them down and show them here. Why? Because
IBMi Leaving SEU behind - ILEditor After sitting in a number of the SiD sessions at the international i-Power event this year, one key fact I took away is “you really need to get off SEU.” However, I’m a little cost-averse so can’t quite justify jumping straight to RDi, luckily the open source community
IBMi PRUV Tool Upgrading your system to a new release of IBM i can be a worrying process with many items to check before taking the plunge. The IBM Pre-upgrade verification (PRUV) tool can help with this process by checking through all the IBM mandated pre-requisite tasks before you start the actual upgrade.
IBMi VS Code - An OSS IDE In my previous articles on IBM i Open Source, I’ve briefly mentioned Microsoft Visual Studio Code. So, in this article, let me show you what it’s all about. What options do we have for editing our source/applications that reside on our IFS? * IBMs RDi (Eclipse based) * Zend
IBMi Node-red on i – 5733OPS not required Inspired by Andy Youens series of articles on Node and Open Source on IBMi, I decided to try setting up Node-red on one of my servers. I’ve also got to give credit to a post on the IBM developer site: https://developer.ibm.com/tutorials/i-running-node-red/ The main difference
IBMi "What am I letting myself in for?" “What am I letting myself in for? “ One of many thoughts going through the mind of the Aspie on his way to the i-power event in the middle of his third minor panic attack. Maybe not the intro you’re expecting, but I’d like to talk now about why
IBMi SMBv3 support in IBM i 7.4 Those of you that spotted my article on what’s new in 7.4 back in April (if you missed it, click here to read it now) may well remember I was quite excited at the prospect of SMBv3 in 7.4. And yes, I realise just how sad that
Featured Node Project - iDash In this article I will take you through part of my Node.js workshop that I presented at the UK International i Power conference in June 2019. The workshop was called ‘From Zero to Production with Node.js’. I hope those that attended enjoyed the workshop and found it beneficial.
IBMi HMC's - descriptive errors optional I’ve been having great fun recently trying to upgrade one of my HMCs and figure I shall now share with you all the woes in the hope that the next person to have this problem can find the solution a little easier. If you read all the way through
IBMi Ping unto eternity A slightly pretentious title for an article that doesn’t deserve it, but you must indulge yourself every so often. If you’ve ever used the PING command from a windows command line I imagine you’re familiar with the -t option that will leave it running until you have
IBMi Programmers Comments This is a light hearted article this month while I prepare for my Node.js on IBM i workshop at the UK International i Power conference 2019. Over the 40 odd years I have been programming, I’ve come across some fantastic comments in source code. They certainly make code
IBMi ‘i’ will emPOWER the new generation of techs For as long as I can remember, the Holy Grail of IBM i computing has been to engage with the younger generations and to bring them into the safe and secure IBM i fold; and it has been a tough journey. Until now! This just got a whole lot easier!
IBMi IBM i Security Best Practices – Presented by Jeff Uehling Security best practices and regulatory compliance are a constantly moving target. In this webinar, Syncsort’s Product Management Director for Security Solutions, Jeff Uehling, shares what he’s learned over the past 30 years regarding IBM i security best practices. Key topics include: * Why you need to run at security
