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

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

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