• Guru: The Binding Directory Is The Key

  October 1, 2018 Ted Holt

  Hey, Ted:

  We license a software package to handle email on our IBM i system. When I write an RPG program that uses those routines, I can’t compile with the usual Create Bound RPG Program (CRTBNDRPG) command. Instead I have to use a two-step process — Create RPG Module (CRTRPGMOD) followed by Create Program (CRTPGM). Can you explain why this is? Even better, can you tell me if there is a way that I’m not aware of to compile with CRTBNDRPG?

  — David

  David continued, “I use CRTBNDCL and CRTBNDRPG, as they get me what I need, otherwise I am …

  Read more

• Guru: Phonetic Functions In SQL, Part 2

  September 24, 2018 Paul Tuohy

  In my previous article I discussed the use of the standard SOUNDEX and DIFFERENCE functions for phonetic processing. I also identified the major problems with SOUNDEX (based on U.S. English and the first character is static) and DIFFERENCE (loose because it is based on SOUNDEX).

  In this article I will discuss how to tackle these problems by writing a customized phonetic function to use in place of or in conjunction with SOUNDEX. The good news is that you do not have to become an expert in phonetics — others have already done the job for you. There are a number …

  Read more

• Guru: Phonetic Functions In SQL, Part 1

  September 17, 2018 Paul Tuohy

  In my next two articles I am going to discuss the use of phonetic functions in SQL. You can use phonetic functions to select or order rows based on the phonetic sound of a string as opposed to the actual characters in the string. The obvious use of phonetic functions is with names, but they can be used with any string columns.

  I must admit that this touches on one of my pet peeves — the spelling of my surname. I have lost count of the number of times I have had to spell my name two, three, or four …

  Read more

• Guru: Data-Centrism, Step Zero

  September 10, 2018 Ted Holt

  I hear a lot these days about the need for data-centric information systems. That is as it should be. The proper way to support an organization is to remove logic from application programs and put it into the database through such devices as constraints and triggers. However, before many shops can take the first step in that direction, they need to take what I call step zero.

  Step zero in data-centric computing is to remove hard-coded data values from programs and put them into the database. Just as the database manager should enforce business rules (e.g. we don’t ship to …

  Read more

• Guru: Refactoring RPG – GOTO

  August 27, 2018 Ted Holt

  When I first learned COBOL, I coded loops the way all the programmers in my shop did — with GO TO. Paragraph names were labels, not routines. Then I took a class in COBOL and learned structured programming. I’ve never looked back. I wish other people felt the same way, because I don’t like to work on GOTO-laden programs.

  Injudicious use of branching — in RPG that would be the GOTO and CABxx op codes — is a major reason I refactor. GOTO plays havoc with program “logic”, a word I hesitate to use in this context. The minute someone …

  Read more

• 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

Previous Articles Next Articles