IBM i, AS400, iSeries, Programming, SQL

Modernize AS400 iSeries Query – Convert to IBM i SQL

Convert QUERY to IBM i SQL This week I be mainly…. working on a Casino System upgrade, dragging decades old code into the twenty first century. Old RPG3, RPG400, CLP programs and techniques using outdated OPNQRYF and QUERIES are fighting back tooth and nail. I love this schnizzle. 🙂 One of the techniques for upgrading/converting …

 Read More

IBM i, Programming, SQL

AS400 QMQRY – Query Management Queries

So, I was emailed the following hints and tips document discussing the ubiquitous Query Management Query object type on the IBM Power Server (the artist formerly known as AS400). It’s useful to refer to so, here it is: QMQRY – QUery Management Query A SOURCE FILE FOR YOUR QUERY The key to making a query …

 Read More