• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Finding Duplicate Rows in a Name and Address Table

    May 25, 2011 Skip Marchesani

    Many companies still use the U.S. Postal Service to mail promotional and marketing materials to existing and potential customers. With rising printing expenses and postal rates, it’s important to minimize waste by identifying and eliminating duplicate rows in name and address tables. However, these tables can present some interesting challenges.

    For instance, the following two addresses are duplicates, but how do you identify them as potential duplicate rows?

    John Sampson
    Dickerson Mutual Ins.
    218 Bridge St., Suite 257
    New York, NY 12345

    John Samson
    Dickerson Insurance
    218 Bridge Street
    NYC, NY 12345

    Companies can write their own software, which has

    …

    Read more
  • Asserting the Ostensibly Unassertable

    May 25, 2011 Hey, Ted

    Assertions are great for validating conditions that can be tested with IF, DOW, SELECT, etc., but what about other types of conditions? For instance, can I use an assertion to test that a variable contains valid decimal data?

    –A Nice Lady

    (I’m sorry. A nice lady asked me this question in person and I forgot her name.)

    Yes, it is possible to check for conditions that one cannot test with conditional OPCODES such as IF, but you must use a different method.

    When something goes amiss, the system loads a five-digit, zoned-decimal status code with a non-zero value. You can

    …

    Read more
  • Admin Alert: Other Options for a Post-Upgrade Backup

    May 25, 2011 Joe Hertvik

    In an earlier column, I wrote about how administrators can save time after an i operating system upgrade by performing a Save System (SAVSYS) backup instead of a full system save. Several readers wrote in with more information and system information backup tips. Let’s look at what they had to say about post-upgrade backups and what we can learn from them.

    A Better Post-Upgrade Backup Strategy

    Pete Massiello of iTech Solutions wrote in with the best suggestion for post-upgrade backups when he said:

    I perform many upgrades, and I tell my customers that the best option, if time permits,

    …

    Read more

Content archive

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

Recent Posts

  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25
  • Meet The Next Gen Of IBMers Helping To Build IBM i
  • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
  • Will Independent IBM i Clouds Survive PowerVS?
  • Now, IBM Is Jacking Up Hardware Maintenance Prices
  • IBM i PTF Guide, Volume 27, Number 24

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