Error Checking and Embedded SQL
Hey, Ted:

We are still new to the world of embedded SQL. We are still trying to determine how to check for success or failure of SQL commands. So far we have determined that we should use the SQL code and SQL state variables, both of which seem to serve the same purpose. Can you give us some direction? READ MORE >

Query/400 Does Exponentiation,
Sort Of
by Ted Holt and Bob Ellsworth

Query/400, the software IBM never got around to completing, does not have an exponentiation operator, but that did not stop Bob Ellsworth from making Query carry out exponentiation. If you've seen Bob's tips before, you may remember that Bob is the guy who makes Query do what it was never designed to do. Here's the technique Bob shared with me to answer a question from a reader. READ MORE >

   Admin Alert: A Better Technique for Detecting Invalid Log-In Attempts
   by Joe Hertvik

Recently, I wrote an article explaining how to monitor the OS/400 history log, QHST, for invalid log-in attempts. No sooner had that issue of Four Hundred Guru hit the Web than I received a reader email that contained an excellent suggestion for finding even more invalid log-in attempts than I had found with my technique. Here's the scoop. READ MORE >

Reader Feedback and Insights

We value your feedback and insights. Feel free to send a letter to the editor. Letters may be printed, unless otherwise specified, and edited for clarity or length. READ MORE >

WorksRight Software
Advanced Systems Concepts
Guild Companies