04
Mon, Nov
6 New Articles

Weaving WebSphere: EGL and RPG

Development Tools
Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

I've been spending a lot of time with EGL lately. I've been out doing seminars (I'll be giving a session on EGL at iSeries DevCon in November), and lately I've been putting the language through its paces. When I first looked at the product, I really didn't see a lot of potential, but I think much of that was due to the powerful design concepts that make it seem almost too easy.

Simplicity Doesn't Have to Cost You Flexibility

There has been a lot of discussion on the Internet about the Ruby language and specifically Ruby on Rails (RoR). Both are superb tools developed by some extraordinarily talented folks. Ruby is a powerful object-oriented scripting language, while RoR is a framework for Ruby that simplifies many of the basic functions of building applications.

RoR's rallying cry is "convention over configuration," which means that if you follow RoR's programming rules, Ruby will do a lot of the work for you. Those rules include things like proper naming conventions for your files and fields. At the same time, if you don't like the conventions, you can override them on an individual basis.

EGL's Rich Data

EGL has a slightly different approach: It believes in configuration, but only at the lowest level. The philosophy is based on the simple concept of rich data. In EGL, every piece of data can have literally dozens of properties defined for it, ranging from simple field attributes to validation to UI characteristics (going so far as to allow you to define characteristics for a text-based interface separate from those for a GUI).

I can start by creating a "field definition file," which is just an EGL source file containing nothing but DataItems. I can then (typically in separate source files) group DataItems into Records, which have their own meta-properties. For example, a Record of type SQLRecord gets intrinsic support for SQL coding. Invoking certain EGL opcodes (such as "get") on an SQLRecord automatically generates the appropriate SQL code. Thus, these Records provide you with a very high-level syntax to access the database.

Note that I don't have to go through a two-step process, first defining DataItems in one EGL file and then creating Records from those DataItems. I can define the fields for a Record and their attributes right in the record itself. Think of the two different techniques as roughly equivalent to using a field reference file to define all your fields and then just referencing them in the DDS for your physical files as opposed to defining the attributes for each field in the physical file. If you use the same basic field type (such as a description) over and over again, you'll save yourself a lot of typing. Another nice thing about using DataItems is that the DataItem statement has a special wizard called the Source Assistant, which makes it very easy to define all the characteristics of a field.

Defining the User Interface

This rich data also serves as a fundamental device for building your user interface. EGL uses JavaServer Faces (JSF) as its primary Web UI. So first I create a new JSF page (also called a Faces JSP). Next, I can drop a Record onto that JSP using the WYSIWYG JSP designer, and it will prompt me for a couple of bits of information (such as whether the record is for display or update). EGL will then generate a nice two-column UI with the right column containing the fields and the left column (this is the cool bit!) containing the prompts that I defined for each field in the metadata. Or I can drop an array of records onto a JSP, and it will automatically generate a table with multiple rows (as many as I load in the array at runtime) and column headings from the metadata. The UI build has a lot more capabilities, which I'll explore in more detail in my next "Weaving WebSphere" column. Today though, I want to talk about EGL and RPG.

Interfacing to RPG

The key to today's discussion is the concept of a BasicRecord. Among its many uses, a BasicRecord can act very much like a data structure in RPG. You can create a BasicRecord either in your project-level EGL definitions or on the fly in your page handler (I'll do the former today). That BasicRecord can contain any number of fields and can then be passed to another EGL function.

EGL provides a very powerful interface to Java, in which you can easily identify the class and methods of an external Java package and then invoke those methods, even passing optional parameters. The biggest drawback today is that only primitive EGL fields can be passed to Java methods, not Records. That means that if I want to update a record that contains a dozen attributes, I would have to invoke the EGL/Java interface a dozen times, whereas if I could pass a Record, I would invoke the interface only once.

The EGL team is providing an even more elegant Java interface in the next release of the tool. I'm trying to convince them that passing Records is important enough to include along with the new syntax. In fact, I consider this to be such a fundamental requirement of using the tool that I have devised a workaround, which I will be using in today's article.

What's All This Java Nonsense Anyway?

You may wondering why I am talking about Java when the article is supposed to be about EGL and RPG. Well, the point is that Java provides an absolutely perfect interface between the two by way of IBM's Java Toolbox for the iSeries. By writing a few lines of Java code, I can create a fast, powerful interface between the two languages. The rest of the article will walk you through the steps required to create a simple interface that allows an RPG program to load an array, with almost no Java.

(Author's Note: Over the years, I have been trying to create a pain-free interface between RPG and the Web using as little Java as possible. For the past several years, I've been promoting a framework of Java and JSPs that, with only a few hundred lines of Java code, allows programmers to create fully functioning RPG-based Web applications but with the power and flexibility of JSPs. The technique I present today uses EGL to reduce that Java interface code to just a handful of lines, most of which can be cloned whenever you want to add another server program.)

Creating the Application

I'll start by creating an interface. And that actually starts in my mind. What I am going to do is create an interface between Java and RPG that uses a data structure. The data structure contains an opcode and a return code and then some data fields. In its simplest form, this data structure allows me to call the RPG program with two opcodes: I for initialize, and G for get. The initialize opcode tells the RPG program to get ready to send data. In this simple example, it will just do a SETLL to the beginning of the file, but in a more complex environment, it could perform an OPNQRYF or create an embedded SQL cursor. Then, each get opcode will return either a record or an EOF condition.

Here's the data structure:

d xids            ds                  
d   xsOpcode                     2    
d   xsReturnCode                 2S 0 
d   xsLibrary                   10    
d   xsFile                      10    
d   xsOwner                     10    


Using that as Step 0, I can now start the EGL design.

Step 1: Creating the Interface Record

http://www.mcpressonline.com/articles/images/2002/060817AD%20-%20EGL%20and%20RPGV4--08230600.png

Figure 1: This is the same record in EGL. (Click images to enlarge.)

I create a new file called LibraryRecord.egl and add the lines above. The name of the Record is "LibraryMessage", and it is a BasicRecord (meaning it has no other intrinsic behaviors). Note the easy relationship between RPG data types and EGL data types. Also note that I supply display names only for the data fields, not the opcode and return code. You'll see why in a moment.

Step 2: Create the Faces JSP Page

http://www.mcpressonline.com/articles/images/2002/060817AD%20-%20EGL%20and%20RPGV4--08230601.png

Figure 2: The basic Faces JSP wizard uses two panels to define the page.

This step simply creates the Faces page. I use one of the supplied templates (in this case, the simple blue template) and the Faces page is generated.

Step 3: Add Data to My Page

http://www.mcpressonline.com/articles/images/2002/060817AD%20-%20EGL%20and%20RPGV4--08230602.png

Figure 3: Add an array of LibraryMessages to the page.

Next, I simply add an array of messages to the page. Note that I didn't check the box marked "Add controls...". This will add the array to my Page Data but not actually generate a UI for it. I will generate the UI in the next step.

Step 4: Define the User Interface

http://www.mcpressonline.com/articles/images/2002/060817AD%20-%20EGL%20and%20RPGV4--08230603.png

Figure 4: The next step is to drag the array onto the page where I want it.

I changed the test at the top of the page to "Libraries," and now I drag the array of LibraryMessages from my Page Data list to the bottom of the page. When I drop the array on the page, I get a prompt like the one in Figure 5.

http://www.mcpressonline.com/articles/images/2002/060817AD%20-%20EGL%20and%20RPGV4--08230604.png

Figure 5: This wizard lets me configure the controls of the table as well as the columns.

Now you can see why I added display names for only the three data fields; only those fields will be displayed on the page! You can select fields, move them around, change their input capabilities, and so on.

Step 5: Create the Java Interface

http://www.mcpressonline.com/articles/images/2002/060817AD%20-%20EGL%20and%20RPGV4--08230605.png

Figure 6: Today, I basically write a placeholder; I have to hack the code later.

The last thing I have to do on the client side is create the interface to the Java, which in turn calls the RPG program. I add two lines of EGL. The first defines a singular element of type LibraryMessage called libraryMessage (note that the array of LibraryMessages named Libraries was created for me back in Step 3). The second line appends this single record to the array of records. Now, that's kind of dumb: The single message is empty, so basically this would create a single empty row in the table. Don't worry; I plan to go into the generated Java code and hack in a call to my Java interface code. The code up until this point has taken a couple of minutes to implement.

Step 6: Hack the Generated Java

http://www.mcpressonline.com/articles/images/2002/060817AD%20-%20EGL%20and%20RPGV4--08230606.png

Figure 7: This is the hack I make; the original code is inside the box, and I add the additional code.

My entire hack is based on creating an instance of the interface object (called Library) and invoking three routines: init(), get(), and close(). The init() method creates the host connection and calls the program with the I opcode, the get() method calls the program with the G opcode and returns "true" or "false" based on whether it completes succesfully, and the close() method closes the connection with the host. What I'm asking the EGL team for is the ability to define a new Record of type JavaRecord (rather than SQLRecord) in which I can define the Java class in the Record. Then, when I write a simple "get libraries" in my EGL code, it will generate calls to the init(), get(), and close() methods something like what I have done. This doesn't have to be the way they do it, but I need something this simple in order to be able to use EGL as a UI layer for my RPG logic.

The hack, by the way, takes only a minute to implement. The problem is that the next time I generate code for the page (for example, if I have to make some sort of change to the table), I lose the hack. This is a general issue with EGL: It's not really a round-trip 4GL; it's more of a code generator. It generates the code, and then you can update it.

The Result

http://www.mcpressonline.com/articles/images/2002/060817AD%20-%20EGL%20and%20RPGV4--08230607.png

Figure 8: This is the resulting page—simple, clean, and very fast.

I'm including the Java code and the RPG code that makes this work. If you look at the Java code, you'll find that there's a clever bit of code in there (and remember, when I say "clever," I mean "it works but it could be confusing"). I define the host variable as static, and I also define a static thread called "killer." The thread uses an internal class named Killer, and it's used to kill the connection after a certain period of time elapses. This allows me to use a single connection over and over (which can be lengthy), yet will close it if the user remains idle for a while. It's a great technique in general, but this particular coding style means that all users share the same instance. That can be a problem. Instead, there should be one instance per user stored in the HttpSession object, but since I don't have ready access to the HttpSession object, it's hard to do that. But this code will work for testing.

You may also notice a hack in the RPG program; it has a counter and a hard-coded limit of 20 libraries. Again, I did that for testing purposes. You can remove that limitation if you'd like to see how the interface works with long lists. However, I'll be doing more with this program in the next article (including things like testing the paging controls built into the JSF editor).

So Is It Soup Yet?

Good question. I wish I had a simple, consistent answer. Instead, today my answer depends on how you would like to use the tool. If you're planning to use it as a rapid development environment for generating screens and then interfacing with back-end RPG logic, EGL rates about four out of five stars. On the other hand, if you plan to use it as a complete ground-up development environment, the lack of support for round-trip modifications and the inability to percolate changes automatically through the generated code drops it to perhaps three stars. And some of my perceptions are betting on future enhancements to the language which, if they don't materialize, will adversely affect the tool's usefulness at least in the types of things I am trying to do.

No matter how you look at it, though, EGL has a whole lot of things going for it. It does perhaps the best job of using JSF I've seen and does it with a powerful WYSIWYG front-end. The support for SQL is straightforward and well-thought-out, and the basic JSF tooling in WDSC is superb. A couple of tweaks here or there for the RPG interface and I think EGL may be the thin-client interface I've been looking for.

And most importantly, the real selling point of EGL is that it's free. With EGL, IBM has finally addressed the nagging issue of there being no native graphical language for the System i. WDSC and EGL provide a replacement for 5250 that I believe can give Visual Studio a run for its money. EGL may well be the last piece of the System i puzzle. With its Eclipse heritage, WDSC has always been a fantastic Web application development tool, and the combination of RSE and LPEX make it a very powerful tool for server-side RPG development. But what's been missing is the bridge between the two. As System i developers begin to see the capabilities of EGL, I think they'll start flocking to WDSC in droves.

In fact, about the only thing IBM could do right now to crush WDSC and EGL would be to start charging for it. Remember, one of the reasons that System i customers are willing to pay the rather large premium on the hardware is that we expect a bundled machine. If I pay for 5722WDS (the developer's tools) I expect that to include all the tools I need, especially since IBM is telling me to get off of the green-screen. And we already have a bad taste in our mouths about the interactive tax, and the nasty little bait and switch of WebSphere Application Server 4.0 isn't far in the past. So don't stick it to me yet again in order to develop Web applications.

If it's an issue of wanting to go to a more user-based pricing scheme for the products, then maybe IBM can do this: figure out a reasonable number of users for each processor tier and then include some bucks in the price of 5722WDS. Kick that back to the WDSC development group, and if I as a user outgrow that number, I can buy more licenses. I suppose having 100 WDSC licenses running on a low-end model 520 is overreaching the spirit of the tool. But at the same time, don't make me pay for every copy of WDSC, or chances are I won't buy any, and the momentum of the box stalls.

Please drop a note in the forums! I'd really like to hear your opinion on WDSC and whether or not you plan to use the tool, whether you might consider EGL, and whether an additional charge for the tools would affect your decision.

Anyway, stay tuned for the next installment. This column was dedicated to making sure I can use EGL with an RPG back-end. Next time, I want to focus on the front-end and see just how capable the tools are for creating good-looking user interfaces.

Joe Pluta is the founder and chief architect of Pluta Brothers Design, Inc. and has been extending the IBM midrange since the days of the IBM System/3. Joe uses WebSphere extensively, especially as the base for PSC/400, the only product that can move your legacy systems to the Web using simple green-screen commands. He has written several books, including E-Deployment: The Fastest Path to the Web, Eclipse: Step by Step, and WDSC: Step by Step. Joe performs onsite mentoring and speaks at user groups around the country. You can reach him at This email address is being protected from spambots. You need JavaScript enabled to view it..

Joe Pluta

Joe Pluta is the founder and chief architect of Pluta Brothers Design, Inc. He has been extending the IBM midrange since the days of the IBM System/3. Joe uses WebSphere extensively, especially as the base for PSC/400, the only product that can move your legacy systems to the Web using simple green-screen commands. He has written several books, including Developing Web 2.0 Applications with EGL for IBM i, E-Deployment: The Fastest Path to the Web, Eclipse: Step by Step, and WDSC: Step by Step. Joe performs onsite mentoring and speaks at user groups around the country. You can reach him at This email address is being protected from spambots. You need JavaScript enabled to view it..


MC Press books written by Joe Pluta available now on the MC Press Bookstore.

Developing Web 2.0 Applications with EGL for IBM i Developing Web 2.0 Applications with EGL for IBM i
Joe Pluta introduces you to EGL Rich UI and IBM’s Rational Developer for the IBM i platform.
List Price $39.95

Now On Sale

WDSC: Step by Step WDSC: Step by Step
Discover incredibly powerful WDSC with this easy-to-understand yet thorough introduction.
List Price $74.95

Now On Sale

Eclipse: Step by Step Eclipse: Step by Step
Quickly get up to speed and productivity using Eclipse.
List Price $59.00

Now On Sale

BLOG COMMENTS POWERED BY DISQUS

LATEST COMMENTS

Support MC Press Online

$

Book Reviews

Resource Center

  • SB Profound WC 5536 Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application. You can find Part 1 here. In Part 2 of our free Node.js Webinar Series, Brian May teaches you the different tooling options available for writing code, debugging, and using Git for version control. Brian will briefly discuss the different tools available, and demonstrate his preferred setup for Node development on IBM i or any platform. Attend this webinar to learn:

  • SB Profound WP 5539More than ever, there is a demand for IT to deliver innovation. Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects. The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.

  • SB HelpSystems ROBOT Generic IBM announced the E1080 servers using the latest Power10 processor in September 2021. The most powerful processor from IBM to date, Power10 is designed to handle the demands of doing business in today’s high-tech atmosphere, including running cloud applications, supporting big data, and managing AI workloads. But what does Power10 mean for your data center? In this recorded webinar, IBMers Dan Sundt and Dylan Boday join IBM Power Champion Tom Huntington for a discussion on why Power10 technology is the right strategic investment if you run IBM i, AIX, or Linux. In this action-packed hour, Tom will share trends from the IBM i and AIX user communities while Dan and Dylan dive into the tech specs for key hardware, including:

  • Magic MarkTRY the one package that solves all your document design and printing challenges on all your platforms. Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Make sure your data survives when catastrophe hits. Request your trial now!  Request Now.

  • SB HelpSystems ROBOT GenericForms of ransomware has been around for over 30 years, and with more and more organizations suffering attacks each year, it continues to endure. What has made ransomware such a durable threat and what is the best way to combat it? In order to prevent ransomware, organizations must first understand how it works.

  • SB HelpSystems ROBOT GenericIT security is a top priority for businesses around the world, but most IBM i pros don’t know where to begin—and most cybersecurity experts don’t know IBM i. In this session, Robin Tatam explores the business impact of lax IBM i security, the top vulnerabilities putting IBM i at risk, and the steps you can take to protect your organization. If you’re looking to avoid unexpected downtime or corrupted data, you don’t want to miss this session.

  • SB HelpSystems ROBOT GenericCan you trust all of your users all of the time? A typical end user receives 16 malicious emails each month, but only 17 percent of these phishing campaigns are reported to IT. Once an attack is underway, most organizations won’t discover the breach until six months later. A staggering amount of damage can occur in that time. Despite these risks, 93 percent of organizations are leaving their IBM i systems vulnerable to cybercrime. In this on-demand webinar, IBM i security experts Robin Tatam and Sandi Moore will reveal:

  • FORTRA Disaster protection is vital to every business. Yet, it often consists of patched together procedures that are prone to error. From automatic backups to data encryption to media management, Robot automates the routine (yet often complex) tasks of iSeries backup and recovery, saving you time and money and making the process safer and more reliable. Automate your backups with the Robot Backup and Recovery Solution. Key features include:

  • FORTRAManaging messages on your IBM i can be more than a full-time job if you have to do it manually. Messages need a response and resources must be monitored—often over multiple systems and across platforms. How can you be sure you won’t miss important system events? Automate your message center with the Robot Message Management Solution. Key features include:

  • FORTRAThe thought of printing, distributing, and storing iSeries reports manually may reduce you to tears. Paper and labor costs associated with report generation can spiral out of control. Mountains of paper threaten to swamp your files. Robot automates report bursting, distribution, bundling, and archiving, and offers secure, selective online report viewing. Manage your reports with the Robot Report Management Solution. Key features include:

  • FORTRAFor over 30 years, Robot has been a leader in systems management for IBM i. With batch job creation and scheduling at its core, the Robot Job Scheduling Solution reduces the opportunity for human error and helps you maintain service levels, automating even the biggest, most complex runbooks. Manage your job schedule with the Robot Job Scheduling Solution. Key features include:

  • LANSA Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.

  • LANSAWhen it comes to creating your business applications, there are hundreds of coding platforms and programming languages to choose from. These options range from very complex traditional programming languages to Low-Code platforms where sometimes no traditional coding experience is needed. Download our whitepaper, The Power of Writing Code in a Low-Code Solution, and:

  • LANSASupply Chain is becoming increasingly complex and unpredictable. From raw materials for manufacturing to food supply chains, the journey from source to production to delivery to consumers is marred with inefficiencies, manual processes, shortages, recalls, counterfeits, and scandals. In this webinar, we discuss how:

  • The MC Resource Centers bring you the widest selection of white papers, trial software, and on-demand webcasts for you to choose from. >> Review the list of White Papers, Trial Software or On-Demand Webcast at the MC Press Resource Center. >> Add the items to yru Cart and complet he checkout process and submit

  • Profound Logic Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application.

  • SB Profound WC 5536Join us for this hour-long webcast that will explore:

  • Fortra IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn: