• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Calling SQL Functions Directly From a High Level Language Program

    April 18, 2007 Hey, Mike

    The Create SQL Function from the article SQL Cross Platform Interoperability: The Proper Function creates a CLE *srvpgm on the iSeries. Can this be accessed from an RPGLE program? If so, what would the prototype look like? I am not familiar with C and cannot get this to work, so far, on my own.

    –Gene

    Note: The code accompanying this article can be downloaded here.

    This astute reader noticed that when creating an SQL-based function, DB2 generates an ILE C service program behind the scenes. This prompted the reader to inquire if there was a way to call the

    …

    Read more
  • My Favorite Keyboard Shortcuts for RSE

    April 18, 2007 Susan Gantner

    When using RSE for editing my CL, DDS, RPG or COBOL code, I find that I can save a lot of time by using keyboard shortcuts for functions that would otherwise require that I take my hands off the keyboard to use the mouse. So I thought I would share a few of my favorites. Many of the shortcuts I use are standard for other Windows-based applications that I also use for email, spreadsheets or text editing.

    These include some very common ones such as:

    • Ctl-C to copy, Ctl-V, or Shift-Insert to paste, and Ctl-X or Shift-Delete to cut.
    …

    Read more
  • Two Ways to Audit Your Backup Strategy

    April 18, 2007 Hey, Joe

    Nice article on five things that kill backups. In regards to auditing backup results, however, I find it a little tedious to check joblogs as you recommended. I prefer to use the Display Log command for reviewing the system history log to check backup results. It’s easy to spot missed objects from this display. I also like to use the Display Backup List command (DSPBCKUPL) for Sarbanes-Oxley compliance.

    –Bill

    Thanks, Bill for bringing up two ideas I hadn’t thought of when I wrote that article. Here are the details on what Bill is discussing and how it can help

    …

    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