• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Allow Repeated Change With SQL Triggers

    November 20, 2013 Paul Tuohy

    In my previous article, I described how an RPG program as a before trigger, could be used to synchronize two columns in a table. There is an alternative. Instead of using an RPG trigger, we could have used an SQL trigger. An SQL trigger allows us to be more specific about when the trigger is activated and also has the advantage of portability to other database management systems.

    The scenario was where a date, stored as a packed numeric column, was to be converted to a proper date field. This was accomplished by duplicating the packed numeric column (and

    …

    Read more
  • Alan’s Easy Method For Building A CSV File From A Report

    November 20, 2013 Ted Holt

    I love simple solutions to common problems, and boy, have I got a good one for you today! Clever and faithful reader Alan Urtubia recently told me how he turned a report into a CSV file and I was impressed. Alan kindly allowed me to pass this tip along to you.

    Alan needed to create a CSV file from a report without modifying the RPG program. He found a method to do so without modifying or recompiling any of the original source code.

    To illustrate his technique, let’s begin with a simple report. Here’s the DDS for printer file QAD001P:

    …

    Read more
  • Minimizing IPL Surprises With The IPL Startup Kit

    November 20, 2013 Joe Hertvik

    Unlike a Windows server that can be rebooted several times a year, an IBM i machine is so reliable that it can run for a year or more without being IPLed. But infrequent IPLs can cause their own problems, as functions that should be restarted after an IPL may not necessarily actually restart after an IPL. That’s where it comes in handy to have an IPL startup kit available.

    Why Create An IPL Startup Kit?

    Since an IBM i box can go so long between restarts, your system startup routine may not include all the functions that were added to

    …

    Read more

Content archive

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

Recent Posts

  • With Power11, Power Systems “Go To Eleven”
  • With Subscription Price, IBM i P20 And P30 Tiers Get Bigger Bundles
  • Izzi Buys CNX, Eyes Valence Port To System Z
  • IBM i Shops “Attacking” Security Concerns, Study Shows
  • IBM i PTF Guide, Volume 27, Number 26
  • 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

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