• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Handling Constraint Violations in RPG

    February 17, 2010 Paul Tuohy

    Constraints have been around for a long time but have not quite made it into every programmer’s tool kit. This is partly explained by the fact that implementing constraints in an existing application can be tricky–but it doesn’t explain why constraints are not used extensively in new applications.

    On a side note, the lack of constraints on a database is one of the reasons I have heard why data should be moved/copied from the i to other database servers, such as SQL server and Oracle, for such things as data warehousing. To a “pure database person,” a lack of constraints

    …

    Read more
  • CPYTOIMPF Doesn’t Create Column Headers, But You Can

    February 17, 2010 Hey, Ted

    If I use Copy to Import File to build a CSV file in the IFS from a database file, I get data, but no column headings. Lack of column headings confuses the poor soul that opens the file in Excel. Do you have an easy yet effective way to address this omission?

    –Robert

    What you need is an easy way to stuff column headings into the stream file before you add the data. Here’s one method:

    • Create a one-record table.
    • Use a file editor–even DFU will suffice–to key in the quote-delimited, comma-separated headings.
    • Use CPYTOIMPF, specifying MBROPT(*REPLACE), to copy the
    …

    Read more
  • Admin Alert: Six Things Power i Administrators Need to Know

    February 17, 2010 Joe Hertvik

    To become an effective i/OS system administrator, you need to access a lot of information. This week, I’ll look at some of the more valuable pieces of information I frequently use to service my Power i systems and how I retrieve and maintain that information. Perhaps you can use this list as a starting point for collating your own critical i/OS knowledge base.

    Serial Number, Processor Group, and Machine Type

    It seems like outside vendors always ask for the serial number of the machine I’m working on. The system Processor Group (otherwise known as P Group, which is used for

    …

    Read more

Content archive

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

Recent Posts

  • Public Preview For Watson Code Assistant for i Available Soon
  • COMMON Youth Movement Continues at POWERUp 2025
  • IBM Preserves Memory Investments Across Power10 And Power11
  • Eradani Uses AI For New EDI And API Service
  • Picking Apart IBM’s $150 Billion In US Manufacturing And R&D
  • FAX/400 And CICS For i Are Dead. What Will IBM Kill Next?
  • Fresche Overhauls X-Analysis With Web UI, AI Smarts
  • Is It Time To Add The Rust Programming Language To IBM i?
  • Is IBM Going To Raise Prices On Power10 Expert Care?
  • IBM i PTF Guide, Volume 27, Number 20

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 © 2025 IT Jungle