• Now Where Did I Leave That Source Member?

  September 14, 2011 Bruce Guetzkow

  Note: The code accompanying this article is available for download here. During execution, programs rely strictly on their compiled objects. The source used to create the object is not used in any way for execution. There are, however, some instances where source is of value during processing. In a source member, one could store FTP commands to be used with the FTP (Start TCP/IP File Transfer) command, SQL statements to be used with the RUNSQLSTM (Run SQL Statements) command, or REXX statements to be used with the STRREXPRC (Start REXX Procedure) command. Knowing where the proper source exists is

  …

  Read more

• Admin Alert: Three Common Problems with CBUs

  September 14, 2011 Joe Hertvik

  Power i Capacity BackUp (CBU) systems are complicated critters. Aside from the basic tasks of configuring, testing, and enabling a CBU for taking over processing from a production box, there are a lot of different problems that can occur with CBU configuration, and even when the CBU is running in replication mode. This week, let’s look at a few not-so-obvious CBU configuration issues that can hurt your CBU or production system setup. Issue #1: Problems with libraries that start with “Q” By default, many Power i replication packages do not replicate objects in libraries whose names start with “Q”, such

  …

  Read more

• Adobe Flash Builder for the iSeries Programmer, Part 2

  September 7, 2011 Shannon O'Donnell

  NOTE: The code accompanying this article is available for download here. In my last article, I introduced you to the Adobe Flash Builder tool and showed you just how easy it is to create Flash-based user interfaces. In addition, I showed you how to integrate Flash components that other people create without having to know much, if anything, about them. And I told you that in future articles I would be showing you how to use Flash Builder to display and interact with iSeries DB2/400 data. Well, the future has arrived! In this article, which is the first

  …

  Read more

• Dynamically Invoke SQL UDFs From RPG Code

  September 7, 2011 Hey, Mike

  I’m wondering if it is possible to use dynamic SQL (prepare/execute or execute immediate) to call a User Defined [scalar] Function (UDF). I understand we can use the SET statement in our code but we would like to “soft” code some RPG business logic and we are looking at having the RPG code dynamically call certain UDFs based on certain conditions. So it would be nice to create dynamic SQL statements to call certain UDFs. Thanks! –Brian Hi, Brian: Today is your lucky day because there is a way to do this. Starting with V5R1, the VALUES INTO statement can

  …

  Read more

• Admin Alert: Starting Multiple PC5250 Sessions in a Batch File

  September 7, 2011 Joe Hertvik

  In a recent column, I demonstrated how to configure a PC5250 session so that you can run multiple sessions on the same PC to a single iSeries/System i/Power i partition. The problem with that technique was that it only worked using sessions that connected to the same partition. This issue, I’ll demonstrate how to automatically start multiple PC5250 sessions on the same PC that connect to different partitions. Today’s column was inspired by reader Bill Swann, who reminded me that the iSeries Access for Windows package includes a very simple procedure for launching multiple PC5250 sessions at the same time

  …

  Read more

• An Indicator By Any Other Name

  August 24, 2011 Jon Paris

  Because indicators have been around forever, we kind of take them for granted. I often find that RPGers don’t really understand all the ways in which they can be used. This tip is an attempt to highlight four things that every RPGer should know about our little friends. 1. Indicators, or at least the standard set, are an array. You may not need to use indicators *In01 – *In99 as an array, but the fact that they are an array offers an opportunity to name them with minimal effort. I have always hated the fact that we have to rely

  …

  Read more

• Add a Record to Any File

  August 24, 2011 Bruce Guetzkow

  Note: The code accompanying this article is available for download here. Sometimes it is handy to be able to write simple data records to a file from a CLLE module/program without having to write additional programs or procedures. Since IBM has not provided a direct way to do this as part of the operating system, here is a simple method that you can install and use in a matter of minutes. I’ve seen several examples over the years of ways to add a record to any file. Usually a temporary file is involved using a program-described file in the

  …

  Read more

• Admin Alert: Two PC5250 Configuration Secrets

  August 24, 2011 Joe Hertvik

  With a history that spans well over a decade, the PC5250 program that comes with iSeries Access for Windows 6.1 contains tons of features that the average user or administrator may be unaware of. This week, I am discussing how you can use PC5250 to delete unneeded macros and to run multiple unique green-screen sessions on your desktop. Let’s get started. Deleting a PC5250 Macro In an earlier issue, I demonstrated how to record and play PC5250 macros. After that article was posted, several readers wrote in asking me how to delete existing macros on their systems. Here’s the

  …

  Read more

• Adobe Flash Builder for the iSeries Programmer, Part 1

  August 10, 2011 Shannon O'Donnell

  Note: The code accompanying this article is available for download here. If I’ve heard it once, I’ve heard it a thousand times: “The AS/400 is a legacy system with character-based data that is good for nothing but running batch programs.” That sentiment drives me right up the wall. In all fairness, however, the traditional iSeries/RPG programmer has done very little to prove these nay-sayers wrong. Sure, every once in a while you will see an RPG programmer throw some nice colors on a display file or maybe even use a message subfile, but while those were pretty cool tricks

  …

  Read more

• ILE: Decisions, Decisions, Part 2

  August 10, 2011 Susan Gantner

  In an earlier tip, I explored questions I often hear about binding directories. In this tip, I’ll explore another commonly asked ILE question and give you my perspective. Question: How many service programs should I have and how big should they be? Answer: It depends. Don’t you hate that answer? But in this case, I do think it is completely application dependent. Often when I am asked this question, the emphasis seems to be related to performance. But I don’t think the decision on the “what” or “how much” to put into a service program should be made based

  …

  Read more

Previous Articles Next Articles