db2.sh: A Command Line Interface for DB2 on IBM i

Recently starting the IBM i BASH Tools repository has prompted me to think  of some scripts that would be useful. One that I have wanted for quite awhile is a Command Line Interface (CLI) for DB2 on the IBM i. Calling DB2 from Command Line Calling DB2 from the command line is done in the…

Writing Helpful BASH Scripts for IBM i

I feel like BASH is sometimes an overlooked tool these days. Writing scripts is simple, and a script can create efficient command line interfaces to achieve tasks that would normally take a lot longer. A great example of this is starting, stopping, and restarting Apache on the IBM i. For those of us not accustomed…

IBM i Open Source Tools

IBM i Open Source Tools were originally installed via a complex process of installing packages from Perzl. I have described how to do this in past posts such as BASH on IBM i. While this was helpful in the past, it wasn’t officially supported by IBM. 5733-OPS is a new product from IBM that supports…

Apigility RPC for IBM i DB2

Apigility Setup This example assumes a setup similar to the one described in Installing and Using Apigility on IBM i. The example repository can be found on github. Create New RPC Create a new RPC through the Apigility Admin Interface like normal. This will generate a Factory and Controller for the RPC service. Once that…

LoopBack on IBM i

loopback-connector-db2ibmi is still pre-pre-alpha. Use with caution. Installing LoopBack This uses loopback-cli in order to create a LoopBack Project. That is the lb command seen below. A list of loopback-clicommands can be found here. The commands above in order are simply:

This will give us everything we need to begin making an API. To start with,…

How to Add Filtering to Apigility

Setting Up Apigility This guide will be using the same project setup during my Apigility Entity & Mapper Tips article. The related github repo has been updated with the new source in this article. Create a Filters Class I found the best way to stay organized was to create a type of Helper Class called <ServiceName>Filters….

Apigility Entity & Mapper Tips

Create a Simple Schema and Table To get us started, we’ll need a source of data for our service. I’m going to use IBM i DB2 for this example, since that is primarily what I work on. Below is SQL to define a simple table and populate it with some data.

If all ran…

Installing VirtualBox Guest Additions on CentOS 7

Download & Attach VirtualBox Guest Additions Download the appropriate version of VirtualBox Guest Additions. The latest would be VBoxGuestAdditions_5.1.20 at the time this article was written. Go ahead and attach the VirtualBox Guest Additions ISO as a device to the virtual machines storage. This is basically emulating a CD being inserted into our virtual machine….

CentOS 7 + i3wm Quickstart Guide

Most commands will need to be ran with super user permissions. Just prepend with sudo if any permissions errors occur. Download CentOS 7 Download the preferred version of CentOS. I suggest the “Everything” version for this tutorial. Install CentOS 7 Begin the installation process like any other Linux installation. Either through USB or Virtual Machine. Installation…

Pretty BASH Configuration with IBM i Helpers

Making BASH Your Default Shell There are (at least) a couple of different ways to achieve having BASH on login. sshd_config – Globally (not recommended) This will make it so anyone that SSHs in will have BASH at login. More information can be found here Edit sshd_config (usually found at /QOpenSys/QIBM/UserData/SC1/OpenSSH/etc/sshd_config) to have the following:

.profile –…