• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Run SQL Scripts: Use Temporary JDBC Settings

    January 20, 2010 Skip Marchesani

    I consider myself to be a power user of Run SQL Scripts and use them for a variety of purposes, including ad hoc queries to do data analysis. Run SQL Scripts can be configured for your personal preferences (SQL default schema or current library, schema or library list, SQL or system naming convention, and other parameters) by clicking on Connection in the toolbar and then JDBC properties. Once you select your personal preferences and click the Connect button on the bottom of the JDBC Setup panel, your preferences are saved and become the default each time you invoke Run SQL

    …

    Read more
  • Can a Function Return More Than One Value?

    January 20, 2010 Hey, Ted

    Is it possible for an RPG subprocedure to return more than one value? (I assume it isn’t; the RETURN opcode only allows for one argument.) I want to write a function subprocedure that will return a data structure of information taken from various database files. However, the subprocedure will also need to return a status code to indicate whether or not the I/O was successful. Do you have any suggestions?

    –Travis

    What you want to do is something like this:

    eval (MyDataStructure: Status) = GetData (KeyValue)
    

    No, that won’t work. But I can show you two other ways that will.

    …

    Read more
  • Admin Alert: Erasing i5/OS Disk for Fun and Compliance

    January 20, 2010 Joe Hertvik

    When decommissioning iSeries, System i, or Power i systems, there may be legal considerations in erasing disk drive data. Decommissioning can occur when removing disk drives from a system; when completing a Disaster Recovery Test on an outside provider’s machine; or when an i5/OS machine is sold or returned to a leasing company. The problem is that decommissioning disk drives can easily violate legally mandated compliance standards.

    Compliance and Decommissioned Disk Drives

    Like most systems, i5/OS data doesn’t necessarily disappear when you reinitialize your disk drives. Clever and determined hackers may be able to reconstruct supposedly erased data if they

    …

    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