Many months ago, when I needed to create and execute an ad hoc query using SQL, my tool of choice was Interactive SQL, available via the System i green screen interface. I don’t recall any dramatic change taking place–I suspect it was gradual–but these days I find myself using Run SQL Scripts (a.k.a. SQL Script Center or Script Center) from System i Navigator, instead of Interactive SQL, to execute an ad hoc SQL Query.

The Script Center offers a couple of advantages over Interactive SQL. Specifically the Script Center allows you to intermix and execute SQL statements and batch CL

There are a lot of shops like mine where one or two people are responsible for everything and we are very busy trying to learn new technologies and push the business forward. My project is very large. It will eventually replace 90 percent of the green-screen menu driven system we currently use. I am working on this project alone and building it slowly from the ground up. I want to have a well-built base. I want to understand how .NET and DB2 work together before I start building a lot on top of the base program. I am working with

We just ghosted and sent out 20 new PCs with iSeries Access for Windows V5R4M0 on them. Now we’re getting complaints that the Popup Keypads on the new machine’s PC5250 display sessions aren’t working correctly. On the old PCs, we had three Popup Keypads available to the users. The new PCs only have two keypads and some of the functions are missing. What’s going on?

–Beth

I suspect your problem isn’t so much that things have changed; it’s that the Popup Keypad configuration went back to its default settings with the new install. Here’s what I think happened.

For readers