What's a 4GL?
By this time, most of us have heard the term 4GL. Many of us know, that 4GL refers to a Fourth Generation Language. However, What is a Fourth Generation Language and what does a 4GL offer that we can’t already do by writing code by hand in a third generation language?

Eliminating drudgery
What a 4GL essentially is designed to do, is to eliminate the drudgery of designing screens and printed forms and reports. A 4GL does this by taking a set of parameters and then binding these parameters to create a table or subroutine that is processed by a software "engine". The software engine deals with the basic elements of screen placement, file management, data conversions, validations, choice selections, etc., depending on the particular "brand" of software engine you may investigate.

Rapid Deployment and accuracy
There are many valid reasons for adopting the use of a 4GL. A 4GL can eliminate the manual writing of code to deal with display, input and output. A 4GL will help organize program structure as well as noticable speed up the coding, testing, deploymment and maintenance of an application. Hence the term "Rapid Application Development". A good 4GL would be expected to create a screen with 10 or so fields, including a nested table such as an order-entry type scenario with multiple columns, in ten minutes or less… a lot faster than even the best, brightest and most gifted programmer could ever hope to accomplish by writing code.

More than just code
As many of us have come to realize over time, it’s not only the issue of CREATING CODE that is important. The major concern in systems today, is the burgeoning cost of maintaining, enhancing, and modifying applications to deal with the ever-changing policies of business, government regulations, and industry standards. It has been often calculated by universities, trade associations, independent research facilities, and large MIS departments, that the cost to maintain applications over their life is three to ten times what it cost to originally develop the applications.

Legacy replacements
In the case of legacy applications which are often "inherited" from previous owners or programmers who may have left the MIS department or company, the cost of maintenance can be much greater. There may be no one available who even understands the applications that need to be modified.

Reducing maintenance cost
Some of the simplest advantages come from the ability to add or move fields on a screen. This may not seem like much, but in a hand-coded environment, the simple act of moving 4 fields from the second line to the fourth line, could take from ten minutes to a day or more depending on the code that may need to be modified. A 4GL can enable the programmer to make the change in a minute or so with another few seconds for a re-compile on a fast processor. Adding a lookup field or validation can be as easy as placing an ACCESS statement in a dictionary field, and is often completed in under a minute.

Framework for operations
Most 4GL’s provide a standardized structure for adding specific business rules to applications. Depending on the sophistication of the environment, there are generally "event triggers" for providing "hooks" into an application. These triggers can deal with things such as PREFIELD, POSTFIELD, PREWRITE, POSTWRITE, LOAD TIME, READ TIME, VALIDATION, ICONV, OCONV, POST-DELETE, CORRELATIVE, EXIT, CHOICE, etc. Triggers offer a standardized way of adding or modifying business rules in an application. Changes can usually be made quickly, easily and often elegantly. By not having to deal with the overhead of input routines, file management, screen placement, legacy spaghetti code and it’s often numerous and tangled GOTO statements, a 4GL will reduce development and maintenance efforts and it's attendent costs.

Standardizing code
Another valuable by-product of a 4GL is the standardization of how things generally work. In an environment developed by manually coding applications, there often exist many styles of "how things work". As a programmer matures, his (or her) style usually changes, and with it, how applications seem to work. The keystrokes required to save an item may range from "F", "FI", <F1>, <F11>, "X" and others. While this is not often a problem to an experienced user of an application, it certainly causes confusion for new hires and increases the learning time.

Standardizing operations
What 4GL or Rapid Application Development environment will certainly do, is to provide a standardized method of how things work. Filing an item, Searching, Help, Exit, Cut, Paste, will essentially work the same in every application. This reduces the learning curve for new hires, reducing the workload at the support desk.

User friendly
Often overlooked, is the issue of user frustration that can be greatly reduced through the use of a 4GL. A 4GL/RAD tool-set facilitates the programmer to add "user-friendly" features such as "pull-down" menu’s, "pop-up" selections and choice lists which not only reduce the dependence on "cheat sheets" but also increase the reliability of data recorded in a system.

Security The speed of data entry can be increased with the availability of current information and context sensitive help. The burden for MIS departments having to provide printed customer lists, vendor lists, application choices, terms codes etc., is eliminated. Data security is enhanced because customer lists and other sensitive documents are not likely to float out the door or be found in the trash, if they don’t exist on paper.

Access to information - the "drill down"
Most 4GL’s provide the facility for a programmer to easily integrate a "drill down" into data. This can be something as simple as allowing the "jump" from an order-entry application to a part lookup, or a "drill" to the Customer maintenance screen to change a customer contact or address (security permitting). Other "drill-downs" can be setup from an order-entry screen into part setup, vendor maintenance etc.

On-line messaging.
The integration of notes and email in your applications is a feature which can often justify the purchase of some 4GL products. Nucleus Technology for one, incorporates an integrated messaging and email system that notifies a user of pending messages... and allow the user to get his/her messages, reply and return to the same screen and the same field without missing a beat.

What else?
Many 4GL products generally offer that "windows" look and feel – it looks nicer, is often more consistent, and is much easier to support than many legacy applications.

Bragging rights
If you’re a golfer, CEO or company president, you get the benefit of "bragging rights", to be able to say, "we can now deploy a new application in a day or less". It’s more though, than just bragging rights, it’s the difference between keeping up with competitors and really making progress. If you need to move ahead with plans for a new acquisition or deal with a significant change in industry standards, there isn’t time to spend ten days on program changes when one day "must do". If your application maintenance eats up 75% of your MIS budget, it’s easy to see why reducing maintenance costs and improving productivity is important.

In summary
Adding a 4GL or RAD tool can get your back-burner applications on line and make serious inroads in reducing the time and money spent on application maintenance. The flexibility offered by a 4GL product will easily increase the productivity of programmers by a factor of 5 – 10x and allow your staff to tackle complex projects that would not have been possible otherwise. Standardization of the application interface using a 4GL can quickly reduce the training efforts for new hires, as well as the workload at the help desk. Using simple validations, a 4GL will increase the accuracy and reliability of data in your system.

The next article
In the next article on 4GL’s, the author will review the implementation of a 4GL… what to do, what to expect, what it costs, and how to develop a practical plan for implementation.

About the author:
Lee Bacall, is President of BinaryStar Systems Inc, the developers of Nucleus Technology, a 4GL RAD tool. He has been involved in the development and implementation of Nucleus Technology at numerous client sites. Lee works out of the Ft Lauderdale office of Binary Star, and can be reached at 954/791-8575. Please visit the BinaryStar Website for additional information on the Nucleus 4GL. Your comments are welcome.