In case you haven’t noticed, IBM’er Tim Rowe and his team have been delivering a tremendous amount of open source the past few years–sometimes through vendor relationships and sometimes directly from IBM. While frequency has increased as of late, open source has actually been a mainstay on IBM i and its predecessors for a very long time. It started with the Apache web server, then Java, then PHP and MySQL, Ruby, Node.js, Python, and even more you haven’t even heard of. Open source (in particular Node.js) will be the topic of this article. But first, let me give you some

Note: The code accompanying this article is available for download here.

Today I follow up on a topic that Susan Gantner covered a few years ago, namely, how to more easily manage the library list while working in Rational Developer for i (RDi). It turns out that a couple of commands I wrote for green-screen work years ago are even more useful in my GUI development environment.

When you start RDi, the library list is set according to your user profile, but you can override the initial library list in the connection properties. As you work, you may

In the preceding two articles, we saw how to extract, analyze and correct table and column definitions. In this, the final article on refacing your database, we look at some more options for re-representing data and, finally, generating a script to create the required views.

Handling Numeric Date Fields

One of the issues we need to handle is the representation of dates in the SASALHST table. Figure 1 shows how the purchase date is stored as a numeric field, the order date is stored as a year, month and day and the delivery date is stored as a century, year,