• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • What Can I Select When I Group?

    April 25, 2007 Dear highly esteemed professional colleague

    It’s not uncommon for someone to ask me for help with error SQL0122, which involves SQL commands that use the GROUP BY clause to produce summary figures. Since I see this error over and over and over, I thought it would be good to explain how summary queries work. The standard rule I hear is that the SELECT clause of summary queries can list aggregate fields (those in the GROUP BY clause), expressions that are in the GROUP BY clause, and column functions, such as COUNT, SUM, and AVG. That’s close, but slightly inaccurate.

    A reader who contacted me recently

    …

    Read more
  • To Shift or Not to Shift: That Is in the Fourth Parameter

    April 25, 2007 Ted Holt

    RPG’s %REPLACE function is marvelous. When I think of all those array-manipulation calcs I wrote in my System/34 and System/36 days, I could cry. Anyway, to use %REPLACE effectively, it is good to ask oneself a simple question: In the event that the replacement string and the string of characters that is being replaced are not the same length, do I, or do I not, want the characters that follow the replacement to shift?

    This is the same question SEU asks on the Find/Change Options panel. Informing SEU of your desire is an almost effortless matter of typing a Y

    …

    Read more
  • Admin Alert: Dealing with i5 Critical Storage Errors,

    April 25, 2007 Joe Hertvik


    Part 1

    Critical storage errors can occur whenever i5 hard drive usage passes 90 percent of available storage space. Above 90 percent, system performance starts to degrade. When storage usage breaches 95 percent, the system can become unstable and turn itself off or spontaneously reboot. While you can’t predict when critical storage errors will occur, there are several things you can do to detect and cleanup storage problems before they crash your system.

    What’s the Disk Facts, Jack?

    This week and next week, I’ll deal with the issues involved in monitoring and correcting critical storage errors or storage overflow conditions.

    …

    Read more
  • The Long and Short of Setting Up Level 40 Security

    February 14, 2007 Hey, Brian

    We are at security level 30 in i5/OS and we have been told by our auditors that we need to move to security level 40. What are some of the benefits that we will see going to level 40, and is it as simple as changing the QSECURITY system value? Some of what I read tells me I have to start journaling in order to see if I can run at level 40, but then it says I can go to level 40 just by changing the system value. What is the real answer here?

    –Bob

    Besides all of the

    …

    Read more

Content archive

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

Recent Posts

  • Unattended IBM i Operations Continue Upward Climb
  • VS Code Is The Full Stack IDE For IBM i
  • Domino Runs on IBM i 7.5, But HCL Still Working on Power10
  • Four Hundred Monitor, March 6
  • IBM i PTF Guide, Volume 25, Number 11
  • You Ought To Be Committed
  • Thoroughly Modern: What You Need to Know About IBM i Security
  • Spring Brings Events To IBM i Community, And More
  • As I See It: AI-AI-O
  • IBM i PTF Guide, Volume 25, Number 10

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