• Guru: Make It Easy On Someone Else

  August 20, 2018 Ted Holt

  “Make it easy on yourself,” warbled Dionne Warwick when I was just a pup. That may be good advice when severing a romantic relationship, but not when programming computers. Instead of making it easy on ourselves, we who develop and support applications need to make it easy on the people we serve.

  Recently I worked on a project in which users had to enter time values into various Web pages. The original specifications stated that users would enter time values in a format we commonly use in the United States: two-digit hour, a colon, two-digit minute, a space, …

  Read more

• Guru: Beefing Up The Job Log, Take Two

  August 6, 2018 Ted Holt

  In Tracing Routines Explain Why The Computer Did What It Did, I wrote about the usefulness of writing information about program execution to determine why a program run gave certain results. Today I want to present a simpler method than the tracing routines. The tracing routines are not obsolete, but they are powerful and I have found them at times to be overkill.

  Just a word about terminology. Since I wrote that article five and a half years ago, my reading has led me to a different understanding of the terms tracing and logging. I’ve since decided that …

  Read more

• Guru: Refactoring RPG – Indicators

  July 30, 2018 Ted Holt

  Occasionally I hear someone comment about how terrible indicators are. I don’t think they’re bad. Indicator-laden RPG helped me graduate debt-free with a computer science degree and housed, clothed, and fed my family for several years. I prefer to say that indicators were good for their time, but now we have better programming techniques that I much prefer to use.

  Refactoring code to reduce or even eliminate the use of predefined indicators (not indicator variables) can pay off big in benefits. The fewer indicators a program uses, the easier it tends to be to read, understand, modify, and debug that …

  Read more

• Guru: Serve Web Pages Safely Using A Reverse Proxy

  July 23, 2018 Alan Seiden

  If you are hosting a website or API from your IBM i server, but wish to reduce your worry about allowing access from the Internet, we often recommend a reverse proxy (or “gateway”) server. An industry-standard solution, a reverse proxy server acts as a layer of safety between your production server and your firewall. On IBM i, the IBM HTTP Server (powered by Apache) for i can act as a reverse proxy server, so there’s nothing additional to install.

  While there are several ways to set it up, one approach is to put the reverse proxy or gateway in a …

  Read more

• Guru: Ready or Not! Part 4 of Big Changes in RDi V9.6, PDM Affinity with Object Table

  July 16, 2018 Susan Gantner

  I’m beginning to feel like a broken record — still more new RDi features with V9.6. I’m excited that there are so many great new features to talk about. In this tip, I’ll cover the primary feature added with fix pack update V9.6.0.3 — enhancements to the Object Table for PDM affinity.

  To me, the enhancements to the Object Table view to make it look and feel much more like PDM are the most significant in the release. There are some other smaller — but still very welcome — enhancements as well, which I’ll cover in a later tip.

  Why …

  Read more

• Guru: Speed Up Web Pages Using Apache’s mod_deflate

  July 9, 2018 Alan Seiden

  If your web applications run on HTTP Server (Powered by Apache) for i, you can enable a powerful Apache extension, mod_deflate, to speed up your site. Just as zipping up files on your PC saves space and accelerates file transfers, mod_deflate “allows output from your server to be compressed before being sent to the client over the network.” (See https://httpd.apache.org/docs/2.4/mod/mod_deflate.html for more information.) My tests show a speed improvement of 10 to 50 percent.

  You can compress any text-based output, including HTML (whether plain .html files, output from RPG CGI programs, PHP, or other languages), Cascading Style Sheets (CSS), …

  Read more

• Guru: RPG’s New DATA-INTO

  June 18, 2018 Jon Paris

  In this tip I’m going to give a brief introduction to the latest addition to the RPG language. The new DATA-INTO op-code. DATA-INTO is IBM’s response to the oft-asked question: “When is IBM going to introduce JSON-INTO so we can process JSON as easily as XML?”

  DATA-INTO provides this capability, but IBM has very cleverly given it functionality that goes way beyond what a simple JSON-INTO op-code could ever have done. DATA-INTO is effectively a cross between XML-INTO and Open Access. Like XML-INTO it uses the names of items and their hierarchy to unpack the document into RPG variables. Like …

  Read more

• Guru: Ready or Not! Part 3 Of Big Changes In RDi V9.6, Compare/Merge, Code Coverage, and More

  June 4, 2018 Susan Gantner

  This is the third in my series of tips on RDi V9.6. In this one I’ll cover the new compare and merge support, along with improvements to code coverage and a few other smaller enhancements in V9.6. I originally thought this would be the last in the series, but IBM recently made available a new point release that introduced enough new features to mean I’ll be adding at least one more tip.

  Compare And Merge

  The ability to compare the content of two source members is not new to RDi, but with V9.6 the facility now offers the option to …

  Read more

• Guru: How To Override Query Options

  May 21, 2018 Ted Holt

  QAQQINI is a physical file with which you can control certain behaviors of the DB2 for i query engine. For a list of the query options that you can change, visit the IBM Knowledge Center. Normally you don’t have to use it, as the engineers of IBM have done a great job designing an optimizer that does a great job.

  At times you may want to change a query attribute for a certain job. There is no need to build many QAQQINI files to handle all possibilities. Instead, you can temporarily override query attributes within a job. DB2 for …

  Read more

• Guru: Odds And Ends

  May 14, 2018 Ted Holt

  Little things can make a big difference. Today I am pleased to present a few short tips that may make a difference for you. I hope you get something useful here. If you have short tips that you would like to share with your fellow readers, please email them to me and I’ll see what I can do. Have a wonderful day!

  ---

  Hey, Ted:

  I just read your article More Date And Time Conversions Using SQL. Just as aside, the scalar functions Decimal/Dec, Integer, and BigInt can convert times, dates and timestamps directly into a numeric representation in the …

  Read more

Previous Articles Next Articles