Ted Holt
-
I Want My F15 Back!
August 29, 2007 Hey, Ted
… Read moreI’m trying to get up to speed with WDSc. It’s getting better, but I’m not out of the woods yet. One SEU feature that I really miss is the ability to press F15 and browse another member. Using the Remote Systems Explorer and LPEX editor, I find myself following the navigation tree in order to open a member. Please make my day by telling me that LPEX has a function equivalent to SEU’s F15 key.
–Rick
OK, Rick, I’m going to make your day. LPEX has such a function.
While you are editing, hold down the control and shift keys,
-
Commands with Generic Parameters
August 22, 2007 Hey, Ted
… Read moreA while back you posted a tip regarding DLTF with a generic file name. It works great! I needed to copy a physical file and its related logical files to another library. I decided to prompt the CRTDUPOBJ command and was delighted to find that the OBJ parameter can specify a generic name! The file names were similar, with a slight difference in their suffix, so I was able to duplicate multiple objects with one command. Lesson learned: prompt a command once in a while and read all the parameters. Something may have been missed or added in a
-
Which One Is the Culprit?
August 8, 2007 Hey, Ted
… Read moreI am using the MAX function in a SQL statement to get the maximum value from a few columns. I don’t know which element is producing the maximum value. Is there a way to identify the element that has the maximum value?
–Hisham
Yes, Hisham. Thanks for allowing me another opportunity to show off that most versatile of SQL features: CASE.
For the benefit of the readers, here’s the SQL statement Hisham sent to me.
SELECT max(WK01, WK02, WK03, WK04) FROM SALES
Here’s the sort of results his SQL query generates.
MAX === 100 120 150
He has the maximum
-
Have Your Cake and Eat It, Too
August 1, 2007 Hey, Ted
… Read moreRecently one of my superiors walked into my cubicle and asked for some information. I was in the middle of another task and didn’t want to be side-tracked, so I hurriedly ripped out an SQL query to satisfy his request. A little while later he was back in my office asking me to run a fresh copy of the query, and while I was at it, to total some of the columns. This last request threw me for a loop, so I used Query/400. Could I have satisfied his request with SQL?
–D
I thought I had covered this situation
-
Bring Back My Qshell Output
July 18, 2007 Hey, Ted
… Read moreI just ran a CL program that has an embedded QShell script. It produced some output to my display and gave me a message that told me to press Enter. I did, and the Qshell output display went away. Now I want to bring that display back and look at the output again. Can I do that?
–Len
Yes, and it’s easy. So the readers can see what you’re talking about, let’s look at an example. Here’s a CL program that includes a QShell script.
pgm dcl &Script *char 1024 dcl &QshStatus *dec 10 value(0) dcl &MsgDta *char 256 dcl -
Customize the PC5250 Popup Keypad
July 18, 2007 Hey, Ted
… Read moreI just found out that I can change the function of the keys on the Personal Communications Popup Keypad, similar to the way I can map the keyboard. I created a new keypad with six functions on it. Here’s how I did it.
From the PC5250 session within iSeries Access (Client Access), pull down the Edit menu, then select Preferences and Popup Keypad. (Editor’s note: In some versions of Personal Communications, use the Assist menu and select Popup Keypad Setup.) Select the User-Defined keypad, rather than the IBM Default, and click on Customize.
At this point, you can expand the
-
Comment Your Binder Language
July 11, 2007 Hey, Ted
… Read moreBecause of Sarbanes-Oxley, we have a new requirement in our shop that all source members must include comments that tell the usual stuff–who did what, when and why they did it, etc. While we have always done that sort of thing (well, most of the time), there are certain types of source members we never bothered to comment. A good example is ILE binder language. I’ve looked for, but never found, a document that tells how to comment binder language. Do you know?
–Pat
IBM didn’t make it easy for you, Pat. I wondered the same thing myself a while
-
Conditional Counting with Open Query File
June 20, 2007 Hey, Ted
… Read moreIs there a way to make Open Query File (OPNQRYF) count records that meet certain criteria? I want to write a summary query, using OPNQRYF, that counts all records, and that also counts only the records that have a positive value in one of the numeric fields. Can OPNQRYF do anything like that?
–Dave
When I got Dave’s question, I told him that I thought it could be done, but I’d have to play with it to figure it out. A little while later, Dave had his query and I had another technique to share with you.
It would be
-
Joining on Mismatched Values
June 13, 2007 Hey, Ted
… Read moreLike many shops, we have a mixture of database files that we have acquired from different sources due to mergers and acquisitions over the years. Getting things to match up is challenging, to put it mildly. I have two files that contain warehouse code fields, but the codes do not match exactly. In one file, a certain warehouse is indicated by the letter T. In the other file, the same warehouse is the character 1 (one). All other warehouses have the same codes in both files.
I need to join these files, but I don’t know what to do about
-
Special Files Can Do It All, Part 2
June 6, 2007 Hey, Ted
… Read moreI just wanted to tell you how much I appreciate your real world ideas and examples. They are the kinds of ideas that can really help smaller shops do the practical, bulletproof kinds of jobs we need to do. I have used your special files technique to replace some old System/36 #GSORT sales analysis programs. I know, it takes us a long time to convert, but some of these programs have not changed in 15 years.
We have S/36 OCL procedures that display a screen to ask for parameters, use #GSORT to create an address-out file using the parameters for