Use Field Names for Column Headings
Hey, Ted:

SQL/400 SELECT statements use the column headings that are stored as part of the file description when displaying or printing data. Sometimes I prefer to see the field names themselves used as column headings. I have found one method to make SQL use field names as column headings, but I wonder if you know of a better one. READ MORE >

Viewing and Printing the Euro Symbol
by Dale Downing

I recently needed to print the Euro symbol (€) on some of my spool files. I found that this was not a standard capability. My default system value for character identifier was set to 697 for the graphic character set and 037 for the code page. These settings are not Euro ready. So, how can I print the Euro without changing my system value and worrying about what negative affects this might have on other installed software? This can be accomplished with a few simple steps. READ MORE >

   Scanning QSYSOPR for Selected System Messages
   Hey, Joe:

In your article "Bullet-Proofing User Profiles," you talk about scanning the QSYSOPR message queue. Is there a way to scan for selected system messages, such as failed sign-on attempts, or do you have to review your logs line by line? I suspect that I have a user who is deliberately disabling user profiles by typing in a garbage password three times in a row, but I can't prove this is happening. Do you have any ideas? 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 >

Advanced Systems Concepts
WorksRight Software
Linoma Software