• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • V6R1 Run SQL Scripts: Print and Save Result Sets

    June 24, 2009 Skip Marchesani

    The ability to print a Run SQL Scripts result set and/or save it in Excel spreadsheet format has been on my wish list and that of others for a long time. V6R1 has fulfilled these wishes and by doing so has made Run SQL Scripts more functional and easier to use.

    Print capability is now a standard function when a result set is displayed. However the Run SQL Scripts option to “Allow Save Results” must be selected to be able to save a result set in Excel or other file format. To select this option, click on Options in the

    …

    Read more
  • No More Global Variables!

    June 24, 2009 Ted Holt

    Last December, I shared four ways to avoid problems caused by the use of global data in RPG programs. I mentioned that a discussion of i 6.1 (or as I call it, V6R1) data-localization features would have to wait for another day. Well, that day is here.

    With V6R1, it is possible to write programs that have no global identifiers. (By identifiers, I mean variables and constants. By variables, I not only mean scalar variables, but also arrays and data structures.) You only need to change two programming practices.

    First, lose the RPG cycle. It breaks my

    …

    Read more
  • Reader Input: /QOpenSys Redux, PC5250 Popup Keypads, and Even Farther Beyond Replication

    June 24, 2009 Hey, Joe

    It looks like the links that you detailed in the Matryoshka Doll article on nested QOpenSys links probably occur after installing PASE on the iSeries. Check out this IBM document that very briefly discusses recursive /QOpenSys links in the AS/400 IFS. IBM doesn’t say why this happens, but at least it points the finger at what causes the problem.

    –Bill Speicher

    Earlier this year I wrote this article and a tip on one of the great mysteries of the AS/400 Integrated File System (AS/400 IFS). The purpose of the article was to explain why there are multiple /QOpenSys symbolic

    …

    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