• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Use Field Names for Column Headings

    May 11, 2005 Ted Holt

    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.

    –Danny

    Danny is referring to files that are created with DDS, although column headings may also be defined with SQL’s LABEL ON command. Here’s an example of a few fields with defined column headings.

    A                                      UNIQUE
    A          R CUSTREC
    A            COMPANY        3P 
    …

    Read more
  • Viewing and Printing the Euro Symbol

    May 11, 2005 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.

    First, set up your 5250 session to allow the display of the Euro symbol.

    …

    Read more
  • Scanning QSYSOPR for Selected System Messages

    May 11, 2005 Joe Hertvik

    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?

    –Mike

    The simplest way to do this is to scan the system history log for message CPF2234, which tells you when a user tries

    …

    Read more

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • LANSA Developing Business Intelligence Tool
  • Blazing The Trail For VTL In The Cloud
  • Data De-Dupe Gives VTL Customers More Options
  • Four Hundred Monitor, March 29
  • The Big Spending On IT Security Is Only Going To Get Bigger
  • IBM Tweaks Some Power Systems Prices Down, Others Up
  • Disaster Recovery: From OS/400 V5R3 To IBM i 7.4 In 36 Hours
  • The Disconnect In Modernization Planning And Execution
  • Superior Support: One Of The Reasons You Pay The Power Systems Premium
  • IBM i PTF Guide, Volume 25, Number 13

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2023 IT Jungle