Using the SQL Features in Operations Navigator

September 15, 2004 Joel Cochran

A couple of years ago, I fell in love with SQL. Okay, maybe not in love, but definitely in appreciation. Initially it was a hate/hate relationship. Like most people in RPG land, I had been weaned on native file access and was shocked to discover as I ventured into languages on other platforms that there really is no equivalent. I learned SQL out of necessity, and in the process I’ve become a true believer, even something of an SQL evangelist within my tiny sphere of influence. This article introduces you to using some of the SQL features available in Operations

XML Validation with Regular Expressions

September 15, 2004 Hey, David

The code for this article is available for download.

I want to set the date field in a schema to YYYYMMDD format and use this to validate an XML document. Will I have to have to write any Java code to support this? I also want to set the format of an amount to numbers, with 18 digits followed by 3 digits decimal value. The separator can be either a comma or a decimal point.

–Satish

From your description, it looks like you can use XML Schema’s pattern-matching capability. With pattern matching, you supply a regular expression that is

Admin Alert: Three Ways to Tighten OS/400 Security

September 15, 2004 Joe Hertvik

No matter what type of OS/400 shop you run, chances are good you can tighten your password and sign-on security. On i5, iSeries, and AS/400 boxes, this is a relatively easy thing to do; you just need to know your options and set security values accordingly. To that end, here are three easy ways that OS/400 can help you to tighten your system security.

Before starting, I should note that these values can be changed either through a green-screen 5250 session or through the graphical iSeries Navigator interface (still sentimentally referred to as OpsNav). To view and change these values