In my previous tip, I introduced i Projects and some ways in which I use them in my development life. In this tip, I’ll show you how to create and populate your projects, and how to make use of them.

Let’s first create an i Project. The easiest way to get started is to go into the i Projects perspective that is built in to RDP. WDSC also allows for the use of Projects, only they are called “iSeries” Projects. If you’re new to the tool and haven’t mastered opening a perspective, there are many ways to do it.

One potentially confusing aspect of programming SQL in DB2 for i for non-IBMers is the use of the forward slash character to qualify an SQL object with a schema. IBM i devs don’t have a problem with the slash because we recognize it as the character we use when qualifying objects while tooling around the i/OS green screen. Others database devs may wonder what sophisticated function the slash serves. However, in IBM i 7.1, IBM introduced a change in DB2 Group PTF SF99701 Level 15 that is worth noting.

When using the system naming convention, developers can now

We’re cleaning up some of our IBM i operating system user groups and we need to remove 100 users from a group profile. Is there a way to do that without having to go into each user profile and individually remove their group memberships? We also need to delete some of the group profiles themselves. I’m on i 6.1.

–Jack

This is really easy to do if you use the System i Navigator (OpsNav) program that comes with IBM i Access for Windows V7R1M0. Here’s how to use OpsNav to: 1) remove a group of users from an IBM i